Question

How to open a new connection to MySQL database with MySQLi object-oriented in PHP

Answer 1

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$db_name = 'your_database_name';

$con = new mysqli($servername, $username, $password, $db_name);

if ($con->connect_error) {
    die("Connection failed: " .  $mysqli->connect_errno . " : " . $con->connect_error);
}
echo "Connection Success: " . $con->host_info;

$con->close();

/*
run:

Connection Success: localhost via TCP/IP

*/

 

70+ SQL courses for beginners and professionals