🔌 PHP aur MySQL Ko Connect Kaise Karein? Complete XAMPP Beginner Guide (2026)

Agar aap PHP seekh rahe hain ya apni pehli dynamic website banana chahte hain, to sabse pehla concept hai PHP aur MySQL ko connect karna.

Login system, registration form, contact form ya kisi bhi database-driven website ke liye PHP aur MySQL ka connection zaroori hota hai.

Is guide me hum step by step samjhenge ki XAMPP ki madad se PHP ko MySQL database se kaise connect kiya jata hai.

---

📌 XAMPP Kya Hai?

XAMPP ek free local development environment hai jisme aapko milta hai:

• Apache Web Server
• MySQL (ya MariaDB)
• PHP
• phpMyAdmin

Iski madad se aap apne computer par locally PHP websites develop aur test kar sakte hain.

---

🛠️ Step 1: XAMPP Install Karein

Sabse pehle:

• XAMPP install karein.
• XAMPP Control Panel open karein.
• Apache aur MySQL services start karein.

Agar dono modules green dikh rahe hain, to local server ready hai.

---

🗄️ Step 2: Database Banayein

Browser me open karein:

http://localhost/phpmyadmin

Ab:

1. New par click karein.
2. Database ka naam dein.

Example:

user_login

3. Database create karein.

Uske baad ek table banayein.

Example:

Column	Type
id	INT (Primary Key, Auto Increment)
username	VARCHAR(100)
password	VARCHAR(255)

Password column ke liye VARCHAR(255) use karna recommended hai kyunki hashed passwords ki length zyada hoti hai.

---

💻 Step 3: PHP Se Database Connect Karein

Ek file banayein:

connect.php

Code:

<?php

$servername = "localhost";
$username = "root";
$password = "";
$database = "user_login";

$conn = mysqli_connect($servername, $username, $password, $database);

if (!$conn) {
    die("Connection Failed: " . mysqli_connect_error());
}

echo "Database Connected Successfully";

?>

File ko XAMPP ke htdocs folder me save karein.

Browser me open karein:

http://localhost/connect.php

Agar connection successful hai to confirmation message dikh jayega.

---

🔐 Step 4: Login Form Banayein

Example HTML Form:

<form action="login.php" method="POST">

<input type="text" name="username" placeholder="Username">

<input type="password" name="password" placeholder="Password">

<button type="submit">Login</button>

</form>

Ye form user data PHP file ko bhejega.

---

⚙️ Step 5: Login Logic

Basic example:

<?php

include("connect.php");

$username = $_POST['username'];
$password = $_POST['password'];

$sql = "SELECT * FROM users WHERE username=?";

$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, "s", $username);
mysqli_stmt_execute($stmt);

$result = mysqli_stmt_get_result($stmt);

if($row = mysqli_fetch_assoc($result)){

    if(password_verify($password, $row['password'])){
        echo "Login Successful";
    }else{
        echo "Invalid Password";
    }

}else{

    echo "User Not Found";

}

?>

Ye approach prepared statements aur password verification use karti hai, jo security ke liye recommended hai.

---

🔒 Password Ko Secure Kaise Store Karein?

Password ko kabhi bhi plain text me database me store na karein.

User registration ke time:

$password = password_hash($password, PASSWORD_DEFAULT);

Login ke time:

password_verify()

use karein.

Ye PHP ka recommended aur secure method hai.

---

🚨 Common Errors

❌ Access Denied

Username ya password galat ho sakta hai.

---

❌ Unknown Database

Database name verify karein.

---

❌ Table Doesn't Exist

Table ka naam check karein.

---

❌ Apache Start Nahi Ho Raha

Port 80 ya 443 kisi aur application ke use me ho sakta hai.

---

❌ Blank Page

PHP errors enable karke debugging karein aur syntax errors check karein.

---

📚 PHP + MySQL Se Kya Bana Sakte Hain?

Is combination ki madad se aap bana sakte hain:

✅ Login System

✅ Registration Form

✅ Student Management System

✅ Blog Website

✅ E-commerce Backend

✅ Admin Panel

✅ Contact Form

---

🚀 Agla Kya Seekhein?

PHP aur MySQL connect karne ke baad ye topics seekhein:

1. CRUD Operations (Create, Read, Update, Delete)
2. Sessions & Cookies
3. User Authentication
4. File Upload
5. Form Validation
6. PHP OOP
7. MVC Frameworks (Laravel)

---

🧠 Final Thoughts

PHP aur MySQL web development ke sabse popular combinations me se ek hain.

Agar aap beginner hain, to pehle local environment me projects banaiye aur database operations ki practice kijiye.

Sabse important baat, shuruaat se hi secure coding practices follow karein—jaise prepared statements aur password hashing. Ye habits future projects me bhi aapke kaam aayengi.

---

💬 Tum Batao:

Ab tum PHP me sabse pehle kya banana chahoge?

🔐 Login System

📝 Registration Form

🛒 E-commerce Website

📚 Student Management System

👇 Comment karke zaroor batana.