RE: [PHP-DB] small database
I agree with the others, don't try to store the picture in the db. What I did was provide a place for users to log-in to my site, when they signed up, I created a folder (using their username since that had to be unique). When they uploaded their pictures, I put the pictures in their folder and then just put the path (/username/pic1.jpg) into the db as a string. Eddie -Original Message- From: Seabird [mailto:jacco;vliegt.nl] Sent: Tuesday, November 12, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] 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-DB] 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
RE: [PHP-DB] 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: [EMAIL PROTECTED] Subject: [PHP-DB] 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
Re: [PHP-DB] small database
Check the PHP-DB archives ;-) http://news.php.net/article.php?group=php.dbarticle=22433 Hatem - Original Message - From: Rich Hutchins [EMAIL PROTECTED] To: Seabird [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 12:24 AM Subject: RE: [PHP-DB] 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: [EMAIL PROTECTED] Subject: [PHP-DB] 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