Re: Store uploaded files in MySQL-BLOB
| From: | elias | Date: | Tue, 10 Jul 2001 13:42:09 +0000 |
| Subject: | Re: Store uploaded files in MySQL-BLOB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-57142@lists.php.net to get a copy of this message | ||
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" <tom_gitzinger@gmx.de> wrote in message
news:11565.994757948@www28.gmx.net...
> Hi friends,
>
> could anybody tell me how I best store one or several uploaded files in a
> MySQL database (as a BLOB). I use PHP 3.
> Let's say I have the variable $userfile. Is it possible to simply insert
> this into the database?
> $query = "INSERT INTO ... (file) VALUES (" . $userfile . ");
>
> By the way: which version of PHP 3 do you need to upload several files at
> once?
>
> Tom
>
> --
> GMX - Die Kommunikationsplattform im Internet.
> http://www.gmx.net
>
> GMX Tipp:
>
> Machen Sie Ihr Hobby zu Geld bei unserem Partner 1&1!
>
> http://profiseller.de/info/index.php3?ac=OM.PS.PS003K00596T0409a
>