How can database connection be properly passed to mysqli_query in PHP 7.2?

When using mysqli_query in PHP 7.2, the database connection needs to be properly passed as the first parameter to the function. This can be achieved by first establishing a connection to the database using mysqli_connect or mysqli_init, and then passing that connection variable as the first parameter to mysqli_query. 

// Establish a connection to the database
$connection = mysqli_connect("localhost", "username", "password", "database_name");

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

// Perform a query using the established connection
$result = mysqli_query($connection, "SELECT * FROM table_name");

// Use the result as needed
// ...

// Close the connection
mysqli_close($connection);

Keywords

PHP 7.2 mysqli_query database connection error handling SQL injection

Related Questions