Connect to MYSQL Databse with PHP

Run XAMPP and start Apache and MYSQL :



Open phpmyadmin :



Click New -> enter Database Name -> click create






Create connection.php file in htdocs folder and  save :



Run Connection.php file in Any Browser :




<?php
 
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    $dbname ='mydb';

    //Create Connection

    $conn = mysqli_connect($dbhost , $dbuser , $dbpass , $dbname);
       
    //Check Connection

    if( !$conn )
    {
    die('Could not connect: ' . mysqli_error());
    }
    echo 'Connected successfully';
   
//Close Connection

    mysqli_close($conn);

?>

Explaination :

$dbhost - servername
$dbuser - username of database
$dbpass - password of database
$dbname - name of the database with you want to connect

mysqli_connect - establishes a connection with MYSQL Database

mysqli_close($conn) - close the connection