完整示例代码如下:
error_reporting(E_ALL || ~E_NOTICE);
$link = mysql_connect('xxx:3306', 'root', 'xxx');
if (!$link) {
echo "fail";
}
mysql_select_db("study");
$result = mysql_query("select * from t_user");
class User
{
public $login_name;
public $usable;
public $create_time;
}
$data = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$user = new User();
$user->login_name = $row["login_name"];
$user->usable = $row["usable"];
$user->create_time = $row["create_time"];
$data[] = $user;
}
$json = json_encode($data);
echo "{" . '"user"' . ":" . $json . "}";