Question

How to connect to database using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli($db_host, $db_user, $db_password , $db_name);

if (mysqli_connect_errno()) 
    die("Connection Error: " . mysqli_connect_error() . "<br />");

$con->close();


/*
run: 


*/

 

70+ SQL courses for beginners and professionals

Answer 2

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = mysqli_connect($db_host, $db_user, $db_password, $db_name);

if (!$con) {
    echo "Error connect to MySQL" . PHP_EOL;
    echo "errno: " . mysqli_connect_errno() . PHP_EOL;
    exit;
}

echo "Connection Success";

mysqli_close($con);


/*
run: 

Connection Success 

*/

 

70+ SQL courses for beginners and professionals