Hi Asaf, Thanks for the advice. That sounds like a good solution. One thing I was wondering about is... when my PHP script saves the uploaded image to the web server, how should the image be named [uniquely]? The problem is that if the user specifes the name of the image file, there's a chance he'll name another one the same way (and thus overwrite the original). I was thinking of maybe a dual approach, where the user gives the image file a name, but then the PHP script appends, say, the table name and record ID--so as to make the filename unique.
What do you think? Is that how you do it? (Or is there a better way??) ...Rene On Wednesday, July 10, 2002, at 07:34 AM, Asaf Maruf Ali wrote: > Hello Rene > > We used a similar approach albeit both our PHP scripts and data were on > the > same server. We however opted to place html links to the images in the > MySQL > db and actual images (GIF's, JPG's)files on the server harddisk. > > It works fine with no performance issues. > > > Hope this helps > > Regards > Asaf Maruf > PING > > > I'm working on a simple content management system that uses PHP and > MySQL for updating a web site's text (stored in a MySQL database). (The > PHP scripts that do the updating (my stuf) live on one web server, the > actual DB data to be updated (my client's stuff) live on another.) So > far, I've only had to he able to update the text content of a > site--therefore, I've only had to bother to store textual data in the > client's DB. But now the client wants to be able to upload/change/delete > certain pictures on their web site--using my CMS tool--so I am faced > with the following problem: > > Do I store all such images in the DB? (Which I understand reduces > performance.) > > Or do I--somehow--store the images as files on the client's web server? > And if so, how? (Because my PHP scripts are being executed on a > different server.) > > ...Rene > > --- > René Fournier, > [EMAIL PROTECTED] > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.361 / Virus Database: 199 - Release Date: 5/7/02 > > > --- René Fournier, [EMAIL PROTECTED] Toll-free +1.888.886.2754 Tel +1.403.291.3601 Fax +1.403.250.5228 www.smartslitters.com SmartSlitters International #33, 1339 - 40th Ave NE Calgary AB T2E 8N6 Canada -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php