无涯教程-PHP - mysqli query函数

98 阅读1分钟

mysqli query - 语法

mysqli_query(connection,query,resultmode);

它对数据库执行查询。

Sr.No 参数 & Description
1

connection

它指定要使用的连接

2

query

它指定查询字符串

3

resultmode

它指定MYSQLI_USE_RESULT

mysqli query - 返回值

如果选择(SELECT)、显示(SHOW)、描述(DESCRIBE)或解释(EXPLAIN)查询成功,则返回true;如果失败,则返回false。

mysqli query - 示例

<?php
   $connection_mysql=mysqli_connect("localhost","user","password","db");

if (mysqli_connect_errno($connection_mysql)){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); }

mysqli_query(connectionmysql</span><spanclass="pun">,</span><spanclass="str">"SELECTFROMemp"</span><spanclass="pun">);</span><spanclass="pln">mysqliquery</span><spanclass="pun">(</span><spanclass="pln">connection_mysql</span><span class="pun">,</span><span class="str">"SELECT * FROM emp"</span><span class="pun">);</span><span class="pln"> mysqli_query</span><span class="pun">(</span><span class="pln">connection_mysql,"INSERT INTO emp (name) VALUES (PHP)"); mysqli_close($connection_mysql); ?>

参考链接

www.learnfk.com/php/php-fun…