Php storing url image path in MySQL DB

Question

I am trying to store URL Image paths into MySQL DB. But i am not getting any results with my code.

• Why is it not storing anything?
• Would it be better just to store the image name or the entire path? target example: "www.example.com/medium/imagename.jpg"

Table Name: urlimage

id: autoincrement
image_name 



Php code for inserting data into DB
<?php

$images = explode(',', $_GET['i']);

$path = Configuration::getUploadUrlPath('medium', 'target');


if(is_array($images)){

    $objDb = new PDO("mysql:host=" . $host . ";dbname=" . $db, $user, $pass);
    $objDb->exec('SET CHARACTER SET utf8');

    $sql = "INSERT INTO `urlImage` (`image_name`) VALUES ";

  foreach ($images as $image) {

    //echo '<div><p>' . $path . $image . '</p><img src="' . $path . $image . '" /></div>';
    $value[] = "(".$path.$image.")"; // collect imagenames
  }

  $sql .= implode(',', $value).";"; //build query

  $objDb->query($sql);   
}

?>

Answer 1

Try this; it may work:

$value[] = "('".$path.$image."')";

Answer 2

you have error in $sql

it must be $value[] = "('".$path.$image."')";

debug with

 echo "<pre>"; print_r($sql);echo "</pre>";

and if your using PDO function then call

prepare->execute