What is the correct syntax for using mysqli_query() function in PHP?

When using the mysqli_query() function in PHP, the correct syntax requires two parameters: the database connection object and the SQL query to be executed. Make sure to establish a connection to the database using mysqli_connect() or mysqli_init() before calling mysqli_query(). Additionally, always check for errors after executing the query to handle any potential issues. 

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

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

// Define the SQL query
$query = "SELECT * FROM table_name";

// Execute the query
$result = mysqli_query($connection, $query);

// Check for errors
if (!$result) {
    die("Query failed: " . mysqli_error($connection));
}

// Process the result set
while ($row = mysqli_fetch_assoc($result)) {
    // Do something with the data
}

// Close the connection
mysqli_close($connection);

Keywords

mysqli_query syntax function PHP database

Related Questions