getdat.php

最新推荐文章于 2025-12-03 12:04:55 发布

转载最新推荐文章于 2025-12-03 12:04:55 发布 · 106 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/u/3428739/blog/1517421

文章标签：

#php

<?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();

转载于:https://my.oschina.net/u/3428739/blog/1517421