PHP单页网站直接连接MYSQL数据库在首页显示数据

<?php error_reporting(0); $m = $_GET['m']; if (!$m) { index() ; } else if ($m == 'more') { more(); } /** * 首页，查询最新一条数据 */ function index() { $conn = getConn(); // 查询最大的一条 $result = mysql_query("select * from datavalue5 order by id desc limit 1", $conn); $arr = array(); while ($row = mysql_fetch_array($result)) { $arr[] = getRow($row); } echo json_encode($arr); closeConn($conn); } /** * 首页，查询最新一条数据 */ function more() { $conn = getConn(); $limit = isset($_GET['limit']) ? addslashes($_GET['limit']) : '2'; $lastId = isset($_GET['lastId']) ? addslashes($_GET['lastId']) : '999999999'; //echo $lastId; // 查询最大的一条 $result = mysql_query("select * from datavalue5 where id < ". $lastId. " order by id desc limit 1, ". $limit, $conn); $arr = array(); while ($row = mysql_fetch_array($result)) { $arr[] = getRow($row); } echo json_encode($arr); closeConn($conn); } /** * 转换结果集 */ function getRow($rs) { $row = array( 'id'=>$rs['ID'], 'getdatatime'=>$rs['getdatatime'], 'wirtetime'=>$rs['wirtetime'], 'Number'=>$rs['Number'], 'sequential_probeid'=>$rs['sequential_probeid'], 'probe1'=>number_format($rs['probe1']), 'probe2'=>number_format($rs['probe2']), 'probe3'=>number_format($rs['probe3']), 'probe4'=>number_format($rs['probe4']), 'probe5'=>number_format($rs['probe5']), 'probe6'=>number_format($rs['probe6']), 'probe7'=>number_format($rs['probe7']), 'probe8'=>$rs['probe8'], 'probe9'=>number_format($rs['probe9']), 'probe10'=>number_format($rs['probe10']), 'probe11'=>number_format($rs['probe11']), 'probe12'=>number_format($rs['probe12']), 'probe13'=>number_format($rs['probe13']), 'probe15'=>$rs['probe15'] ); return $row; } /** * 获取连接 */ function getConn() { $host = "localhost"; $user = "root"; $pwd = "root"; $db = "test"; $conn = mysql_connect($host, $user, $pwd); if (!$conn){ die('Could not connect: ' . mysql_error()); } mysql_select_db($db, $conn); mysql_set_charset('utf8', $conn); return $conn; } /** * 关闭连接 */ function closeConn($conn) { mysql_close($conn); } ?>