Category: php

How to get images out of mysql database with php and use them on my webpages

This tutorial expands on another database/image how-to How to Store Images in Mysql Database. In the Images In tutorial I showed you the basic steps to opening a file (your image file) and read it into a variable ($img), convert that file using php's base64_encode() function, and stick that file into a Mysql database. Now, you will learn how to bring those images back out of your Mysql database, and output them to a web browser.

Retrieving Images From Mysql Database With php

This Tutorial will cover two different ways of taking images out of a mysql database and rendering them with a php document.

1. Create a mysql database with a table matching (Database Example)
• Database name is "test_imgs"
• Table name is pictures
• "id" is primary, key, not null, and auto_increment
• "pics" blob not null
• "ext" is varchar(4) not null
• "gender" is varchar(7) not null
• I will assume English mysql defaults for everything else.
• Practice script "test.php"

Database Example

id	pics	ext	gender
1	retergfghfghterhgcfnt hy6e5ghjwtjthj	jpg	female

2. Create a directory on your server and call it "test"
3. Create a file named "test01.php" in the test directory, and copy theUploading Images Script to it.

The Uploading Images Script, originated in another php tutorial about Putting Images in a Mysql Database.

Uploading Images Script

<?php $host = ''; $user = ''; $pw = ''; $db = ''; $testpic = 'testpic.jpg'; $ext = 'jpg'; mysql_connect($host,$user,$pw); mysql_select_db($db); $handle = fopen($testpic, "rb"); $img = fread($handle, filesize($testpic)); fclose($handle); $img = base64_encode($img); $sql = "insert into pictures values(null,'$img','$ext','female');"; mysql_query($sql) or die('Bad Query at 12'.mysql_error()); echo "Success! You have inserted your picture!"; <a href="test02.php">Next</a>
4. Copy the following test images and save them in your test folder.

5. Create a file named "test02.php", copy the contents of the PHP Image Rendering Script to it, then save it to the test directory.

First Image Rendering Method

PHP Image Rendering Script

This is the first method for rendering database images with php and mysql.

This method determines what type of image it is retrieving from the database, and uses one of the follwoing php functions to render the images to end users.:

<?php #PHP Image Rendering Script $host = ''; $user = ''; $pw = ''; $db = ''; mysql_connect($host,$user,$pw); mysql_select_db($db); $sql = "select pic, ext from pictures where id='1'"; $result = mysql_query($sql) or die('Bad query at 12!'.mysql_error()); while($row = mysql_fetch_array($result,MYSQL_ASSOC)){ $db_img = $row['pic']; $type = $row['ext']; } $db_img = base64_decode($db_img); //print_r($db_img );<br/><br/> $db_img = imagecreatefromstring($db_img); if ($db_img !== false) { switch ($type) { case "jpg": header("Content-Type: image/jpeg"); imagejpeg($db_img); break; case "gif": header("Content-Type: image/gif"); imagegif($db_img); break; case "png": header("Content-Type: image/png"); imagepng($db_img); break; } } imagedestroy($db_img); ?>

Second Image Rendering Method

1. Create a file named "test03.php" copy Second Method Script to it. (See below)

Second Method Script

<img src="test02.php"/>

Using the Sctipts

After building the database, and uploading all the example files and images to your server:

2. navigate and execute test01.php script

testpic.jpg will be sent to your MySql server with an id of "1".

3. Next click the next link and go to test_02.php to view your image.
4. Now Go back to test02.php PHP Image Rendering Script and comment out all of the php header() functions.
5. After commenting out the header() fucntions type test03.php into your browsers nav bar.

Notice that on the test03.php page, I inserted test_02.php in the img tag. This tells the the client machine to request the pic from the server.

how to upload images and files php Upload Images to Webserver HTML Form PHP Function # UPLOAD FILE function upload_file(){ echo '

Storing image locations mysql Storing Image Url Location in Mysql Database Storing images in the Mysql Database using php can be done by encoding the whole image with a function called base64enco

retreive images mysql php php How to get images out of mysql database with php and use them on my webpages Author: D.Shaun Morgan PHP Version - PHP 5x

register globals long arrays php Security, php.ini, register_globals and register_long_arrays Author: D.Shaun Morgan Versions and Skill Level PHP Version - PHP 5x

how to install php 5 php This is a quick start beginner's how-to manual explaining how to quickly setup a PHP 5 installation on a Windows XP PC. You must have an Apache webserver installed and working on your personal comp