【php开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了php开源代码-data.php的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
<?php
//寮曠敤config.php
require_once 'config.php';
//杈撳嚭Header锛屽憡鐭ユ祻瑙堝櫒鏂囦欢绫诲瀷涓篨ML锛岀紪鐮佷负UTF-8
header("Content-type: text/xml; charset=utf-8");
echo '<?
xml version="1.0" encoding="utf-8"?>';
//鑾峰彇椤垫暟锛屽鏈畾涔夋垨闈炴硶瀹氫箟鍒欎娇鐢ㄩ粯璁ら〉
$page = isset($_GET["page"]) ? intval( $_GET["page"] ) : 0;
//姣忛〉鏉$洰鏁帮紝濡傛湭瀹氫箟鎴栭潪娉曞畾涔夊垯榛樿涓?00鏉℃暟鎹?
$pagesize = isset($_GET["pagesize"]) ? intval( $_GET["pagesize"] ) : 500;
//褰撴暟鎹笉鍚堟硶鏃舵姳閿?
if($page*$pagesize<0)
{
die('<err>Ilegal Input</err>');
}
//褰撴暟鎹悎娉曟椂杈撳嚭鏁版嵁
else
{
//璁$畻璁板綍鍋忕Щ閲?
$offset = $pagesize*$page;
//杩炴帴鏁版嵁搴?
mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
//閫夋嫨鏁版嵁搴擄紝鑻ュけ璐ュ垯鎶ラ敊鍋滄鎵ц
@mysql_select_db(DB_NAME) or die('<err>Unable to select database</err>');
//鎷兼帴SQL璇彞
$sql = "SELECT * FROM `guestinfo` ORDER BY `time` DESC LIMIT $offset, $pagesize";
//鎵цSQL璇彞锛屽苟杩斿洖鏁版嵁
$result = mysql_query($sql);
//鍙栧嚭鐨勬暟鎹潯鏁?
$num=mysql_numrows($result);
//鍏抽棴鏁版嵁搴?
mysql_close();
//杈撳嚭XML鏍煎紡鐨勬暟鎹?
echo '<mm>';
$i=0;
while($i < $num)
{
//鑾峰彇姣忎釜瀛楁鐨勪俊鎭?
$ip=trim (long2ip(my
sql_result($result,$i,"ip")));
$time=trim (
mysql_result($result,$i,"time"));
$lat=trim (mysql_result($result,$i,"lat"));
$lng=trim (mysql_result($result,$i,"lng"));
$city=trim (mysql_result($result,$i,"city"));
$region=trim (mysql_result($result,$i,"region"));
$country=trim (mysql_result($result,$i,"country"));
//$ua=trim (mysql_result($result,$i,"ua"));
//杈撳嚭姣忎釜鑺傜偣鐨勫唴瀹?
echo '<m ip="' . $ip . '" t="' . $time . '" lat="' . $lat . '"'
. ' lng="' . $lng . '" p="' . $city . '" r="' . $region . '"'
. ' c="' . $country . '" />';
$i++;
}
echo '</mm>';
}
?>