我尝试将用户评论上传到我的数据库中.在我点击提交后，一切看起来都很好，但我在数据库中查看，没有记录

Question

我尝试了一些网站上的教程。

我尝试将用户评论上传到我的数据库中。在我点击提交后，一切看起来都很好，但我在数据库中查看，没有记录。

这是php代码

$dbhost = 'localhost:8090';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if( $_POST ){
    $con = mysql_connect("localhost","root","password");
}
if(!$con){ die('Could not find db');}
mysql_select_db("doctorapp", $con);
$ticket_user_fname = $_POST['fname'];
$ticket_user_lname = $_POST['lname'];
$ticket_email =$_POST['email'];
$ticket_hp =$_POST['contact_number'];
$ticket_content = $_POST['content'];
$ticket_category = $_POST['category'];
$query =" INSERT INTO `ticketing`(`ticket_id`, `fname`, `email`, `content`, `category`, `contact_number`, `lname`) 
VALUES ('ticket_id','ticket_time','ticket_user_fname','ticket_email','ticket_conetnt','ticket_category','ticket_hp','ticket_lname') ";
mysql_query($query);
echo "<h3>We will rreply you as soon as possible. Thank You.</h3>";
mysql_close($con);
?>

我是php的新手。非常感谢。

Answer 1

您可能忘记了将$放在变量之前

$query =" INSERT INTO `ticketing`(`ticket_id`, `fname`, `email`, `content`, `category`, `contact_number`, `lname`) 
          VALUES 
          ('$ticket_id','$ticket_time','$ticket_user_fname','$ticket_email','$ticket_content',
           '$ticket_category','$ticket_hp','$ticket_user_lname') ";

在使用$ticket_id和$ticket_time之前，请确保您也定义了它们，如果ticket_id是表的主键，那么它将是唯一性的自动增量，您不需要单独插入它。

Answer 2

试试这个：

$dbhost = 'localhost:8090';
$dbuser = 'root';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Could not find db');;
mysql_select_db("doctorapp", $con);
$ticket_user_fname = $_POST['fname'];
$ticket_user_lname = $_POST['lname'];
$ticket_email =$_POST['email'];
$ticket_hp =$_POST['contact_number'];
$ticket_content = $_POST['content'];
$ticket_category = $_POST['category'];
$query =" INSERT INTO `ticketing`(`ticket_id`, `fname`, `email`, `content`, `category`, `contact_number`, `lname`) 
VALUES ('$ticket_id','$ticket_time','$ticket_user_fname','$ticket_email','$ticket_conetnt','$ticket_category','$ticket_hp','$ticket_lname') ";
if(mysql_query($query, $conn)){
  echo "<h3>We will rreply you as soon as possible. Thank You.</h3>";
}
?>

您忘记了插入记录中的$