Image upload and retrieve in a Binary method using php and mysql

Tweet

Inserting Image 

<?php

// Create MySQL login values and
// set them to your login information.

$username = "root";
$password = "123";
$host = "localhost";
$database = "test";

// Make the connect to MySQL or die
// and display an error.

$link = mysql_connect($host, $username, $password);

if (!$link)
 {
    die('Could not connect: ' . mysql_error());
 }
// Select your database
mysql_select_db ($database);
// Make sure the user actually
// selected and uploaded a file
if (isset($_FILES['image']) && $_FILES['image']['size'] > 0)
 {
      // Temporary file name stored on the server
      $tmpName  = $_FILES['image']['tmp_name']; 
      // Read the file
      $fp      = fopen($tmpName, 'r');
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);


      // Create the query and insert
      // into our database.
      $query = "INSERT INTO tbl_images ";
      $query .= "(image) VALUES ('$data')";
      $results = mysql_query($query, $link);
      // Print results
      print "Thank you, your file has been uploaded."; 
}
else
{
     print "No image selected/uploaded";
}
// Close our MySQL Link
mysql_close($link);
?> 

Displaying Images

<?php
$username = "root";
$password = "123";
$host = "localhost";
$database = "test";
@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());
@mysql_select_db($database) or die("Can not select the database: ".mysql_error());
$query = mysql_query("SELECT * FROM tbl_images");
while($row = mysql_fetch_array($query))
{
echo '<img src="data:image/jpg;base64,'.base64_encode($row['image']).'" /><br /><br /><br />';
}
?>

Download