Home>Article>Backend Development> mysqli_query failed in php

mysqli_query failed in php

(*-*)浩
(*-*)浩 Original
2019-09-05 11:53:29 5615browse

mysqli_query failed in php

PHP mysqli_query() function

Definition and usage(Recommended learning:PHP video tutorial

mysqli_query() function executes a query against the database.

Syntax

mysqli_query(connection,query,resultmode);

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

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.

Execute a query against the database:

Delete database

// 假定数据库用户名: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 ('百度','https://www.baidu.com/','4','CN')");

mysqli_close($con);
?>

The above is the detailed content of mysqli_query failed 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