<?php  
header('Content-Type:application/json;charset=utf-8');  
$servername = "localhost";  
$username = "username";  
$password = "password";  
$dbname = "myDB";  
  
// 创建连接  
$conn = new mysqli($servername, $username, $password, $dbname);  
// 检查连接  
if ($conn->connect_error) {  
  die("连接失败: " . $conn->connect_error);  
}  
  
// 获取当前日期  
$date = date("Y-m-d");  
  
// 获取数据  
$sql = "SELECT * FROM MyGuests WHERE reg_date LIKE '$date%'";  
$result = $conn->query($sql);  
  
if ($result->num_rows > 0) {  
  // 输出数据  
  while($row = $result->fetch_assoc()) {  
    echo json_encode($row);  
  }  
} else {  
  echo "0 结果";  
}  
$conn->close();  
?>