How to Connect PHP with MySQL in XAMPP (2025) – Complete Hinglish Guide
- Get link
- X
- Other Apps
๐ PHP aur MySQL Ko Connect Kaise Karein using XAMPP? (2025 Beginner Guide)
Agar aap PHP seekh rahe ho ya ek beginner web developer ho, to sabse important concept hai — PHP aur MySQL ko connect karna. Chahe aap login form bana rahe ho ya koi dynamic website, database connection ke bina kuch possible nahi.
2025 mein bhi PHP projects kaafi useful aur beginner-friendly hain. Is blog mein aapko milega step-by-step guide jisme hum XAMPP server ke through MySQL aur PHP ko connect karenge — aur ek simple user login form ka backend bhi banayenge.
๐งฐ Step 1: XAMPP Install Aur Setup
Sabse pehle, XAMPP software ko Apache Friends ki official website se download karo. Ye tool ek all-in-one package hai jisme aapko milega:
-
Apache (Server)
-
MySQL (Database)
-
PHP (Scripting Language)
-
phpMyAdmin (Database GUI Tool)
✅ Install karne ke baad XAMPP ko open karo aur Apache aur MySQL ko Start kar do.
๐ ️ Step 2: Create MySQL Database
Ab hume ek database banana hai jisme user login data store hoga.
-
Browser me jao aur type karo:
http://localhost/phpmyadmin
-
"New" pe click karo aur database ka naam do:
user_login
-
Table create karo:
users
-
id
– INT – Primary Key – Auto Increment -
username
– VARCHAR(100) -
password
– VARCHAR(100)
-
๐ป Step 3: PHP Code to Connect MySQL
Ab PHP code likhte hain jo is database se connect hoga.
php
<?php$servername = "localhost";
$username = "root";
$password = "";
$database = "user_login";
// Connection
$conn = mysqli_connect($servername, $username, $password, $database);
// Check Connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
} else {
echo "Connected Successfully!";
}
?>
๐ Is code ko save karo as connect.php
in htdocs
folder.
Test karne ke liye browser me jao:
๐ http://localhost/connect.php
Agar "Connected Successfully!" dikhe to connection kaam kar raha hai!
๐ Step 4: Login Form (HTML + PHP)
Ab ek simple login form banaate hain jiska backend PHP se connected hoga.
login.html
html
<form action="login.php" method="post"> <label>Username:</label>
<input type="text" name="username" required><br>
<label>Password:</label>
<input type="password" name="password" required><br>
<input type="submit" value="Login">
</form>
login.php
php
<?phpinclude('connect.php');
$user = $_POST['username'];
$pass = $_POST['password'];
$sql = "SELECT * FROM users WHERE username='$user' AND password='$pass'";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) == 1) {
echo "Login Successful!";
} else {
echo "Invalid username or password!";
}
?>
⚠️ Note: Real-world apps me passwords ko kabhi bhi plain text me store na karein. Always use password hashing (
password_hash()
andpassword_verify()
in PHP).
๐ ️ Step 5: Common Troubleshooting Tips
-
✔️ XAMPP start nahi ho raha? Port 80 busy ho sakta hai. Skype ya IIS stop karo.
-
✔️ "Access denied" error aata hai? Username ya password check karo.
-
✔️
mysqli_connect_error()
error dikha raha hai? Database ka naam galat ho sakta hai. -
✔️ Form submit nahi ho raha? Method type (
post
yaget
) check karo.
๐ Final Thoughts: PHP + MySQL = Powerful Combo!
Ab aapne seekh liya:
✅ XAMPP ka setup
✅ Database banana
✅ PHP se connection
✅ Login form backend kaise kaam karta hai
Yeh sab knowledge aapke college projects, internships, ya even freelance work ke liye kaafi kaam aayega.
๐ฃ Bonus Tips:
-
๐ Secure login ke liye
password_hash()
use karo -
๐ Folder naming and file path sahi rakhna zaroori hai
-
๐ Localhost me sab kaam ho raha hai, but live website pe bhi similar concept lagega
๐ Subscribe & Learn More
๐ฌ Niche comment karke batana — agla tutorial kis topic pe chahiye?
- Get link
- X
- Other Apps
Comments
Post a Comment
Have a question or suggestion? Drop it below!