Saturday, 26 March 2011

image upload using mysql

if(isset($_POST['upload']))
 
      {
 
      if (isset($_FILES['photo']))
 
      {
 
     @list(, , $imtype, ) = getimagesize($_FILES['photo']['tmp_name']);
           
     if ($imtype == 3)
 
      $ext="png";

      elseif ($imtype == 2)
 
      $ext="jpeg";
 
      elseif ($imtype == 1)

      $ext="gif";

      else
 
      $msg = 'Error: unknown file format';
 
     
 
      if (!isset($msg))
 
      {

      $data = file_get_contents($_FILES['photo']['tmp_name']);
 
     $data = mysql_real_escape_string($data);
   
      mysql_query("INSERT INTO {$table}
 
      SET ext='$ext', title='$title',
 
      data='$data'"); //define your db.php and table name etc, its your job :)
       
      $msg = 'Success: image uploaded';
 
      }
 
      }
 
      }
 
    <form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
 
      <label for="title">Title:</label><br>
 
     <input type="text" name="title" id="title" size="64"><br><br>
 
      <label for="photo">Photo:</label><br>
 
      <input type="file" name="photo" id="photo"><br><br>
 
      <input type="submit" name="upload" value="upload">
        </form>for more info