PHP mysqli_query() function

Author：Eve Cole Update Time：2025-01-01 13:36:01

Execute a query against the database:

Delete database

<?php // Assume database username: root, password: 123456, database: CODERCTO $con = mysqli_connect ( " localhost " , " root " , " 123456 " , " CODERCTO " ) ; if ( mysqli_connect_errno ( $con ) ) { echo " Failed to connect to MySQL: " . 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.

grammar

 mysqli_query( connection,query,resultmode ) ;

parameter	describe
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 large amounts of data) MYSQLI_STORE_RESULT (default)

parameter

describe

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 large amounts of data)

MYSQLI_STORE_RESULT (default)

technical details

Return value:	For a successful SELECT, SHOW, DESCRIBE, or EXPLAIN query, a mysqli_result object is returned. For other successful queries, TRUE will be returned. If it fails, returns FALSE.
PHP version:	5+
Update log:	The asynchronous query function is added in PHP 5.3.0.