محمد أشرف |
31-07-2011 03:18 PM |
fgetcsv ومشكلة عدم ظهور العربي,,, ارجوكم حل
السلام عليكم
انا عامل حفظ لملف اكسل بإمتداد csv وعايز ارفعه على داتابيس لكن الكلمات العربي مش بتظهر خالص الارقام فقط اللي بتظهرر
الكود بتاعي اهو
كود PHP:
<? include("db.php"); print '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'. '<html dir="rtl" xmlns="http://www.w3.org/1999/xhtml">'. '<head>'. '<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />'. '<meta content="ar-sa" http-equiv="Content-Language" />'. '</head>'. '<body>'; print '<form action="' . $_SERVER['PHP_SELF'] . '" method="post" enctype="multipart/form-data">'; if(isset($_POST['submit'])) { $uploaddir = "";
$fc = iconv('windows-1256', 'utf-8', file_get_contents($_FILES['filename']['tmp_name'])); file_put_contents('import.tmp', $fc); $handle = fopen('import.tmp', "r"); /*if (move_uploaded_file($_FILES['filename']['tmp_name'], $uploaddir . basename($_FILES['filename']['name']))) { echo "File sucessfully uploaded to " . $uploaddir . basename($_FILES['filename']['name']) . "<BR>"; $filename = $_FILES['filename']['name'];
$handle = fopen($filename, 'r'); mysql_query("TRUNCATE TABLE 3orod") or die(mysql_error()); } else { echo "Error : " . $_FILES['filename']['error'] . "<BR>"; } */ while (($data = fgetcsv($handle, 4096, ",")) !== FALSE) { $import="INSERT into 3orod(A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]','$data[25]')"; //$import = str_replace("'","''",$import); //this replaces single quotes with 2 of them to allow sql to see that your meaning to include it... $runq = mysql_query($import) or die(mysql_error()); echo $import; echo "<br>"; echo "<br>"; } fclose($handle); print "Import done"; } else { print "Type file name to import:<br>"; print "<input type='file' name='filename' size='20'><br>"; print "<input type='submit' name='submit' value='submit'>"; } print '</form>'. '</body>'. '</html>'; ?>
ياريت تقولولي ايه الحل ؟؟
|