php - 为什么我无法将文件路径插入数据库或存储图像？ PHP

Question

我在将图像上传到文件夹并将相应的文件路径插入数据库时​​遇到很多问题。

这就是我尝试过的:

$target_dir = "img/posts";
$target_file = $target_dir . basename($_FILES["imageUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);

if (move_uploaded_file($_FILES["imageUpload"]["tmp_name"], $target_file)) {
    echo "The file ". basename( $_FILES["imageUpload"]["name"]). " has been uploaded.";
} else {
    echo "Sorry, there was an error uploading your file.";
}

$image=basename( $_FILES["imageUpload"]["name"],".jpg"); // used to store the filename in a variable

//storind the data in your database
$query= "INSERT INTO posts `post_image` VALUES ('$image')";
mysql_query($query);

我应该如何进行？

Answer 1

插入查询语法为

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

在()内写入列

$query= "INSERT INTO posts (`post_image`) VALUES ('$image')";

                          ^^^^         ^^^

NOTE:- mysql is deprecated instead use mysqli Or PDO