应项目需求,让改一个php后台代码,对于一个从未碰过php,前端也不怎么接触。只好通过快速学习来,补充知识点,通过学习对于php如何从数据库中获取数据,并且转为json,传给前端做一次总结。
PHP端
<? 数据库
$inAjax = $_GET['inAjax'];
$do = $_GET['do'];
$do = $do ? $do : "default";//连接数据库
session_start();
require_once("");//可以配置数据库连接信息自行定义
$db_connection = new mysqli(DB_HOST,DB_USER,DB_PASS,"");//数据库进行连接
//查询数据
$time_value_sql = "//查询数据sql语
$result_time_value = $db_connection->query($time_value_sql);//执行查询语句
//处理数据
if($result_time_value->num_rows > 0){//判断是否查到空
while($time_value_array = $result_time_value->fetch_array(MYSQLI_ASSOC)){ //读取查到的数据
$x_y[] = array(strtotime($time_value_array['TimeStamp'])*1000,intval($time_value_array['Value']));//生成数组
}
}
//将数据变为json
echo json_encode($x_y);?>
HTML 端
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width">
<script type="text/javascript" src="jquery-1.9.1.min.js"></script>
</head>
<body>
<script type="text/javascript">
$("document").ready(function() {
var url ="client_2.php";
var data={}
$.getJSON(url,data,function(res){//获取数据后想要做的事情
});
});
</script>
Username:<input type="text" name="username" id="username" />
Address:<input type="text" name="address" id="address" />
</body>
</html>