PHP MYSQL Image upload Script

-

MySQL BLOB using PHP

BLOB is a kind of MySQL datatype referred as Binary Large Objects. As its name it is used to store huge volume of data as binary strings as similar as MYSQL BINARY and VARBINARY types.
mysql_blob

Classification of MySQL BLOB

MySQL BLOB Types Maximum Storage Length (in bytes)
TINYBLOB ((2^8)-1)
BLOB ((2^16)-1)
MEDIUMBLOB ((2^24)-1)
LONGBLOB ((2^32)-1)
In this MySQL tutorial let us learn to insert and read MySQL BLOB using PHP. To start with, we need to create a MySQL table with a BLOB column and the SQL script is,
output_images.sql
CREATE TABLE IF NOT EXISTS `output_images` (
  `imageId` tinyint(3) NOT NULL AUTO_INCREMENT,
  `imageType` varchar(25) NOT NULL DEFAULT '',
  `imageData` mediumblob NOT NULL,
  PRIMARY KEY (`imageId`)
)

Insert Image as MySQL BLOB

To insert an image into MySQL BLOB column the steps are,
  1. Upload image file.
  2. Get image properties (image data, image type and more.)
  3. Insert image file into BLOB.
PHP script to insert BLOB data is,
imageUpload.php
<?php
if(count($_FILES) > 0) {
if(is_uploaded_file($_FILES['userImage']['tmp_name'])) {
 $conn=mysqli_connect("localhost", "root", "","hoteldetail");
 //mysql_select_db ("phppot_examples");
 $imgData =addslashes(file_get_contents($_FILES['userImage']['tmp_name']));
 $imageProperties = getimageSize($_FILES['userImage']['tmp_name']);
 
 $sql = "INSERT INTO output_images(imageType ,imageData)
 VALUES('{$imageProperties['mime']}', '{$imgData}')";
 $current_id = mysqli_query($conn, $sql) or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($conn));
 if(isset($current_id)) {
  header("Location: listImages.php");
 }
}
}
?>
<HTML>
<HEAD>
<TITLE>Upload Image to MySQL BLOB</TITLE>
<link href="imageStyles.css" rel="stylesheet" type="text/css" />
</HEAD>
<BODY>
<form name="frmImage" enctype="multipart/form-data" action="" method="post" class="frmImageUpload">
<label>Upload Image File:</label><br/>
<input name="userImage" type="file" class="inputFile" />
<input type="submit" value="Submit" class="btnSubmit" />
</form>
</div>
</BODY>
</HTML>
After executing this script image upload form will be shown,
frmImageUpload.png
On form submit, this PHP code gets the content of the image file and stores it into the MySQL BLOB column as binary data.

Read Image BLOB to Display

For displaying BLOB images to the browser, we have to create a PHP file to do to following.
  • get image data and type from MySQL BLOB
  • Set the content-type as image (image/jpg, image/gif, …) using PHP header().
  • print image content.
imageView.php
<?php
 $conn = mysqli_connect("localhost", "root", "", "hoteldetail");
    //mysql_select_db("phppot_examples") or die(mysql_error());
    if(isset($_GET['image_id'])) {
        $sql = "SELECT imageType,imageData FROM output_images WHERE imageId=" . $_GET['image_id'];
  $result = mysqli_query($conn,"$sql") or die("<b>Error:</b> Problem on Retrieving Image BLOB<br/>" . mysqli_error($conn));
  $row = mysqli_fetch_array($result);
  header("Content-type: " . $row["imageType"]);
        echo $row["imageData"];
 }
 mysqli_close($conn);
?>
This PHP code will display MySQL image BLOB data. From HTML image tag we can refer this PHP file with corresponding image_id as an argument. For example,
<img src="imageView.php?image_id=<?php echo $row["imageId"]; ?>" />
listImages.php
<?php
    $conn = mysqli_connect("localhost", "root", "", "hoteldetail");
   // mysqli_select_db($conn, "phppot_examples");
    $sql = "SELECT imageId FROM output_images ORDER BY imageId DESC"; 
    $result = mysqli_query($conn, $sql);
?>
<HTML>
<HEAD>
<TITLE>List BLOB Images</TITLE>
<link href="imageStyles.css" rel="stylesheet" type="text/css" />
</HEAD>
<BODY>
<?php
 while($row = mysqli_fetch_array($result)) {
 ?>
  <img src="imageView.php?image_id=<?php echo $row["imageId"]; ?>" /><br/>
 
<?php  
 }
    mysqli_close($conn);
?>
</BODY>
</HTML>

Output

mysql_blob_output
This MySQL tutorial was added on December 30, 2013.

Comments

Post a Comment

Popular posts from this blog

Script For Login, Logout and View Using PHP, MySQL and Bootstrap

-
Image
I am assuming here that you are familiar with HTML and CSS. I have commented the code with the necessary information in the major part of the code. So you can understand easily. I have also attached the source code so you can download it and use it. Let's start. Note: I have updating this article on my personal blog. The following are the points we will be learn in this article: Creating Database in phpmyadmin. Create connection with MySQL database. Insert, delete and view data from MySQL database. Some Bootstrap components. Sessions in PHP. Files and IDE: Registration Login Logout Welcome Admin_login View_users Db_conection Delete.php I am using PHPStorm for the coding and Bootstrap framework for front end development. Create Database: Create Tables: Create columns in Users table: Crate Admin Table: Create Admin Columns: Registration.php: <html>   <head lang= "en" >      ...
Read more

Hyperledger Development with in 10 days — Day 6

-
Image
Chaincode Development Introduction For the first five days, we have seen the concepts of Hyperledger fabric and various components of it. We have started our own network, deployed the simple smart contract. We have done transactions, we transferred data privately. In this part we are going to look into Chaincode development aka smart contract development for Hyperledger Fabric. We know that chaincode is running in different docker container once it is instantiated on channel isolating from the peers. Typically smart contract is the business logic agreed by the members to execute with consensus. However within the same network multiple many chaincode might be running on different channels. “Without appropriate permissions a chaincode cannot invoke another chaincode”. Various levels of Chaincodes There are two perspective on chaincodes. First, the perspective of the developer who is developing blockchain application — Chaincode for developers Second, the bl...
Read more

Insert CheckBox and Radio button Data in MySQL Database Using PHP

-
Image
MY-SQL Code CREATE DATABASE IF NOT EXISTS databasename; CREATE TABLE students( student_name varchar(255) NOT NULL, student_email varchar(255) NOT NULL, student_contact varchar(255) NOT NULL, student_address varchar(255) NOT NULL, stars varchar(25) NOT NULL, sports varchar(25) NOT NULL, gender text(25) NOT NULL, )     Download Code     LIVE DEMO   page- formelements.php   php code <?php $connection = mysqli_connect("localhost", "root", "","formdatainsert"); // Establishing Connection with Server //$db = mysql_select_db("colleges", $connection); // Selecting Database from Server if(isset($_POST['submit'])){ // Fetching variables of the form which travels in URL $name = $_POST['name']; $email = $_POST['email']; $contact = $_POST['contact']; $address = $_POST['address']; $sports=implode(' , ',$_POST['sports']); $star=implode(' , ',$_POST['star']); ...
Read more