Database Connections:

Before accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect( ) Function.

Syntax:

mysqli_connect(“Server Name” , “User Name” , “Password” , “DB Name”);

This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name.

Managing Database Connections:

The below code snippet describes managing database connection methods and features<!--?php $servemame = “localhost”; $usemame = “username”; $password = “password”; SDB_name = “SchoolDB”;-->

<?php

$servemame = “localhost”;

$usemame = “username”;

$password = “password”;

SDB_name = “SchoolDB”;

// Create connection

$conn = mysqli_connect($servemame, Susemame, Spassword,$DB_name);

// Check connection

if(!$conn){

die(“Connection failed: “ . mysqli_connect_error( ));

}

echo “Connected successfully”;

?>

In the above code snippet, three variables are used to connect to the Database server. 

They are 

1. $servemame → Database Server Server IP address

2. $username → Database Server User Name

3. $password → Database Server Password 

4. $DBName → Database Name

The mysqli_connect function uses these variables and connect Database server from PHP scripting. If connection gets fail, output will be printed with MySQL error code. Otherwise connection is success.