<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www./TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www./1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>无标题文档</title> </head> <body> <?php $link=mysql_connect("localhost","root","123456");//连接数据库主机 mysql_select_db("baixing77",$link);//连接数据库 $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); echo "{".'"user"'.":".$json."}"; echo $json; ?> </body> </html> |
|