#Php image resize code

Go into both files and fix the MySQL connection strings to connect to your database. Fix Connection Strings and Place Both Files In Same Directory Here is a screen shot of the contents of my database:ДҐ. I took screen-shots of 6 different websites and placed them into my database. This will show all the files in your database in a thumbnail-size of (280 x 215) with the Name of the image as a link right above each image.

#Php image resize code

Inside the body of your php page, insert the following code that grabs the ids, names, and urls from your database, then sets the image sources to the respective url I discussed in the last step: It is as easy as that! Lastly we need to create the main page that will display all the images with their links.Д¬reate a php webpage and name it whatever you want. This is all we need to do with this script. If there is a resize variable, the script will re-size the retrieved image. This script takes the first variable (blob_id) and retrieves that blob from the database. The contents of doImage.php need to look like this: If you want to just display the original image's size, you can leave this out completely which would give you the following url: It won't change the blob in the database, it is only for viewing purposes. (We will dynamically set this variable - I only went into this for explaining purposes) The second variable, resize=225,225, will size the image to 225 x 225 (h x w). So if you wanted the 15th blob in the database, you would change that 1 to a 15. The first one, blob_id=1, retrieves the blob in the database whose blob_id is 1. Notice the two request-variables inside the url: blob_id=1 and resize=225,225. What's going to happen is, from the main page (which we'll create next) where we will show the images and links, we will set the 'src' inside the image tags to the following: Create a PHP script for retrieving and re-sizing the imageД¬all this script 'doImage.php'. Here is the MySQL syntax for creating this table:Д¬REATE TABLE `tblBlob` ( `blob_id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `blob_name` VARCHAR(85) NOT NULL, `blob_url` VARCHAR(185) NOT NULL, `blob_binary` LONGBLOB NOT NULL, PRIMARY KEY (`blob_id`) ) ENGINE = InnoDB Дў.

For this example I am going to use LONGBLOB. A BLOB is a binary field that can store the binary representation of images. The differences between these are the maximum allowed sizes of of the images you are going to store. You can set the type to either of the following: BLOB, TINYBLOB, MEDIUMBLOB, OR LONGBLOB.