为什么评论没有上传到MySQL数据库？(Why are comments not being uploaded to MySQL Database?)

我有一个网页，旨在允许用户上传文件并提交评论。然后应将文件和相应的注释输入MySQL数据库。目前，如果有人试图这样做，则上传文件并将链接插入到数据库中。但是，注释永远不会进入数据库。该网页包含以下代码：

文件uploadform.php由哪个给出

<form enctype="multipart/form-data" method="POST"> Comment:<br /> <textarea name='comment' id='comment'></textarea><br /> <input type="hidden" name="MAX_FILE_SIZE" value="10000000" /> Choose a file to upload: <input name="uploadedfile" type="file" /><br /> <input type="submit" value="Submit" /> </form>

文件uploader.php包含以下内容：

<?php if( $_POST ){ // Where the file is going to be placed $target_path = "uploads/"; /* Add the original filename to our target path. Result is "uploads/filename.extension" */ $target_path = $target_path .time() .basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "The <a href=" . $target_path . ">file</a> has been uploaded! <br /> LINK: " . $target_path; $con = mysql_connect("localhost","theshitp_user","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("theshitp_posts", $con); $query = " INSERT INTO `theshitp_posts`.`test2` (`file`) VALUES ( '$target_path' );"; mysql_query($query); echo "<p style='color: grey;'><b>Thank you for your Comment!</b></p>"; mysql_close($con); } else{ echo "There was an error uploading the file, please try again!"; } } ?>

并且文件testpost.php包含

<? if( $_POST ) { $con = mysql_connect("localhost","theshitp_user","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("theshitp_posts", $con); $users_comment = $_POST['comment']; $users_comment = mysql_real_escape_string($users_comment); $query = " INSERT INTO `theshitp_posts`.`test2` (`id`, `comment`, `timestamp`) VALUES (NULL, '$users_comment', CURRENT_TIMESTAMP() );"; mysql_query($query); echo "<p style='color: grey;'><b>Thank you for your Comment!</b></p>"; mysql_close($con); } ?>

任何人都可以看到为什么文件链接正在输入数据库，但评论不是吗？ id和timestamp字段也正确输入数据库。

I have a webpage intended to allow users to upload a file and submit a comment. The file and respective comment should then be input into a MySQL database. Currently, if someone tries to do this, the file is uploaded and the link is inserted into the database as it should be. However, the comment never gets entered into the database. The webpage has the following code:

Where the file uploadform.php is given by

<form enctype="multipart/form-data" method="POST"> Comment:<br /> <textarea name='comment' id='comment'></textarea><br /> <input type="hidden" name="MAX_FILE_SIZE" value="10000000" /> Choose a file to upload: <input name="uploadedfile" type="file" /><br /> <input type="submit" value="Submit" /> </form>

The file uploader.php contains the following:

<?php if( $_POST ){ // Where the file is going to be placed $target_path = "uploads/"; /* Add the original filename to our target path. Result is "uploads/filename.extension" */ $target_path = $target_path .time() .basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "The <a href=" . $target_path . ">file</a> has been uploaded! <br /> LINK: " . $target_path; $con = mysql_connect("localhost","theshitp_user","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("theshitp_posts", $con); $query = " INSERT INTO `theshitp_posts`.`test2` (`file`) VALUES ( '$target_path' );"; mysql_query($query); echo "<p style='color: grey;'><b>Thank you for your Comment!</b></p>"; mysql_close($con); } else{ echo "There was an error uploading the file, please try again!"; } } ?>

And the file testpost.php contains

<? if( $_POST ) { $con = mysql_connect("localhost","theshitp_user","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("theshitp_posts", $con); $users_comment = $_POST['comment']; $users_comment = mysql_real_escape_string($users_comment); $query = " INSERT INTO `theshitp_posts`.`test2` (`id`, `comment`, `timestamp`) VALUES (NULL, '$users_comment', CURRENT_TIMESTAMP() );"; mysql_query($query); echo "<p style='color: grey;'><b>Thank you for your Comment!</b></p>"; mysql_close($con); } ?>

Can anyone see why file links are being entered into the database as they should, but comments are not? The id and timestamp fields are also being entered correctly into the database.