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.
