javascript代码:
// 初始化两个数组,盛装从数据库中获取到的数据
var dates = new Array(), moneys = new Array();
//调用ajax来实现异步的加载数据
function getusers() {
$.ajax({
type: "post",
async: false,
data:{},
url: "dataDemo/dataIndex.php",
data: {},
dataType: "json",
success: function(result){
if(result){
for(var i = 0; i < result.length; i++){
dates.push(result[i].sum);
moneys.push(result[i].money);
}
}
},
error: function(errmsg) {
alert("Ajax获取服务器数据出错了!"+ errmsg);
}
});
return dates, moneys;
}
//执行异步请求
getusers();
public_function.php代码:
<?php
function dbInit(){
global $con;
$dsn = "mysql:dbname=info;localhost=127.0.0.1";
$user = "root";
$password = "644066YanMin&&!+";
try{
$con = new PDO($dsn,$user,$password);
}catch(PDOExcepetion $e){
die ("Error!: " . $e->getMessage() . "<br/>");
}
}
/*
处理结果集中有多条数据的函数;
*/
function fetchAll($sql){
global $con;
class user{
public $times;
public $money;
}
if($result = $con->query($sql)){
//声明数组,用于接收结果集;
$data = array();
//遍历结果集;
while($row = $result->fetch(PDO::FETCH_ASSOC)){
$user = new User();
$user->times = $row['times'];
$user->money = $row['sum'];
$data[] = $user;
}
return $data;
}else{
//执行失败;
return false;
}
}
dataIndex.php代码
<?php
require "public_function.php";
dbInit();
$sql = 'select times,sum from date';
$datas = fetchAll($sql);
// 返回JSON类型的数据
echo json_encode($datas);
//$con = null;
require "dataIndex.html";