SQL数据插入表错误

Question

I am trying to insert copy image to folder and save image path to SQL table. I have used the following code to store image in folder and path to database. When I run code image is copied but path of image is not stored in database.

if(move_uploaded_file($temp_name, $target_path)) {
    $query_upload="INSERT into 'images_tbl' ('images_path','submission_date') VALUES('".$target_path."','".date("Y-m-d")."')";
    mysql_query($query_upload) or die("error in $query_upload == ----> ".mysql_error());  

when I run it I get the following error

error in INSERT into 'images_tbl' ('images_path','submission_date') VALUES ('images/21-07-2014-1405927802.png','2014-07-21') == ----> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''images_tbl' ('images_path','submission_date') VALUES ('images/21-07-2014-14' at line 1

Answer 1

Your table name should not have single quotes around it, i.e. it should be:

INSERT INTO images_tbl ...

or

INSERT INTO `images_tbl` ... (note this uses backticks rather than single quotes)