php安装dat,getdat.php

header("Content-Type: text/html; charset=utf-8") ;

$date = $_GET['onlinedate'];

$user = new mysqli();

if($user)

{

$user->connect("localhost", "root", "123456", "moboxdb");

if (mysqli_connect_errno())

{

$arr = array(

'code'=>'400',

'info'=>"Failed!"

);

echo json_encode($arr,JSON_UNESCAPED_UNICODE);

exit();

}

}

else

{

$arr = array(

'code'=>'400',

'info'=>"Failed!",

);

echo json_encode($arr,JSON_UNESCAPED_UNICODE);

exit();

}

$user->query("set names 'utf8' ");

$query = "SELECT * from boxtrace where onlinedate>'$date'";

//$query = "SELECT * from boxtrace";

//Use a variable to save result

if($result = $user->query($query))

{

$arr = array(

'code'=>'200',

'info'=>"retrieve data successfully!",

'num'=>$result->num_rows,

'data'=>$result->fetch_all()

);

echo json_encode($arr,JSON_UNESCAPED_UNICODE);

}

else

{

$arr = array(

'code'=>'400',

'info'=>"Failed to get data!"

);

echo json_encode($arr,JSON_UNESCAPED_UNICODE);

}

$user->close();

?>