<?php

/

1.在company数据user表中取出10条数据，保存为数组

2.在将数组转化为json格式，传递给js

3.用json解析器将传递过来的json字符串转化为json对象,

4.用document.write输出语句打印在页面上

*/

 

$conn = mysql_connect(“localhost”,”root”,”root”);   //连接数据库

mysql_query(“set names utf8″);                       //设置编码

mysql_select_db(“company”,$conn);                   //选择库

$sql = “select * from user limit 10″;               //在user表中查询10条数据

$res = mysql_query($sql);                           //执行sql语句

$arr = array();

while($row = mysql_fetch_array($res,MYSQL_ASSOC)){   //查询出来sql

$arr[] = $row;                                   //将查询出来的结果赋给数组$arr

}

$str = json_encode($arr);                           //将数组转化为json格式的字符串

?>

<script src=”json_parse.js”></script>                   <!– 引入json解析器 –>

<table>

<tr>

<th>uid</th><th>用户名</th><th>性别</th><th>email</th>

</tr>

<script>

var jsonString = ‘<?php echo $str;?>’;          //传递php中的数据给js

//document.write(jsonString);

var jsonObject = json_parse(jsonString);           //将json字符串转化为js中的json对象

for(var i = 0; i < jsonObject.length; i++){           //for循环打印

document.write(“<tr>”);

document.write(“<td>”,jsonObject[i].uid,”</td>”);

document.write(“<td>”,jsonObject[i].username,”</td>”);

document.write(“<td>”,jsonObject[i].sex,”</td>”);

document.write(“<td>”,jsonObject[i].email,”</td>”);

document.write(“</tr>”);

}

</script>

</table>