Tutorializer.NET

 In this tutorial is presented a simple code with informations about programing a script that uses MYSQL database to upload images. Very simple to interpretate, to code and to test, its a simple way to learn how to program a upload script that select images from the MYSQL database using php programing. Image upload with MYSQL databaseThere will be 3 PHP files in this tutorial: readdir.php - this puts all the images in a folder into the database image.php - the actual image script that displays the imag view.php - an example file that shows you how to call the imageCreating the Image DatabaseFirst, create a mysql database called base64imgdb (this is the name that will be used throughout the tutorial)Second, create a table called images with two rows. Name the first one imgid, and give it the parameters TYPE: INT EXTRA: auto_increment, and check the circle under Primary. Name the second sixfourdata, and make it TYPE: LONGTEXT. Here is the sql code:

The READDIR.PHP script
This script reads a directory within the server, selects all the jpg and gif images, encodes them into base64, and uploads them to the database, except in a different order. This is because the script reads each image in a loop, and we would like to keep a constant connection to the mysql database instead of creating multiple ones. Here is the database connection where: username and password

is the directory the readdir.php file is located:

This is the last and final part of the readdir.php: closing the directory and stating the proccess is complete:

The Image Reader IMAGE.PHP
This file may be the hardest file to understand whenever you see how simple view.php is, but bear with me, your patience will pay off. This file takes a request, requests the row in the table, decodes the data, and presents itself as an image. First, we have to connect to the database again: