mail text doc into MySQL

admin

Administrator
Staff member
Hi,
I have got a PHP page which I use to save localhost mails as text, but I seem to be having problems saving the mails into mysql. I can only get the first line or the last line of the document.

for example if I try:
$description = system('cat <path-to-file>');
$addStmt = "Insert into sys_diary (PROB_TYPE,DESCRIPTION,THE_DATE) values ('$prob_type, '$description',''$final_date1')";

it doesn't seem to matter what text manipulation tool I use I always get the same result. The above does work with other normal text files fine.

Any help would be most appreciated as I am pulling my hair out now!!

tks

Matt
 
Back
Top