Re: Saving Image in mySQL

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