Re: Saving Image in mySQL

Ron,
If your hell bent on storing the image data. :P
I would say base64 the data and use a blob or text
then read it out using something like..

$image = '<img src="data:'.$image_data.'" />';
echo($image);

I would also say your individual image max size should be 50k or less.
If your storing product images for a catalog for instance, dont store  
image data, use the url instead.
If its ui images for a couple of web pages, then storing the image  
data wouldn't be a bad thing.
As long as the total size for all of your images is reasonable.
Your call.

Best,
Karl


On Mar 19, 2013, at 6:11 PM, Karl DeSaulniers wrote:

> Hey Ron,
> I don't know how others feel, but I say save yourself a headache and  
> dont store the image data, just the url to the image on the server.
>
> image_url – VARCHAR 100
>
> Best,
> Karl
>
>
>
> On Mar 19, 2013, at 3: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
>>
>> ===
>> <form action="add_my_image.php" method="post"
>> enctype="multipart/form-data">
>> <label for="file">Filename:</label>
>> <input type="file" name="file"><br>
>> <input type="submit" name="submit" value="submit">
>> </form>
>> ===
>>
>> mySQL table structure:
>> ===
>> reference – INT 10 auto_increment primary
>> caption – VARCHAR 250
>> image_type – VARCHAR 100
>> image_size – INT 10
>> image_name – VARCHAR 100
>> image – LONGBLOB
>> ===
>>
>> Prepared Statement:
>>
>> ===
>> # mySQL query
>>
>>   $query = "INSERT INTO `my_images` ( `reference` , `caption` ,  
>> `image_type` , `image_size` , `image_name` , `image` ) VALUES  
>> ( NULL 
>>  , :caption , :image_type , :image_size , :image_name , :image );";
>>
>> # apply query to Prepared Statement
>>
>>   if($stmt = $dbh->prepare( $query )) {
>>
>> # 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);
>>
>> # execute query
>>
>>           if ( $stmt->execute() or die(print_r($stmt->errorInfo(),  
>> true)) ) {
>>
>> # retrieve auto_increment value
>>
>>               $new_record_reference = $dbh->lastInsertId();
>>
>>           }
>>
>>   }
>> ===
>>
>>
>> Ron Piggott
>>
>>
>>
>> www.TheVerseOfTheDay.info
>
> Karl DeSaulniers
> Design Drumm
> http://designdrumm.com
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

Karl DeSaulniers
Design Drumm
http://designdrumm.com


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php