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);   
}

?>

Are you getting any errors? In your php.ini set error_reporting = E_ALL | E_STRICT and display_errors = On if you have not done so. — F21
– F21, Commented Jul 5, 2012 at 5:21
of course, it's better to store filenames instead of entire path. Think about it: Entire path takes lot's memory for the same string... Define simple const or var instead of path — Yang
– Yang, Commented Jul 5, 2012 at 5:33
@diEcho yea after putting what you told me i got: "Parse error: syntax error, unexpected T_VARIABLE" for $objDb->query($sql); — user1434156
– user1434156, Commented Jul 5, 2012 at 5:34

Krishna · Accepted Answer · 2012-07-05 14:49:36Z

2

Try this; it may work:

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

edited Jul 5, 2012 at 14:49

user142162

answered Jul 5, 2012 at 5:30

Krishna

3532 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

xkeshav · Accepted Answer · 2012-07-05 05:38:02Z

0

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

edited Jul 5, 2012 at 5:38

answered Jul 5, 2012 at 5:27

xkeshav

54.2k47 gold badges183 silver badges255 bronze badges

1 Comment

user1434156 Over a year ago

yea after putting what you told me i got: "Parse error: syntax error, unexpected T_VARIABLE" for $objDb->query($sql);

Collectives™ on Stack Overflow

Php storing url image path in MySQL DB

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related