PHP 从数据库中取出数据并存为Json数据

lsdwyl

<?php
include 'conn.php';
$sql ="select * from user"; //SQL
$result =mysql_query($sql);//执行SQL
$json ="";
$data =array(); //定义好一个数组.PHP中array相当于一个数据字典.
//定义一个类,用到存放从数据库中取出的数据.
class User
{
public  $name ;
public $id ;
}
//
while ($row= mysql_fetch_array($result, MYSQL_ASSOC))
{
$user =new User();
$user->name = $row["name"];
$user->id = $row["id"];
$data[]=$user;
}
$json = json_encode($data);//把数据转换为JSON数据.
echo "{".'"user"'.":".$json."}";
?>


结果:
{"user":[{"name":"king","id":"1"},{"name":"mm","id":"23"},{"name":"232r","id":"43"},{"name":"8gb","id":"63"},{"name":"sdl","id":"71"},{"name":"5ff","id":"76"},{"name":"ddt","id":"232"},{"name":"3DD","id":"234"},{"name":"43dd","id":"332"},{"name":"674","id":"445"},{"name":"safd3sdf","id":"523"},{"name":"nnn","id":"873"},{"name":"linsdf1","id":"3921"},{"name":"ODSI","id":"6734"},{"name":"45342","id":"6756"},{"name":"tyr","id":"7865"},{"name":"sasdf","id":"8231"},{"name":"linok","id":"8364"},{"name":"hlele","id":"8372"},{"name":"helloking","id":"8392"},{"name":"lidfn","id":"8763"},{"name":"wfasdf03","id":"12321"},{"name":"3423sd","id":"45312"},{"name":"safd3sdf","id":"564342"},{"name":"sdflaso","id":"823123"},{"name":"ssaaa","id":"823131"},{"name":"safd3sdf","id":"5643421"}]}