PHP에서 mysql 데이터를 json 형식으로 변환하는 방법

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `login_name` varchar(50) NOT NULL COMMENT '用户名',
  `usable` int(11) NOT NULL DEFAULT '1' COMMENT '是否可用 0：不可用；1：可用',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `last_login_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后登录时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_name` (`login_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';

创建mysql连接
$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 . "}";

{"user":[{"login_name":"aa1","usable":"2","create_time":"2017-08-29 18:21:35"},{"login_name":"aa","usable":"1","create_time":"2017-08-29 18:22:30"}]}

로그인 후 복사