select date sql opposite DATE PHP ECHO JSON


select date sql opposite DATE PHP ECHO JSON

SELECT information from server,
我正在获取日期格式为年月日.
我试着把日期与DD/MM/YYYY

相反

信息必须是echo in JSON array.

你能帮我查一下日期吗?下面是我的代码:
$query = mysql_query("SELECT * FROM Shows WHERE ID ='{$ID}' ORDER BY date ASC");
$users = array();
    while ($row = mysql_fetch_array($query))    
    {
    $users[] = array('date' => $row['date'],'day' => $row['day'],'hour' => $row['hour']);
    }
    echo json_encode($users);

修改$users声明为:

$users[] = array('date' => date( 'd/m/Y', strtotime($row['date']) )