قمت يتعدي ملف get_datas.php الى :
كود PHP:
<?php
header('(anti-spam-(anti-spam-content-type:)) text/html; charset=utf-8' );
include ("config.php");
$sql_text="";
$sql="select * from tab1 order by id DESC";
$res=mysql_query($sql);
mysql_query("SET NAMES 'utf8'");
mysql_query('SET CHARACTER SET utf8');
while($row=mysql_fetch_object($res)){
$name = iconv('windows-1256','utf-8',$row->name);
$sql_text.="UPDATE `tab1` SET `name` ='$name',
`country`='$row->country',
`town`='$row->town'
where `id` = '$row->id' ;
";
}
highlight_string($sql_text);
$file="update.sql";
$fp=fopen($file, "w");
fwrite($fp,$sql_text);
fclose($fp);
?>
وتعديل ملف config.php الى :
كود PHP:
<?php
// DB login information
$username = 'root';
$password = 'root';
$database = 'db_test';
$host = 'localhost';
$Charset = "utf8";
$link = mysql_connect($host, $username, $password);
$char = mysql_query("SELECT CHARSET (DATABASE())") or die (mysql_error());
$coll = mysql_query("SELECT COLLATION (DATABASE())") or die (mysql_error());
$ch= mysql_fetch_array($char);
$cl= mysql_fetch_array($coll);
echo "char = ".$ch[0]."<br />";
echo "coll = ".$cl[0]."<br />";
//mysql_set_charset($Charset,$link);
//mysql_query("SET NAMES $Charset;", $link) or die ('Erreur de connexion au serveur: '.mysql_error());
mysql_select_db($database);
//mysql_set_charset("utf8");
?>
مع حفظ الملفين تحت ترميز ANSI.
فكان ملف update.sql الناتج :
كود PHP:
char = utf8
coll = utf8_general_ci
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '14' ;
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '13' ;
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '12' ;
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '11' ;
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '10' ;
UPDATE `tab1` SET `name` ='',
`country`='',
`town`=''
where `id` = '9' ;
UPDATE `tab1` SET `name` ='ط¹ط§ط¯ظ„',
`country`='سوريا',
`town`='حماة'
where `id` = '8' ;
UPDATE `tab1` SET `name` ='ط¹ظ„ظٹ',
`country`='العراق',
`town`='البغدادية'
where `id` = '7' ;
UPDATE `tab1` SET `name` ='ظپظٹطµظ„',
`country`='السعودية',
`town`='الرياض'
where `id` = '6' ;
UPDATE `tab1` SET `name` ='ط§طظ…ط¯',
`country`='مصر',
`town`='بور سعيد'
where `id` = '5' ;
UPDATE `tab1` SET `name` ='ط¹ظ…ط±',
`country`='العراق',
`town`='كربلاء'
where `id` = '4' ;
نلاحظ ان الاسم لعد استعمال iconv اصبح من الحرف العربي الى هذا ما مفهوم هذا ؟
شكراً.