First character problem while reading .csv files
Posted: Tue May 13, 2008 7:59 am
~pickle | Please use [ code=html ], [ code=php ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:
Posting Code in the Forums to learn how to do it too.
Hi guys,
I'm reading a csv file and i write values which comes from csv to mysql table. while i do this op
for ex. "ÇAMDA?" value records to table as "AMDA?".
As you see the "Ç" isn't recorded but "?" has been recorded, so i'm not sure the whole problem is charset.
how can i do about this??
~pickle | Please use [ code=html ], [ code=php ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:
Posting Code in the Forums to learn how to do it too.
Hi guys,
I'm reading a csv file and i write values which comes from csv to mysql table. while i do this op
for ex. "ÇAMDA?" value records to table as "AMDA?".
As you see the "Ç" isn't recorded but "?" has been recorded, so i'm not sure the whole problem is charset.
how can i do about this??
Code: Select all
$handle = fopen ("../csv/".$filename."","r");
while ($data = fgetcsv ($handle,4096,";")) {
if ($row>=2){
$add_news = $Engine->SQL("insert into ".TABLE_POMPA." set
ID = '".$data[0]."',
IL = '".$data[1]."',
KBENZIN = '".$data[2]."',
OKTAN98 = '".$data[3]."',
SBENZIN = '".$data[4]."',
GAZYAGI = '".$data[5]."',
MOTORIN = '".$data[6]."',
PPM350 = '".$data[7]."',
KYAKITI = '".$data[8]."',
FOIL6 = '".$data[9]."'
");
}
~pickle | Please use [ code=html ], [ code=php ], etc tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: