<?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();

  }

 

 

 

?>

posted on 2017-10-31 19:03  顾君临  阅读(84)  评论(0)    收藏  举报