Home  >  Article  >  Backend Development  >  The role of mysqli_query function in php

The role of mysqli_query function in php

藏色散人
藏色散人Original
2019-09-17 11:46:455655browse

The role of mysqli_query function in php

The role of mysqli_query function in php

Definition and usage

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

Syntax

mysqli_query(connection,query,resultmode);

Parameters

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)

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

PHP Version: 5

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

Execute a query against the database:

Delete the 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);
?>

Recommended tutorial:

PHP tutorial

The above is the detailed content of The role of mysqli_query function in php. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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