Home>Article>Backend Development> 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!