错误PHP>警告：mysql_query（）期望参数1是字符串，资源在C：\xampp\htdocs\test1\Database.php在29行 [英] Error PHP> Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\test1\Database.php on line 29

问题描述

这是我的程序>

//Creat a connection to database
$selected = mysql_select_db("test1",$dbhandle)
  or die("Could not select test1");

//Creat table
$sql="CREATE TABLE Persons(FirstName CHAR(30),LastName CHAR(30),Age INT)";

//Execute query
if (mysql_query($sql,$dbhandle))
  {
  echo "Table persons created successfully";
  }
else
  {
  echo "Error creating table: " . mysql_error($dbhandle);
  }

mysql_query($dbhandle,"INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Naruto', 'Uzumaki', 18)");

mysql_query($dbhandle,"INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Sasuke', 'Uchiha', 18)");

mysql_query($dbhandle,"INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Pain', 'Uzumaki', 18)");

mysql_close($dbhandle);
?>

<<

有这些错误>

Connected to MySQL
Error creating table: Table 'persons' already exists
Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\test1\Database.php on line 29

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\test1\Database.php on line 32

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\test1\Database.php on line 35

<

我能做什么！？我真的需要帮助，请告诉我，我刚开始学习，我不明白什么是错的。

what can i do!? i really need help, please tell me, i just started to learn and i dont understand what is wrong..

推荐答案

查询应为：

mysqli_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Naruto', 'Uzumaki', 18)",$dbhandle);

mysqli_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Sasuke', 'Uchiha', 18)",$dbhandle);

mysqli_query("INSERT INTO Persons (FirstName, LastName, Age)
VALUES ('Pain', 'Uzumaki', 18)",$dbhandle);

这篇关于错误PHP&gt;警告：mysql_query（）期望参数1是字符串，资源在C：\xampp\htdocs\test1\Database.php在29行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！