PHP生成XML格式数据与解析xml数据程序

  $data_array = array(
    array(
    'title' => 'title1',
    'content' => 'content1',
        'pubdate' => '2009-10-11',
    ),
    array(
    'title' => 'title2',
    'content' => 'content2',
    'pubdate' => '2009-11-11',
    )
);
 
//  属性数组
$attribute_array = array(
    'title' => array(
    'size' => 1
    )
);
 
//  创建一个XML文档并设置XML版本和编码。。
$dom=new DomDocument('1.0', 'utf-8');
 
//  创建根节点
$article = $dom->createElement('article');
$dom->appendchild($article);
 
foreach ($data_array as $data) {
    $item = $dom->createElement('item');
    $article->appendchild($item);
 
    create_item($dom, $item, $data, $attribute_array);
}
 
echo $dom->saveXML();
 
function create_item($dom, $item, $data, $attribute) {
    if (is_array($data)) {
        foreach ($data as $key => $val) {
            //  创建元素
            $$key = $dom->createElement($key);
            $item->appendchild($$key);
 
            //  创建元素值
            $text = $dom->createTextNode($val);
            $$key->appendchild($text);
 
            if (isset($attribute[$key])) {  //  如果此字段存在相关属性需要设置
                foreach ($attribute[$key] as $akey => $row) {
                    //  创建属性节点
                    $$akey = $dom->createAttribute($akey);
                    $$key->appendchild($$akey);
 
                    // 创建属性值节点
                    $aval = $dom->createTextNode($row);
                    $$akey->appendChild($aval);
                }
            }   //  end if
        }
    }   //  end if
}   //  end function
?>

CREATE TABLE `student` (

`id` int(11) NOT NULL auto_increment,

`name` varchar(50) NOT NULL,

`sex` varchar(10) NOT NULL,

`age` smallint(3) NOT NULL default ’0′,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

include_once ("connect.php"); //连接数据库

$sql = "select * from student";

$result = mysql_query($sql) or die("Invalid query: " . mysql_error());

while ($row = mysql_fetch_array($result)) {

$arr[] = array(

‘name’ => $row['name'],

‘sex’ => $row['sex'],

‘age’ => $row['age']

);

}

$doc = new DOMDocument(’1.0′, ‘utf-8′); // 声明版本和编码

$doc->formatOutput = true;

$r = $doc->createElement("root");

$doc->appendChild($r);

 
foreach ($arr as $dat) {

$b = $doc->createElement("data");

 
$name = $doc->createElement("name");

$name->appendChild($doc->createTextNode($dat['name']));

$b->appendChild($name);

 
$sex = $doc->createElement("sex");

$sex->appendChild($doc->createTextNode($dat['sex']));

$b->appendChild($sex);
 

$age = $doc->createElement("age");

$age->appendChild($doc->createTextNode($dat['age']));

$b->appendChild($age);

 
$r->appendChild($b);

}
 

echo $doc->saveXML();

李王皓

男

21

…

header("Content-type:text/html; Charset=utf-8″);

$url = "你的xml路么";

$reader = new XMLReader(); //实例化XMLReader

$reader->open($url); //获取xml

$i=1;

while ($reader->read()) {

if ($reader->nodeType == XMLReader::TEXT) { //判断node类型

$m = $i%3;

if($m==1)

$name = $reader->value; //读取node值

if($m==2)

$sex = $reader->value;

if($m==0){

$age = $reader->value;

$arr[] = array(

‘name’ => $name,

‘sex’ => $sex,

‘age’ => $age

);

}

$i++;

}

}

//print_r($arr);