RE: small database

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

 



As you'll probably see in a lot of responses, it might be better to store
the pictures in a folder on the server and store only the path to the
pictures in the db.  That keeps the size of the db smaller.

If you choose to do that, use an HTML form with
enctype="multipart/form-data" and an input type="file" element, send it to a
PHP script to upload the file, move it to a specified directory and put the
path and the filname in a table in your db. Then, when you need to display
an image, just grab the path and insert it in an <img src=""> tag.

I don't know how to store an image directly in a database since I always
store just the path. Sorry.

HTH,
Rich
-----Original Message-----
From: Seabird [mailto:jacco@vliegt.nl]
Sent: Tuesday, November 12, 2002 11:56 AM
To: php-db@lists.php.net
Subject:  small database


Hi everyone,

I'm creating a sample site for a company that does aircraft sales. I use a
MySQL DB to store all the info of the available aircraft. Now, I would like
to store pictures directly inside that same table, so that on the "details"
page, it would provide a picture out of (for example) Field5. Is this
possible and if so how? (I tried blob etc., but can't get it to work).

Thanx,
Jacco
--
http://seabird.jmtech.ca

Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching????



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


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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux