<?php
try{
$dsn="mysql:host=localhost;dbname=lingjun";
$user="root";
$pwd="";
$pdo=new PDO($dsn,$user,$pwd,[PDO::ATTR_ERRMODE=>2]);
$pdo->exec("set names utf8);
$data=$pdo->query("select * from stu_info")->fetchAll(2);
$xml="<?xml version='1.0' encoding='utf-8'>\r\n";
$xml.="<root>\r\n";
foreach($data as $v){
$xml.="\t<stu_info>\r\n";
foreach($v as $k1=>$v1){
$xml.="\t\t<{$k1}>".$v1."</{$k1}>\r\n";
}
$xml.="</stu_info>\r\n";
}
$xml.="</root>";
file_put_contents($xml,"xml03.xml");
}catch(PDOException $e){
echo $e->getMessages();
}
?>
<?php
try{
$dsn="mysql:host=localhost;dbname=lingjun";
$user="root";
$pwd="";
$pdo=new PDO($dsn,$user,$pwd,[PDO::ATTR_ERRMODE=>2]);
$pdo->exec("set names utf8);
$data=$pdo->query("select * from stu_info")->fetchAll(2);
$xml="<?xml version='1.0' encoding='utf-8'>\r\n";
$xml.="<root>\r\n";
foreach($data as $v){
$xml.="\t<stu_info>\r\n";
foreach($v as $k1=>$v1){
$xml.="\t\t<{$k1}>".$v1."</{$k1}>\r\n";
}
$xml.="</stu_info>\r\n";
}
$xml.="</root>";
$obj=new simpleXMLElement($xml);
$obj->asXML("xml4.xml");
}catch(PDOException $e){
echo $e->getMessages();
}
?>
浙公网安备 33010602011771号