php 登录mysql json,关于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。

$mysql_server_name = 'localhost';

$mysql_username = 'root';

$mysql_password = 'root';

$mysql_database = 'test';

?>

3、建立测试文件user.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”}]