[請益] 導出MYSQL的值

看板PHP作者Smallxiami (我在飛)時間10年前 (2015/04/12 05:01)推噓0(0推 0噓 6→)

留言6則, 3人參與討論串1/1

※ 引述《Smallxiami (我在飛)》之銘言： : 想請教一下 : 目前已完成一個PHP的網頁以連結上MYSQL 可以和MYSQL同步並將MYSQL裡面的資料顯 : 示到頁面上 : http://203.145.207.62/web003/ : 目前想實現一個目標就是將GPS的值和Dtime的值導出變成一個參數可以在html的 : 語法內使用想要讓資料表裡面的座標會自動在地圖上標示出來目前只能用手動輸入 : 想請益有無方向目前是無頭緒中新手剛接觸如果解釋不詳細請推文告知 : 感謝以參照 http://ppt.cc/Twmr 目前是做到 Using PHP's DOM functions to Output XML 此為我目前的成果 http://203.145.207.62/web003/try005.php 似乎錯很大麻煩幫忙一下感謝確定有連結到 mysql 程式碼 <?php require_once('Connections/try001.php'); if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $dom = new DOMDocument("1.0"); $node = $dom->createElement("try001"); $parnode = $dom->appendChild($node); mysql_select_db($database_try001, $try001); $query_Recordset1 = "SELECT * FROM try001 ORDER BY id DESC"; $Recordset1 = mysql_query($query_Recordset1, $try001) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); header("Content-type: text/xml"); // Iterate through the rows, adding XML nodes for each while ($row = @mysql_fetch_assoc($Recordset1)){ // ADD TO XML DOCUMENT NODE $node = $dom->createElement("try001"); $newnode = $parnode->appendChild($node); $newnode->setAttribute("name",$row['name']); $newnode->setAttribute("address", $row['address']); $newnode->setAttribute("lat", $row['lat']); $newnode->setAttribute("lng", $row['lng']); $newnode->setAttribute("type", $row['type']); } echo $dom->saveXML(); ?> -- ※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 49.159.186.96 ※ 文章網址: https://www.ptt.cc/bbs/PHP/M.1428786070.A.24E.html ※ 編輯: Smallxiami (49.159.186.96), 04/12/2015 05:02:06