PHP mysqli_query()Function

PHP MySQLi 参考手册PHP MySQLi Reference Manual

Execute a query against the database:

Query Database

<?php //Assume database username: root, password: 123456, database: EXAMPLE $con=mysqli_connect("localhost","root","123456","EXAMPLE"); if (mysqli_connect_errno($con)) { echo "Connection to MySQL failed:" . mysqli_connect_error(); } //Execute query mysqli_query($con,"SELECT * FROM websites"); mysqli_query($con,"INSERT INTO websites (name, url, alexa, country) VALUES ('Baidu','https://www.baidu.com/','4','CN')"); mysqli_close($con); ?>

Definition and Usage

The mysqli_query() function executes a query against the database.

Syntax

mysqli_query(connection,query,resultmode);

Parameters Description
connection Required. Specifies the MySQL connection to use.
query Required. Specifies the query string.
resultmode

Optional. A constant. Can be any of the following values:

  • MYSQLI_USE_RESULT (use this if you need to retrieve a large amount of data)
  • MYSQLI_STORE_RESULT (default)

Technical Details

Return value: For successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries, it returns a mysqli_result object. For other successful queries, it returns TRUE. If it fails, it returns FALSE.
PHP Version: 5+
Changelog: Asynchronous query functionality was added in PHP 5.3.0.

PHP MySQLi 参考手册PHP MySQLi Reference Manual Other Extensions