作者SoooRrrr (SOR)
看板PHP
标题[请益] inner child 问题
时间Mon Oct 7 22:14:45 2013
如题目
有段程式码，是麻烦同学帮忙写的，
但是看不太懂，
他最近有点忙，
所以来这边请教一下各位，
<?
include 'db.php';
header('Content-type: text/xml');
mysql_query("SET NAMES 'utf8'");
$us = mysql_query("select * from runtracker ORDER BY score asc", $con);
//$rows_num = mysql_num_rows($us);
// create a new XML document
$doc = new DomDocument('1.0', 'UTF-8');
// add root node
$root = $doc->createElement('child_item');
$root = $doc->appendChild($root);
while($data=mysql_fetch_row($us))
{
$inner = $doc->createElement('item');
$inner = $root->appendChild($inner);
// add a child node for each field
$child = $doc->createElement('id');
$child = $inner->appendChild($child);
$value = $doc->createTextNode("$data[0]");
$value = $child->appendChild($value);
$child = $doc->createElement('name');
$child = $inner->appendChild($child);
$value = $doc->createTextNode("$data[1]");
$value = $child->appendChild($value);
$d = round((double) $data[2],4);
$child = $doc->createElement('score');
$child = $inner->appendChild($child);
$value = $doc->createTextNode("$d");
$value = $child->appendChild($value);
$child = $doc->createElement('rdate');
$child = $inner->appendChild($child);
$value = $doc->createTextNode("$data[3]");
$value = $child->appendChild($value);
$child = $doc->createElement('rankid');
$child = $inner->appendChild($child);
$value = $doc->createTextNode("$data[4]");
$value = $child->appendChild($value);
}
$xml_string = $doc->saveXML();
echo $xml_string;
mysql_close($con);
?>
db.php 是创建资料库而已，
麻烦各位了!!
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 49.159.17.183
1F：→ danny8376:不就很基本的XML操作吗 说实话跟PHP不是太有关系 10/08 01:49
2F：→ danny8376:creatElement就是生一个tag $A->appendChild($B) 10/08 01:49
3F：→ danny8376:这部份则是把$B加进$A底下当子tag 10/08 01:50
4F：→ MOONRAKER:整段贴上来也太coarse了 10/08 02:07
5F：→ danny8376:db.php也一起贴上来应该不错? 顺便附SQL的IP XDD 10/08 02:13
6F：→ MOONRAKER:有可能是192.168.1.1这样 XP 10/08 03:46
7F：→ danny8376:如果是这样就可惜了呢(X 10/08 03:50
8F：→ danny8376:不过我手上资料库不外乎 localhost 192.168.3.1 10/08 03:51
9F：→ danny8376:没一个放在能公共存取的范围呢XD 10/08 03:51
10F：→ danny8376:不过192.168.1.1也是蛮强的拉 哪台Router有支援MySQL啊 10/08 03:52
11F：→ danny8376:(自架的可能性不高吧XDD) 10/08 03:52
12F：→ MOONRAKER:XD 问同学最快。不然php.net DomDocument对照看也懂了。 10/08 11:39