<?php
header("content-type:text/html;charset=utf8");//加句这个在程序的最前面
error_reporting(E_ALL ^ E_NOTICE);
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "info";
$json=array();
$arr=array();
$diy_json='';
$diy_callback = 'checking_in_callback';
$diy_json = $diy_callback . '({';
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
//echo "<script>alert(".$department.");</script>";
$year = date('Y'); //得到年份
$month = date('m'); //得到月份
$day = date('d'); //日期
$sql = "SELECT DeptName AS `学院名称`,";
$sql = $sql."Status AS `状态`,";
$sql = $sql."count ";
$sql = $sql."FROM query_checking_in_info ";
$conn->query("set names utf8"); //提交前,加入。解决数据库中文乱码
$result = $conn->query($sql);
$department_arr = array();
if ($result ->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
if(array_key_exists($row["学院名称"], $department_arr))
{
$department_arr[$row["学院名称"]] = $department_arr[$row["学院名称"]]. "\"". $row["状态"]. "\":". $row["count"]. ",";
}
else
{
$department_arr[$row["学院名称"]] = "";
$department_arr[$row["学院名称"]] = $department_arr[$row["学院名称"]]. "\"". $row["状态"]. "\":". $row["count"]. ",";
}
} // end while
while(list($key, $val)= each($department_arr)) {
$diy_json = $diy_json. "\"". $key. "\":{". mb_substr($val, 0, mb_strlen($val,'UTF8') - 1, 'UTF8'). "},";
}
$diy_json = mb_substr($diy_json, 0, mb_strlen($diy_json,'UTF8') - 1, 'UTF8');
} else {
echo "<br> 无数据 ";
} // end if
$json[]=$arr;
$json = json_encode($json);
$callback = "checking_in_callback";
$diy_json = $diy_json.'})';
print $diy_json;
$conn->close();
?>