字段列表中的未知列. PHP + MySQL [英] Unknown Column in Field List. PHP + Mysql

问题描述

我试图将值添加到phpmyadmin中的表中，但出现错误:字段列表"中的未知列"...".

I'm trying to add values to a table in phpmyadmin and I get the error: Unknown column '...' in 'field list'.

这是我的代码:

    <?php   

    //preparing the patch to copy the uploaded file
    $target_path = "images/";

    //adding the name of the file, finishing the path
    $target_path = $target_path . basename( $_FILES['image']['name']); 

   //moving the file to the folder
   if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
       echo "The file ".  basename( $_FILES['image']['name']). 
       " has been uploaded";
   } else{
      echo "There was an error uploading the file, please try again!";
   }

   //getting input from the form
   $name = $_POST['game'];
   $description = $_POST['beschrijving'];

   //preparing the query to insert the values
   $query = "INSERT INTO tblGames (name, description, image) VALUES ($name,       $description,". $target_path .")";

   //opening connection to db
   $link = mysql_connect('localhost', 'root', '');
if (!$link) {
       die('Could not connect: ' . mysql_error());
}

     //selecting a db
mysql_select_db("BouncingGiani", $link) or die(mysql_error());

//running the query
$result = mysql_query($query) or die (mysql_error());

//closing the connection
mysql_close($link);

?>

因此，当我在上一页的表单中输入fds作为名称时，我得到:'字段列表'中的未知列'fds'. 这以前从未发生过，我也不知道发生了什么.

so when I enter fds as name in the form on the previous page I get : Unknown column 'fds' in 'field list'. This never happened to me before and I have no idea on what is going on.

推荐答案

我认为

$query = "INSERT INTO tblGames (name, description, image) VALUES ($name, $description,". $target_path .")";

应该是

$query = "INSERT INTO tblGames (name, description, image) VALUES ('$name', '$description', '". $target_path ."')";

这篇关于字段列表中的未知列. PHP + MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！