How can the error "No database selected" be resolved in PHP MySQL queries?

The error "No database selected" occurs when trying to execute SQL queries without specifying the database to use. To resolve this issue, you need to first select the database you want to work with before executing any queries. This can be done using the `mysqli_select_db()` function in PHP. 

// Connect to MySQL server
$connection = mysqli_connect("localhost", "username", "password");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Select the database
$db_selected = mysqli_select_db($connection, "database_name");

if (!$db_selected) {
    die ("Could not select database: " . mysqli_error());
}

// Now you can execute your queries
mysqli_query($connection, "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')");

// Close the connection
mysqli_close($connection);

Keywords

PHP MySQL database query error

Related Questions