0

I guys, I want to upload files to a MySQL database in PHP....
The connection is OK...
but there is a problem with the document column..
If anyone can help me , please give me a working solution..

2
Contributors
6
Replies
10
Views
6 Years
Discussion Span
Last Post by diafol
1

You want to store the contents or the filepath?

//EDIT

Look, you really need to show some patience - posting a bump after 5 minutes is just rude, a sure fire way to getting yourself ignored.

Edited by diafol: n/a

0

You want to store the contents or the filepath?

//EDIT

Look, you really need to show some patience - posting a bump after 5 minutes is just rude, a sure fire way to getting yourself ignored.

I want to store a document(CV)
This is my web page interface.

http://img683.imageshack.us/i/upload2k.jpg/

I can add all the other fields to the database , but not CV... :(

The data-type of the field CV is longblob.

How can I store the document in this column...??

Edited by spgun: n/a

0

First of all, you need to grab the file itself and pour the contents into a blob field.

make sure your form has the attributes: method="post" enctype="multipart/form-data"

THen you open the file and grab the contents
I like to use file_get_contents(), but you can use others.
Addslashes should be applied in order to prevent quotes within the document from messing up your SQL query

$content = addslashes(file_get_contents($_FILES['myfile']['tmp_name']));

then pass the $content var to your SQL statement.

0

First of all, you need to grab the file itself and pour the contents into a blob field.

make sure your form has the attributes: method="post" enctype="multipart/form-data"

THen you open the file and grab the contents
I like to use file_get_contents(), but you can use others.
Addslashes should be applied in order to prevent quotes within the document from messing up your SQL query

$content = addslashes(file_get_contents($_FILES['myfile']['tmp_name']));

then pass the $content var to your SQL statement.

Hi, thanks .....
Its working now...
Now, Im trying to get the file back(download)
If any help needed, I'll get back to u...
Thanks again...

What are the modifications needed to make this file upload success...

0

FOr retrieving the file, you need to extract the data and place it into a file (e.g. file_put_contents). A simple php redirect to the newly created file can serve as a 'download'. Otherwise, depending on the content, you can createthe file with specific type headers (e.g. pdf, images etc).

Personally, I wouldn't bother with storing files in a DB, I'd just keep the filepaths there and store the uploaded file in an uploads directory.

Edited by diafol: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.