错误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
本文介绍了错误PHP>警告:mysql_query()期望参数1是字符串,资源在C:\xampp\htdocs\test1\Database.php在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>警告:mysql_query()期望参数1是字符串,资源在C:\xampp\htdocs\test1\Database.php在29行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文