30 Jan

Upload Image to MySQL using PHP

Upload Image to MySQL using PHP

As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload.
For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the end of the page.

As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite simple code with two php files one to display and one to upload.

For Image Upload code, I’ve added code download link upload-image-mysql-demo.zip at the end of the page.

CREATE TABLE `pix` (

`pic_id` int(11) NOT NULL auto_increment,

`pic_name` varchar(100) NOT NULL,

`pic_data` longblob NOT NULL,

PRIMARY KEY  (`pic_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Get 2 php files:- Image.php, showImage.php.

Set Connection parameters accordingly.

/* Image.php*/

<?php

$con = mysql_connect(“127.0.0.1:3306″,”root”,””);

if (!$con)

{

die(“Could not connect: ” . mysql_error());

}

$DB = mysql_select_db(“test”, $con);

move_uploaded_file($_FILES["uploadedfile"]["tmp_name"],”latest.img”);

$instr = fopen(“latest.img”,”rb”);

$image = addslashes(fread(fopen(“latest.img”,”r”),filesize(“latest.img”)));

mysql_query (“insert into pix (pic_name, pic_data) values (“myImage”, “‘.$image.’”);”);

?>

<html>

<form enctype=”multipart/form-data” method=”POST”>

<img src=showImage.php?gim=1 width=500 height=150 alt=”hell”>

<br><hr>

<input type=”hidden” name=”MAX_FILE_SIZE” value=”100000″ />

Choose a file to upload(<100 KB): <input name=”uploadedfile” type=”file” /><br/>

<input type=”submit” value=”submit” name=”submit” />

</form>

<html>

/*showImage.php*/

<?php

$con = mysql_connect(“127.0.0.1:3306″,”root”,””);

if (!$con)

{

die(“Could not connect: ” . mysql_error());

}

$DB = mysql_select_db(“test”, $con);

$res = @mysql_query(“select * from pix order by pic_id desc limit 1″);

if ($row = @mysql_fetch_assoc($res))

{

$title = htmlspecialchars($row[pic_name]);

$bytes = $row[pic_data];

}

header(“Content-type: image/jpg”);

print $bytes;

mysql_close();

?>

Click here to download zip file for above demo of Uploading image to mysql using php.

Leave a Reply

-- Kedar Vaijanapurkar --