Viewing images stored in mysql as blob data?

Junior WebHelper Joined: 08 Oct 2004 Posts: 10

Hi peeps,

Im having an issue getting viewing images I have added to a mysql database. I have a dump of the database below.

Code:

CREATE TABLE binary_data_files (
file_id tinyint(3) unsigned NOT NULL auto_increment,
bin_data mediumblob NOT NULL,
description tinytext NOT NULL,
filename varchar(50) NOT NULL,
filesize varchar(50) NOT NULL,
filetype varchar(50) NOT NULL,
PRIMARY KEY (file_id)
);

I can successfully add blob images to the database but when trying to call them for usage just simply doesn't work.

The script I am trying to use is below.

Code:

<?php

global $id;

if(!is_numeric($id))

die("Invalid file_id specified");

$dbServer = "localhost";

$dbDatabase = "phone";

$dbUser = "root";

$dbPass = "";

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)

or die("Couldn't connect to database server");

$dConn = mysql_select_db($dbDatabase, $sConn)

or die("Couldn't connect to database $dbDatabase");

$dbQuery = "SELECT bin_data, filetype";

$dbQuery .= "FROM binary_data_files";

$dbQuery .= "WHERE file_id = $id";

$result = mysql_query($dbQuery) or die("Couldn't get file list");

if(mysql_num_rows($result) == 1)

{

$filetype = @mysql_result($result, 0, "filetype");

$filecontent = @mysql_result($result, 0, "bin_data");

header("Content-type: $filetype");

echo $filecontent;

}

else

{

echo "Record doesn't exist.";

}

?>

Everytime I try to call an image (view.php?id=1) I get "Couldn't get file list"?

Can anyone help?

Thanks

Badger!

Posted: Sat Jan 01, 2005 4:35 pm (19 years, 3 months ago)

Add the following after the query and before the script is killed (with die() ):

Code:

print mysql_error();

That should let you know what's going wrong.

Junior WebHelper Joined: 08 Oct 2004 Posts: 10

Thanks for this

Junior WebHelper Joined: 21 Apr 2015 Posts: 1

Everytime I try to call an image (view.php?id=1) I get "Couldn't get file list"?

__________________
aliiii