Blob does not display multiple images from mysql database

[nse111]

<?php
//header('Content-Type: image/jpeg');
header('Content-Type: text/html');
@mysql_connect("localhost","root","dba") or die("Error");
@mysql_select_db("gallery");
$result = mysql_query("SELECT * FROM paintings");
while($row = mysql_fetch_assoc($result)){
print $row[p_painting_id]."</br>";
//print $row[p_painting_image];
}
?>

this code displays all the painting ids available in the table 'gallery'.

but the below coding doesnt display all the corresponding images(of blob type).
Please tell em why.thanks in advance!!!

<?php
header('Content-Type: image/jpeg');
//header('Content-Type: text/html');
@mysql_connect("localhost","root","dba") or die("Error");
@mysql_select_db("gallery");
$result = mysql_query("SELECT * FROM paintings");
while($row = mysql_fetch_assoc($result)){
//print $row[p_painting_id]."</br>";
print $row[p_painting_image];
}
?>

[dlite922]

check out this tutorial:

http://www.phpriot.com/articles/images-in-mysql/8


Get it? Got it? Good.




Dan

[nse111]

Gosh stop being rude! by the way thanks for that link but that also explains displaying just ONE image. see thats the prob I'v got. I want to display multiple images (thumbnail list).

[pbmods]

Heya, NSE.

To display multiple images, you have two options. You can either inline your image data (http://www.elf.org/essay/inline-image.html), or you can create a viewimage.php page that grabs a single image, and then create a bunch of <img /> tags that link to that page.

[pbmods]

NSE, Please use CODE tags when posting source code:

[CODE=PHP]
PHP code goes here.
[/CODE]

[Markus]

Gosh stop being rude! by the way thanks for that link but that also explains displaying just ONE image. see thats the prob I'v got. I want to display multiple images (thumbnail list).

It's all light-hearted 'round these parts! He wasn't being rude.

Kind regards.

[nse111]

thanks all :) for the info on tags, links n abt the advice on attitude arnd here :)

[ak1dnar]

Please read this simple example to find out what "pbmod" said.

Create your first script to print a single image based on a image id. image.php

<?php
error_reporting(E_ALL);
if(isset($_GET['image_id']) && is_numeric($_GET['image_id'])) {
$link = mysql_connect("localhost", "root", "password") or die("Could not connect: " . mysql_error());
mysql_select_db("demodb") or die(mysql_error());
$sql = "SELECT img_data FROM images WHERE img_id={$_GET['image_id']}";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
header("Content-type: image/jpeg");
echo mysql_result($result, 0);
mysql_close($link);
}else{
    echo 'Please use a real id number';
}
?>
 

Send Http GET request to the image.php file to print your inline images from your second page.

another_page.php

<?php
error_reporting(E_ALL);
$link = mysql_connect("localhost", "root", "password") or die("Could not connect: " . mysql_error());
mysql_select_db("demodb") or die(mysql_error());
$sql = "SELECT img_id FROM images";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
while($row=mysql_fetch_assoc($result)){
print "Image : ".$row['img_id'];
print '<img src="image.php?image_id='.$row['img_id'].'"/>';
}
mysql_close($link);
?>
 

[mms003]

Thanks ak1dar
I was looking for this for the past 2 weeks...
This works good...
Got more question.
How do I display more info from same database? Example title and so on...
And sort by date.
I want to create where a registered user can up load 10 images and put it in its won area… and display the name of the photos the person upload by most resent.

Thanks in advance

[mms003]

Ok I got it to display different information and created a table to center the image...

no I need to know how to create table's within tables... when a user upload all 10 images it keeps it separated form the rest...

Thanks.

[ak1dnar]

Hi mms003,

I think you can print blob data as images now. glad to help. but your second question is not matching with this thread title. so how about creating a new thread. Please read some posting guidelines too. And also welcome to the forum. See you again.
Posting Guidelines
posting guidelines
-ak1dnar

[daivee]

thank you so much ak1dnar
it was so much helpful content....
thanks again :))