Re: Saving Image in mySQL

On 3/20/2013 8:43 AM, Toby Hart Dyke wrote:

You're right - you're pulling $file out of thin air. Once uploaded, the file is stored in $_FILES['file']['tmp_name'], and you need to manually read the data into $file yourself. Something like: file_get_contents($_FILES['file']['tmp_name']) Toby On 3/19/2013 8:15 PM, Ron Piggott wrote:

Hi All I don’t understand how to save an image to a mySQL table based on the following form. I am trying to do this using Prepared Statements. All the fields except the image file itself save in the database. Right now I have $file as the variable when binding the values. What should it be? Ron

# bind variables

         $stmt->bindValue(':caption', 'Test Caption', PDO::PARAM_STR);
         $stmt->bindValue(':image_type', $_FILES["file"]["type"],

PDO::PARAM_STR);

         $stmt->bindValue(':image_size', $_FILES["file"]["size"],

PDO::PARAM_INT);

         $stmt->bindValue(':image_name', $_FILES["file"]["name"],

PDO::PARAM_STR);

         $stmt->bindValue(':image', $file, PDO::PARAM_STR);

And in doing this your destination would then be the final resting place for the image(s), with the pointer to each stored in your table record for that image. :)