Home > Backend Development > PHP Tutorial > PHP mysqli_query() function definition and usage

PHP mysqli_query() function definition and usage

巴扎黑
Release: 2023-03-07 21:26:02
Original
5484 people have browsed it

Definition and usage

mysqli_query() function executes a query against the database.

Syntax

mysqli_query(connection,query,resultmode);
Copy after login

Parameter description:

connection Required, specifies the MySQL connection to be used.

query Required, specifies the query string.

resultmode Optional. a constant. Can be any of the following values:

1.MYSQLI_USE_RESULT (use this if you need to retrieve a large amount of data)

2.MYSQLI_STORE_RESULT (default)

Return value:

For a successful SELECT, SHOW, DESCRIBE or EXPLAIN query, a mysqli_result object will be returned. For other successful queries, TRUE will be returned. On failure, returns FALSE.

Update log: The asynchronous query function is added in PHP 5.3.0.

PHP mysqli_query() function usage example:

Execute a query against the database:

Delete database

<?php // 假定数据库用户名:root,密码:123456,数据库:RUNOOB $con=mysqli_connect("localhost","root","123456","RUNOOB"); 
if (mysqli_connect_errno($con)) { 
    echo "连接 MySQL 失败: " . mysqli_connect_error(); 
} 
 // 执行查询mysqli_query($con,"SELECT * FROM websites");mysqli_query($con,"INSERT INTO websites (name, url, alexa, country)
VALUES (&#39;百度&#39;,&#39;https://www.baidu.com/&#39;,&#39;4&#39;,&#39;CN&#39;)"); 
mysqli_close($con);?>
Copy after login

The above is the detailed content of PHP mysqli_query() function definition and usage. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template