How to connect with database in three step in php

Follow the step

Step 1:  Create Database and table.

 

Step2: Enter hostname, Database name.

Step3:Insert Data and Execute the Query.

This is my database and my database name is registration and table name is user.

We are inserting  a data statically(already data is selected).

        
<?php

$username = "root";

$password = "";

$hostname = "localhost";

$database_name='registration';

$password=” ”;

$dbhandle = mysqli_connect('localhost',$username ,$password,$database_name)

or die("Unable to connect to MySQL");

 $name ="Gaurav";

$password1="1234";

 $email="gauravrautela123@gmail.com";

 $query="insert into user set name='".$name."',password='".$password1."', email='".$email."'"; 
$execute =  mysqli_query($dbhandle, $query);

 If($execute)

     {

                 echo "Congrats Data inserted";

 }else{

                echo  "Something Going Wrong";

}

?>

After Insertion :

Terminology:

mysqli_connect(): It is php connection method,we can pass  four argument hostname,username,password,Database name.

Die();It stop the rest of exection if die methiod will exectute and show the

messages.