How to enter the text file in to LongBLOB field.

[sudhakaranr]

HI ALL,

I am new bie to mysql...I have 100 files as text files and each text file are having minimum 25 lines.I want to enter all the files in to Mysql DB.

My query is, In mysql table, i have a columns like pid(PRIMARY KEY),content(LONGBLOB).
In table, Pid has entries like p1,p2,p3.....
Now in a directory, i have text files like p1.txt,p2.txt,p3.txt.....
I want to upload the text files into content(LONGBLOB) column field, if the PID and the textfile names are same.

CAN ANYONE HELP ME TO UPLOAD THE TEXT FILES..

Please it's urgent.

Thanks in advance...

[ronverdonk]

Do these entries in the database already exist? I mean do you have rows reserved with the key pid (file_name) already in or do you want to create the pid(..) while uploading? The former requires an UPDATE, the latter an INSERT.

You must have some coding done before we can help you. A hint is:

open MySQL connection
Do until all files processed:
-  get next text file name from array
-  read textfile into one php variable
-  construct the UPDATE or INSERT SQL statement
-  execute the MySQL statement
End Do;

Ronald :cool:

[sudhakaranr]

No, we have pid column field already...

what we want to do is.. we should match the pid with the text files and if it is matching ...then we need to upload the the file in the content (longblob)field automatically

I dont want to enter manually...

[ronverdonk]

So: go ahead, you know now what the process should be. Start coding.

Ronald :cool: