Storing Images In MySQL
Displaying All The Information
Now we have the basic building blocks, we could create a script to see all the information about the image that we have stored in our table.
The trick here is to avoid sending headers twice. To do this we use two files. The first we will call file.php and we use the above view.php in our HTML img tag. Of particular importance here is not to make the mistake mentioned at the beginning of this tutorial of doing something silly like SELECT * FROM testblob.
This is not required and would slow us down in our query because we would need to store the image itself in memory when we are not going to use it yet. So we simply SELECT the other information from the fields that we do want.
// again we check the $_GET variable if(isset($_GET['image_id']) && is_numeric($_GET['image_id'])) { $sql = "SELECT image_type, image_size, image_name FROM testblob WHERE image_id=".$_GET['image_id']; $link = mysql_connect("localhost", "username", "password") or die("Could not connect: " . mysql_error()); // select our database mysql_select_db("testblob") or die(mysql_error()); $result = mysql_query($sql) or die("Invalid query: " . mysql_error()); while($row=mysql_fetch_array($result)) { echo 'This is '.$row['image_name'].' from the database<br />'; echo '<img '.$row['image_size'].' src="view.php?image_id='.$_GET['image_id'].'">'; } } else { echo 'File not selected'; }
From the above script we can see the first image from the database. At the top of the page it has echoed a little message and the image name from the database.
You could, as mentioned earlier store other information about the image in the same way and display it. In this script we also use the image_size field from that we had gained from getimagesize(). This stores the image width and height in a string that we can use in img tags.