Well… It is already a well discussed topic. But when I was first trying to find out how to do this, I really got stuck. Actully it took me a lot of time to find out the key code segment for the purpose.
So, here is what I’ve learned:
Suppose the structure of the MySQL table (say ‘file_table‘) is like this:
It has three fileds:
id : the primary key, integer type with auto increment feature.
content: the content of file, blob type.
type: varchar type, the type of the file (e.g. doc, pdf etc.).
I think you can create a HTML form with a input with file type. Its pretty simple. Just use this code to make a input field be able to upload file:
<input id="file_upload" name="file_upload" type="file" />
Now the backend coding. I’m using PHP for this. Continue reading