我在提交表单时看到此错误错误错误:查询为空 - I am seeing this error on submitting form Error: query was empty

I am seeing this error on submitting form Error: query was empty

本文关键字：错误查询提交表单 | 更新日期: 2023-09-27

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}
mysql_select_db("lobbymen_hireus", $con);
$query = mysql_query("INSERT INTO hireus (name, cname, email, telephone)
                      VALUES (ashfaq, muhm, ashfaq@, 1234566)");
if (!mysql_query($query,$con))
{
  die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con);
?>

您需要正确格式化字符串以插入：

$query = mysql_query("INSERT INTO hireus (name, cname, email, telephone)
VALUES ('ashfaq', 'muhm', 'ashfaq@', '1234566')");

但这只是这个代码的冰山一角。。。

首先，您需要在值周围加引号，因为它们是字符串。您也在对查询进行查询，因此需要将$query更改为：

$query = "INSERT INTO hireus (name, cname, email, telephone)
    VALUES ('ashfaq', 'muhm', 'ashfaq@', '1234566')";

如果查询中有问题，应该是这样的：

$query = mysql_query("INSERT INTO hireus (name, cname, email, telephone) VALUES ('ashfaq', 'muhm', 'ashfaq@', '1234566')");

您执行了两次查询（第二次查询结果是查询，因此返回false），但您忘记了值周围的引号。应该是

$query = "INSERT INTO hireus (name, cname, email, telephone) VALUES ('ashfaq', 'muhm', 'ashfaq@', '1234566')";
if (!mysql_query($query,$con))
{
  die('Error: ' . mysql_error());
}
echo "1 record added";