Home > Backend Development > PHP Tutorial > 新手请问一个关于PHP 从数据库取得数据后怎么填充到XML文件中

新手请问一个关于PHP 从数据库取得数据后怎么填充到XML文件中

WBOY
Release: 2016-06-13 13:25:45
Original
1066 people have browsed it

新手请教一个关于PHP 从数据库取得数据后如何填充到XML文件中
需求:
我已知用户ID,根据用户ID查询该用户的相关信息,后台SQL语句已经写好,现在是在逻辑层中通过节点方式将数据填充到XML中,然后再通过前段JS代码取得数据, 麻烦请各位牛牛们帮我看下我写的这个逻辑层代码有什么问题,

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->// 引用数据库处理文件
require_once "../../DBHandle/DBHandle/DBUser.php";

$lefNav = $_REQUEST ["lefNav"];
$action = $_REQUEST ["action"];
if ($lefNav == "userinfo") {
    if (action == "init") {
        $userId = $_REQUEST ['user_id'];
        $rs = DBUser::getUserInfoByID ( $userId );
        if ($rs) {
            
            // 将查询出来的用户信息结果放置到XML中传到前段
            $doc = new DOMDocument ( "1.0", "utf-8" );
            $doc->appendChild ( $doc->createElement ( "xml" ) );
            
                $userNode = $doc->createElement ( "rs" );
                
                $userId = $doc->createElement ( "userId" );
                $userIdTx = $doc->createTextNode($rs[0]);
                $userId->appendChild($userIdTx);
                
                $name = $doc->createElement ( "name" );
                $nameTx = $doc->createTextNode($rs[1]);
                $name->appendChild($nameTx);
                
                $rname = $doc->createElement ( "rname" );
                $rnameTx = $doc->createTextNode($rs[2]);
                $rname->appendChild($rnameTx);
                
                $gname = $doc->createElement ( "gname" );
                $gnameTx = $doc->createTextNode($rs[3]);
                $gname->appendChild($gnameTx);
                
                $userNode->appendChild($userId);
                $userNode->appendChild($name);
                $userNode->appendChild($rname);
                $userNode->appendChild($gname);
                
                $doc->documentElement->appendChild($userNode);
                echo $doc->saveXML();
            
        } else {
            echo "FAIL";
        }
    }
}
   
Copy after login


------解决方案--------------------
PHP与XML的相互转换封装函数:xmlparse.php
PHP code

include(dirname(__FILE__)."/xmlparse.php");
$listtags = explode(" ","2 name");
$arr = array(1,"name"=>"SOM","admin",100,array("name"=>"TOM","Lily"));
$contXML = dump_xml_config($arr, "xml", "utf-8");
//放入文件
//file_put_contents_safe("/path/test.xml",$contXML,"w");
echo $contXML;
#源码
#<?xml version="1.0" encoding="utf-8"?>
#<xml>
#    10>
#    <name>SOM</name>
#    admin1>
#    1002>
#    
#        <name>TOM</name>
#        Lily0>
#    3>
#</xml> <div class="clear">
                 
              
              
        
            </div>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template