关于PHP连接MySQL返回JSON格式

1、建立数据库以及测试表。

drop database test;
create database test;

use test;

create table app_users (
user_id int(12) auto_increment,
user_code varchar(60) not null,
user_name varchar(256) null,
primary key(user_id)
);

insert into app_users(user_code, user_name) values('9001', 'jzh');
insert into app_users(user_code, user_name) values('9002', 'chanpinxue.cn');
insert into app_users(user_code, user_name) values('9003', 'chanpinxue.cn');

2、建立数据库连接配置文件db.php。

<?php

$mysql_server_name = 'localhost';
$mysql_username = 'root';
$mysql_password = 'root';
$mysql_database = 'test';

?>

3、建立测试文件user.php。

<?php
require("db.php");

$conn = mysql_connect($mysql_server_name, $mysql_username, $mysql_password) or die("error connecting");
mysql_query("set names 'utf8'");
mysql_select_db($mysql_database);
$result = mysql_query("select * from app_users");
$data = "";
$array = array();

class User{
    public $usercode;
    public $username;
}

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $user = new User();
    $user->usercode = $row['user_code'];
    $user->username = $row['user_name'];
    $array[] = $user;
}

$data = json_encode($array);
echo $data;
?>

输出结果：

[{“usercode”:”9001″,”username”:”jzh”},{“usercode”:”9002″,”username”:”chanpinxue.cn”},{“usercode”:”9003″,”username”:”chanpinxue.cn”}]