انا عامل حفظ لملف اكسل بإمتداد 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>';
?>