✅ How to Connect PHP with MySQL (Step-by-Step)

 

 Connect PHP with MySQL (Step-by-Step)

---

📌 Title: How to Connect PHP with MySQL Database (Beginner Friendly)

🔹 Step 1: Create MySQL Database

In phpMyAdmin, run this:

CREATE DATABASE test_db;

---

🔹 Step 2: Create a Table

USE test_db;

CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100)
);

---

🔹 Step 3: Connect PHP to MySQL

<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "test_db";

$conn = mysqli_connect($host, $user, $password, $database);

if ($conn) {
    echo "Connected successfully!";
} else {
    echo "Connection failed: " . mysqli_connect_error();
}
?>

---

✅ Output

You should see: Connected successfully!