<?
$db_name="erp";
$table="carrier";
$link_db=mysql_connect('localhost','root') ;

$charsetStr ="set names 'gb2312'";
$charset = mysql_query($charsetStr, $link_db) or die("Could not connect: " . mysql_error());

mysql_select_db($db_name);

$query="select * from " .  $table ;

//数据库查询
$result=mysql_query($query);
$filestr="<"."?xml version=\"1.0\" encoding=\"GB2312\"?".">";
$filestr.="<".$table."s>";

while ($row=mysql_fetch_array($result))  {
//列出所有的记录
$filestr.="<".$table.">";
$fields=mysql_list_fields($db_name,$table);

$j=0;
while ($j<mysql_num_fields ($result)) {
$num_fields=mysql_field_name($fields,$j);
$filestr.="<".$num_fields.">";
$filestr.=$row[$j];
$filestr.="</".$num_fields.">";

$j++;
}
$filestr.="</".$table.">";
}

$filestr.="</".$table."s>";
echo $filestr;

//以下是文件操作代码
$filename=$table.".xml";
$fp=fopen("$filename","w");
fwrite($fp,$filestr);
fclose($fp);
Echo "数据表".$table."已经备份成功！";
?>