Easy Tutorial
❮ Func Simplexml Load File Func Filesystem Filesize ❯

PHP mysqli_query() Function

PHP MySQLi Reference Manual

Execute queries against the database:

Delete Database

<?php 
// Assume database username: root, password: 123456, database: tutorialpro 
$con = mysqli_connect("localhost", "root", "123456", "tutorialpro"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
} 

// Execute queries
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

Parameter Description
connection Required. Specifies the MySQL connection to use.
query Required. Specifies the query string.
resultmode Optional. A constant. Can be one of the following: MYSQLI_USE_RESULT (use this for retrieving large amounts of data) <br> MYSQLI_STORE_RESULT (default)

Technical Details

Return Value: Returns a mysqli_result object for successful SELECT, SHOW, DESCRIBE, or EXPLAIN queries. Returns TRUE for other successful queries. Returns FALSE on failure.
PHP Version: 5+
--- ---
Changelog: Asynchronous query functionality added in PHP 5.3.0.
--- ---

❮ Func Simplexml Load File Func Filesystem Filesize ❯