Database Insertion not working

Question

Why is the code below not inserting anything into the database table?

require_once"connection.php";
$target_Path='img/displays/';
$caption=$_POST['caption'];
$albums=$_POST['albums'];
$target_Path = $target_Path.basename($_FILES['photo']['name'] );
move_uploaded_file( $_FILES['photo']['tmp_name'], $target_Path);
$withoutExt = preg_replace("/\\.[^.\\s]{3,4}$/", "", $target_Path);
mysqli_query($connection,"INSERT INTO `ett`.`gallery` (`id` ,`album`,`name`,`path`)VALUES (`NULL`,`".$albums."`,`".$caption."`,`".$withoutExt."`)");

The code below works fine, but for some reasons the query above is not working. What is the problem?

mysqli_query($connection,"INSERT INTO `ett`.`gallery` (`id`, `album`, `name`, `path`) VALUES (NULL, '1', 'test', 'test')");

Take a look into your http servers error log file to _read_ what exactly the issue is instead of having to _guess_. — arkascha, Nov 26 '16 at 08:24
echo the query and try to write in direct database so that you can confirm query is correct or not — Deep Kakkar, Nov 26 '16 at 08:25
Don't use backticks for values, use single quotes. And nothing around null values. — Qirel, Nov 26 '16 at 08:37

score 0 · Accepted Answer · answered Nov 26 '16 at 14:34

0

Single quotes should be used around string values, not backticks

mysqli_query($connection,"INSERT INTO `ett`.`gallery` (`id` ,`album`,`name`,`path`)VALUES (NULL,'".$albums."','".$caption."','".$withoutExt."')");

answered Nov 26 '16 at 14:34

jophab

5,356
14
41
60

The link Qirel provided has much more info. Please refer that also even though this solves your problem – jophab Nov 26 '16 at 14:37
Thank you guys, both the link and your answer were useful – Mustafa Azad Nov 27 '16 at 09:08
@MustafaAzad You are welcome :) – jophab Nov 27 '16 at 09:15

Database Insertion not working

1 Answers1