✅ 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!

Comments