[PHP] Re: Store uploaded files in MySQL-BLOB

2001-07-10 Thread Adam
I would suggest setting the database column to LONGTEXT instead of BLOB since it can accomidate far more characters per entry. As for the entry to the database through php, I'm not entirely sure what method you're using to add these. Are they uploading their file and then it reads it as it

[PHP] PHP] Re: Store uploaded files in MySQL-BLOB

2001-07-10 Thread Tom Gitzinger
- Original Message - From: Adam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 12:20 PM Subject: [PHP] Re: Store uploaded files in MySQL-BLOB I would suggest setting the database column to LONGTEXT instead of BLOB since it can accomidate far more characters per

[PHP] Re: PHP] Re: Store uploaded files in MySQL-BLOB

2001-07-10 Thread Adam
The project is a kind of knowledge base. For each entry a user creates, he should be able to give additional information, such as every kind of file (i.e. not only code files but also images etc). There is an input type=file ... where he selects the file to be uploaded. The php-script is

[PHP] Re: Store uploaded files in MySQL-BLOB

2001-07-10 Thread elias
Tom, First, I suggest using LONGBLOB as a field... Second, Once the $userfile is uploaded...use the statment as: $query = INSERT INTO ... (file) VALUES ( LOAD_FILE($userfile)); using the MySql's LOAD_FILE() Tom Gitzinger [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL