Check the PHP-DB archives ;-) http://news.php.net/article.php?group=php.db&article=22433 Hatem ----- Original Message ----- From: "Rich Hutchins" <rhutchin@rochester.rr.com> To: "Seabird" <jacco@vliegt.nl>; <php-db@lists.php.net> Sent: Wednesday, November 13, 2002 12:24 AM Subject: RE: small database > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
