PHP 中的 mysqli query函数

mysqli query - 语法

mysqli_query(connection,query,resultmode);

它对数据库执行查询。

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($connection_mysql,"SELECT * FROM emp");
   mysqli_query($connection_mysql,"INSERT INTO emp (name) VALUES ('PHP')");
   mysqli_close($connection_mysql);
?>