Yes, you can store "files" in a MySQL database. You store them in some
type of BLOB field, and just insert the binary data right into it. One
thing to watch out for is slashes. I forget if you need to addslashes
before putting the data into the database, but I think you need to
stripslashes after retrieving it, so it's not corrupt. I could tell you
for sure but I don't have any of my code in front of me right now :)
So basically you can create a table for files like this:
tblFiles:
int intFileID (for primary key purposes)
tinytext strFileFilename (you'll probably want this)
tinytext strFileType (if you're storing different kinds of file formats,
you'll need this or some other way to identify the file {MIME} type)
int intFileSize (optional)
tinytext strFileDescription (optional)
mediumblob blbFileData
Then you can store the file binary data into the blbFileData field and
retrieve it later. You can do this for any file formats.. including
images. There are many tutorials showing how to do this with images on the
web.
-Mike
At 02:14 PM 3/25/2002 +0800, you wrote:
>Dear all
>Can someone pls tell me is php will be able to grep text from MS Word and
>then save that word file into MYSQL database? Which means is MYSQL will be
>able to store files into it's table?
>
>Thx a lot
>jack
>[EMAIL PROTECTED]
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
Mike Flynn - Burlington, VT
http://www.mikeflynn.net/ - [EMAIL PROTECTED]
home=>work=>home=>store=>home
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
