[tomming]

Hello,I am here because I am very new about php.
First,I want to create a site to left people upload their photo,i want to know the basic how to upload photo to sql per user and resize it.I have a sql table which i get from website.


CREATE TABLE tbl_images (
id tinyint(3) unsigned NOT NULL auto_increment,
image blob NOT NULL,
PRIMARY KEY (id)
);

and dont forget to tell me how to retrieve image from the blob field
thank

[sandeep.kumar]

You should upload image to a folder and its name in database field.

Then you can easily retrieve image by name from database and Image from folder by name.

[groone]

This code might help you get started. Blob uses too much space, convert to text

Code:

     if (empty($_FILES['imgfile'])){
          echo '<form action="form.php" method="post" enctype="multipart/form-data" >
               <input type="file" name="imgfile">
               <input type="hidden" name="MAX_FILE_SIZE" value="1000000">
          </form>';
     }else{
          $image = $_FILES['imgfile'];
          //make sure this folder is writeable 666
          $path = '/home/user/public_html/images/';
          copy($image['tmp_name'], $path.$image['name']);

     //open file for reading
     $fp = fopen($path.$image['name'], "r");

          //measure the file contents
          $contents = fread($fp, filesize($path.$image['name']));

     //close the file
     fclose($fp);

     //encode the file to save space in the db
     $encoded = chunk_split(base64_encode($contents));

     //my assumption is that you already have a db setup with a longtext field.
     mysql_query("INSERT INTO images (ID, IMAGE) VALUES (" . $id . ",'" . $encoded . "')");

     //since it's inserted into mysql, you can delete the existing file
     unlink($path.$image['name']);
}

To get the image. Make sure there are no blank lines after the ?> or else it wont work

Code:

 <?php

     //My assumption is that you already have connected to the database somewhere
     //and the db has an id field
     $result=mysql_query("SELECT * FROM images WHERE ID='".$_GET['img']."'");

     //fetch data from database
     $data=mysql_fetch_array($result);

     $encoded=$data['data'];

     //close connection
     mysql_close($connection);

     //decode and echo the image data
     echo base64_decode($encoded);

?>

[End User]

Originally Posted by sandeep.kumar

You should upload image to a folder and its name in database field.

Then you can easily retrieve image by name from database and Image from folder by name.

I agree, there is rarely any good reason to store the actual image in the database itself.