看板 PHP 關於我們 聯絡資訊
如題目 有段程式碼,是麻煩同學幫忙寫的, 但是看不太懂, 他最近有點忙, 所以來這邊請教一下各位, <? 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
danny8376:不就很基本的XML操作嗎 說實話跟PHP不是太有關係 10/08 01:49
danny8376:creatElement就是生一個tag $A->appendChild($B) 10/08 01:49
danny8376:這部份則是把$B加進$A底下當子tag 10/08 01:50
MOONRAKER:整段貼上來也太coarse了 10/08 02:07
danny8376:db.php也一起貼上來應該不錯? 順便附SQL的IP XDD 10/08 02:13
MOONRAKER:有可能是192.168.1.1這樣 XP 10/08 03:46
danny8376:如果是這樣就可惜了呢(X 10/08 03:50
danny8376:不過我手上資料庫不外乎 localhost 192.168.3.1 10/08 03:51
danny8376:沒一個放在能公共存取的範圍呢XD 10/08 03:51
danny8376:不過192.168.1.1也是蠻強的拉 哪台Router有支援MySQL啊 10/08 03:52
danny8376:(自架的可能性不高吧XDD) 10/08 03:52
MOONRAKER:XD 問同學最快。不然php.net DomDocument對照看也懂了。 10/08 11:39