hi!

just a question: don't know it exactly: isn't it possible that the sql-user
on the server may not have enough rights to read the file?

anyway, i would save the file elsewhere on the server, because there are
remarkable performance-issues with big data (tried it once with storing
images for a photo-gallery). it is much faster saving the file in some
directory and just save the path to the file in the db; which on the other
hand, can lead to synchronisation-problems. what do you think about this
topic?

thx -ma

# life would be easier if i knew the source code...

> Von: "John W. Holmes" <[EMAIL PROTECTED]>
> Antworten an: [EMAIL PROTECTED]
> Datum: Wed, 07 Jan 2004 21:29:20 -0500
> An: Will W <[EMAIL PROTECTED]>
> Cc: PHP DB <[EMAIL PROTECTED]>
> Betreff: Re: [PHP-DB] MySQL Insert
> 
> Will W wrote:
> 
>> Can anyone tell me how to insert a file,
>> say a .doc, .txt or a .rtf file into a table from an upload form??
> 
> How about just this:
> 
> $query = "INSERT INTO Table (orig_name, size, mime_type, data) VALUES
> ('{$_FILES['userfile']['name']}', '{$_FILES['userfile']['size']}',
> '{$_FILES['userfile']['type']}',LOAD_FILE('{$_FILES['userfile']['tmp_name']}')
> )";
> 
> Adapt to your needs. No need for PHP to read the file when you can just
> let MySQL do it. :)
> 
> -- 
> ---John Holmes...
> 
> Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
> 
> php|architect: The Magazine for PHP Professionals  www.phparch.com
> 
> -- 
> 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

Reply via email to