Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

**wendellrt** · 09-01-2008 09:38 AM

Hello Everyone.

When I use the example code, all I get is a blank (all white) page being displayed in my browser ('view source' displays a blank page as well).

Where did I go wrong???

**wendellrt** · 09-01-2008 09:50 AM

You could try putting the following...

Code:

header('Content-type: image/jpg');

before the line which reads...

Code:

echo $content;

HTH.

**casper3000ah** · 09-12-2008 10:08 AM

thank you for ur effort

thanks man

**billjones** · 10-13-2008 12:45 PM

Hi , Jaan
Can you help a newbie ?
I can upload images into the database with no problems, but retrieving them is a problem, they come out of the database in a raw form, its as if the following code is not working !

header('Content-type:image/jpg');

it does not seem to have an effect, if I delete this part of the code I get the same result! Raw data. Can you help?

**billjones** · 10-13-2008 12:56 PM

can anyone help with the above?

**Jaan** · 10-13-2008 01:37 PM

Umm.. do you use the same script or you have changed it..?

If you have changed it, please post it here so I can check what's the problem

**billjones** · 10-14-2008 08:24 AM

Hi Jann,

Thanks for the quick reply, here is my code.

Code:


<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>add pic</title>
</head>
<body>
<form action="insert.php" method="post" enctype="multipart/form-data" name="changer" >
<input name1="MAX_FILE_SIZE" value="102400" type="hidden">
<input name="image" accept="image/jpg" type="file">
<input value="Submit" type="submit">
</form>
</body>
</html>


php code for the page insert.php


<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>insert</title>
</head>
<?php 

// Create MySQL login values and 
// set them to your login information.
$username = "abc";
$password = "123";
$host = "localhost";
$database = "test";

// Make the connect to MySQL or die
// and display an error.
$link = mysql_connect($host, $username, $password);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

// Select your database
mysql_select_db ($database);  


// Make sure the user actually 
// selected and uploaded a file
if (isset($_FILES['image']) && $_FILES['image']['size'] > 0) { 

      // Temporary file name stored on the server
      $tmpName  = $_FILES['image']['tmp_name'];  
       
      // Read the file 
      $fp      = fopen($tmpName, 'r');
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);
      

      // Create the query and insert
      // into our database.
      $query = "INSERT INTO tbl_images ";
      $query .= "(image) VALUES ('$data')";
      $results = mysql_query($query, $link);
      
      // Print results
      print "Thank you, your file has been uploaded.";
      
}
else {
   print "No image selected/uploaded";
}

// Close our MySQL Link
mysql_close($link);
?>  

<body>
</body>
</html>

this works fine untill i try to get the pic out of the db......

php code for print_pic.php

Code:


<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php

$username = "abc";
$password = "123";
$host = "localhost";
$database = "test";

@mysql_connect($host, $username, $password) or die("Can not connect to database: ".mysql_error());

@mysql_select_db($database) or die("Can not select the database: ".mysql_error());

//$id = $_GET['id'];


$id = 1; // just a test id to see if it works!

if(!isset($id) || empty($id)){
die("Please select your image!");
}else{

$query = mysql_query("SELECT * FROM tbl_images WHERE id='".$id."'");
$row = mysql_fetch_array($query);
$content = $row['image'];

header('Content-type: image/jpg');
echo $content;

}

?> 
</body>
</html>

I hope you can help.

Thanks Bill.

**Orjan** · 11-09-2008 08:14 PM

please use the php tags.

this is a special php file when you output the picture, it may not contain any html as it's a picture you're returning, not a web page.

remove everything before <?php and after ?> and it will work. make extremely sure that there are absolutely no letters, spaces or any other symbols before the <?php otherwise, the system might believe it's a web page and goes nuts.

**anujphp** · 11-19-2008 03:47 PM

hello
thanks for the code its works fine for me but i have a problem..though the script work fine when i open my page in flock or mozilla or any toher browser but it dont work when i open the page in internet explorer..it try to download the php file....can you kindly solve my this problem....
i am trying to open the file with this url
localhost/test/displayimage.php=?1

IT works fine with in flock and mozilla

**Jaan** · 11-20-2008 01:20 PM

your link must be..

displayimage.php?id=1

Thread: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

LinkBack

Thread Tools

Search Thread

Display

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Re: Tutorial: Storing Images in MySQL with PHP / Part II / Display your images

Thread Information

Users Browsing this Thread

Similar Threads

Tutorial: Storing Images in MySQL with PHP

Tutorial: PHP to MySQL

Bookmarks

Bookmarks

Posting Permissions