作者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