Using PHP mysqli_query to Execute MySQL Queries

MySQL is a widely used relational database management system, and PHP provides functions to connect and operate it; the mysqli_query function is commonly used to execute SQL statements such as SELECT, INSERT, UPDATE, and DELETE.

';
}

// 释放结果集
mysqli_free_result($result);

// 关闭数据库连接
mysqli_close($connection);
?>

The example demonstrates creating a MySQL connection in PHP, running a SELECT query with mysqli_query , checking for errors, iterating over the result set using mysqli_fetch_assoc , and finally freeing the result and closing the connection.

Beyond SELECT, the same function can execute INSERT, UPDATE, DELETE, and other statements by passing the appropriate SQL string as the second argument.

The function returns a result set object for queries that produce data; developers can retrieve rows with mysqli_fetch_assoc , mysqli_fetch_row , or mysqli_fetch_array as needed.

In summary, using PHP’s mysqli_query offers a convenient way to perform various MySQL operations directly from server‑side code.