Question

How to get the error code from last connect call to check if connection success with MySQLi in PHP

Answer 1

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

$con = mysqli_connect("localhost", $db_user, $db_password, $db_name);

if (!$con) 
    die('Connection Error: ' . mysqli_connect_errno());

mysqli_close($con);


/*
run: 


*/

 

70+ SQL courses for beginners and professionals

Answer 2

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

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

if ($con->connect_errno) 
    die('Connection Error: ' . $con->connect_errno);

mysqli_close($con);


/*
run: 


*/

 

70+ SQL courses for beginners and professionals