Question

How to change database to run queries on other database using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';
 
$con = new mysqli('localhost', $db_user, $db_password, $db_name);
 
if ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);
 
// Change database to webshopy database
$con->select_db("webshopy");

if ($result = $con->query("SELECT DATABASE()")) 
{
    $row = $result->fetch_row();
    echo "Default database now is: " . $row[0];
    $result->close();
}

$con->close();

/*
run: 

Default database now is: webshopy  

*/

 

70+ SQL courses for beginners and professionals