|
|
|
There have been a number of questions lately about storing images in a db table and then how to show them correctly. The problem is that the header for images needs to be set correctly for the binary data to be show correctly.
Here are the two working pages (tested my machine (xp, apache2, php4.3.9 mysql 4.01.x)
In the areas for the db query you will see the notation
$result = connect(sql);
connect is a custom function to handle all db interatction that is separate from the pages and included in the conn.php file. There is another example with that function in my previously posted code samples.
show_desc.php
|
<?php
require("conn.php");
// you may have to modify login information for your database server
$query = "select description, id from binary_data ";
$result = connect($query);
while ($rows = MYSQL_FETCH_ARRAY($result)) {
echo $rows['description'];
echo "<br><br>";
echo "<img src=\"show_image.php?id=".$rows['id']."\">\n";
}
?> | |
show_image.php
| <?php
require("conn.php");
//check to see if the id is passed
if(isset($_GET['id'])) {
$id=$_GET['id'];
$query = "select bin_data, filetype from binary_data where id=$id";
//echo $query;
$result = connect($query);
$row = mysql_fetch_array($result);
{
$data = $row['bin_data'];
$type = $row['filetype'];
}
if ($type=="pjpeg") $type = "jpeg";
Header( "Content-type: $type");
echo $data;
}
?> | |
Database table:
| CREATE TABLE binary_data (
id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
description CHAR(50),
bin_data LONGBLOB,
filename CHAR(50),
filesize CHAR(50),
filetype CHAR(50)
); | |
As always, these are simple samples only. There are many additions one could make to make this more robust and secure, from adding extension and mime type limitations to more db security. |
| bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | phpFormGenerator for Dynamic Form Generation from MySQL Categories : PHP, PHP Classes, MySQL, Databases, HTML and PHP | |
| | PHP Calendar Web App Categories : PHP, Databases, MySQL, Date Time, Calendar | | | How to load a query result into a PHP Array Categories : PHP, Databases, Arrays, MySQL | | | Functions for loading images into a MySQL database and displaying them. Categories : Graphics, HTML and PHP, MySQL, PHP, Databases | | | for each record, do this to the first record, and do that to any subsequent record Categories : PHP, Databases, MySQL, Beginner Guides | | | PHP4 AND MySQL Authentication Categories : PHP, MySQL, Authentication, Databases | | | Displaying records of database in more than one page (paging) Categories : Databases, MySQL, PHP | | | A Complete table(ADD,EDIT,VIEW,DELETE) management System PHP,MYSQL, JAVASCRIPT Categories : PHP, MySQL, Java Script, Databases | | | This is Yet Another Sql Abstraction Library. Include it in your script and you can use the most important SQL functions without worrying about the SQL backend. Categories : Databases, PHP, ODBC, MySQL, PostgreSQL | | | Create and restore backup of MySQL databases Categories : MySQL, Databases, PHP, PHP Classes, Complete Programs | | | Caldera Openlinux 1.2 Standard Categories : Web Servers, MySQL, PHP, Apache, Databases | | | simple script to send emails via a html-form to different users Categories : Email, MySQL, PHP, Databases | |
| | | | matthew waygood wrote : 1265
You could also check if the entry exists before outputting the header and content.
And check the id is valid, or even force it to be valid with the following:-
$id=ereg_replace("[^0-9]","",urldecode($_GET[`id`]));
// remove all non number values from the id
| | | | Boaz Yahav wrote :1633
What is the deal with :
{
$data = $row[`bin_data`];
$type = $row[`filetype`];
}
in show_image.php
| |
|
|