Re: Re: Upload File
| From: | Jochem Maas | Date: | Wed, 10 May 2006 15:44:29 +0000 |
| Subject: | Re: Re: Upload File | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-235909@lists.php.net to get a copy of this message | ||
Peter Hoskin wrote:
Renzo Clavijo wrote:wtf? ASCII is a codeset, SQL is a theoretical language specification. it's like saying 'software is based on computers.' - completely besides the point. from a performance angle I would never suggest putting image/binary data into a DB. but to say it's not technically suitable is silly - a 'BLOB' field is designed specifically for the storage of binary data.hi all.. I'm gonna be more precise: I wrote a form with fields <text type="file" .... >, then i need to know how to upload the files to the MySQL server (postgreSQL wold be appreciated). It implies: Which field(s) must have the table where I'll save the image?. Is there an example code to upload the file(s)?Despite common belief, SQL is not suited to the storage of binary files. SQL is based on ASCII.
Store your files on the filesystem, not SQL.in practice that is indeed a sound recommendation - what many people do do is use the DB to store information about the files that have been uploaded (original size, original name, location on disk, etc) - which can be very handy indeed.