How to Connect MySQL DB with PHP

Here I will tell you how to connect MySQL Database with PHP website. Kindly follow the below steps to further process.

• Firstly Check Connection

<?php  

$host = 'localhost';  

$user = '';  

$pass = '';  

$conn = mysqli_connect($host, $user, $pass);  

if(! $conn )  

{  

  die('Could not connect Please check: ' . mysqli_error());  

}  

echo 'Woohoo, Connected successfully';  
mysqli_close($conn); 
?>

• Create the database

<?php  

$host = 'localhost';  

$user = '';  

$pass = '';  

$conn = mysqli_connect($host, $user, $pass);  

if(! $conn )  

{  

  die('Could not connect Please check: ' . mysqli_error());  

}  

echo 'Woohoo, Connected successfully';  

$sql = "CREATE DATABASE testingdb";

if (mysqli_query( $conn,$sql)) {

    echo "Woohoo, Your database created successfully";

} else {

    echo "Sorry, database creation failed please check: " . $conn->error;

}

mysqli_close($conn); 

>?