RE: RE: Display picture from MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Here is my situation
I have 3 record data as (lotID is char and Picture is longblob type)
LotId |Picture 
---------------
123   |Picture1
124   |Picture2
125   |Picture3

then I would like to display like this
>>>>>>>>>>>
Lot ID : 123
Picture: Picture1

Lot ID : 124
Picture: Picture2

Lot ID : 125
Picture: Picture3
>>>>>>>>>>>
Or maybe thumbnail view.
How I can do this?

Thanks

-----Original Message-----
From: Richard Lynch [mailto:ceo@xxxxxxxxx]
Sent: Friday, July 08, 2005 3:58 AM
To: Bagus Nugroho
Cc: replies-lists-php@xxxxxxxxxxxxxxxxxxxxx; php-general@xxxxxxxxxxxxx
Subject: RE:  RE: Display picture from MySQL


On Thu, July 7, 2005 12:32 pm, Bagus Nugroho said:
> How about, if we need several pictures from several record?

You can create a page of HTML that has IMG tags, and each IMG tag can call
ANOTHER php script that sends out one, and only one, image.

You'll never ever get two images crammed into a single HTTP request/response.

You also cannot smush the HTML and the IMG itself all into one file/script.

HTML with IMG tag is one script.
Actual image output (JPEG, GIF, etc) is another.

* Actually, they can be the same "script" if enough code is shared, but
it's got to have an "if" in there and only output the HTML for the .htm
request, and only output the JPEG for the .jpg request, but that's for
another day, after you get it working in separate scripts.

-- 
Like Music?
http://l-i-e.com/artists.htm

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux