php数据库数据转换为js中的json对象
<?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>
转载:http://blog.csdn.net/leo_618/article/details/50257327
用php操作mysql数据库,取数据
<?php
$con = mysqli_connect("localhost", "root", "", "test");
if (mysqli_connect_errno($con)) {
echo "连接 MySQL 失败: " . mysqli_connect_error();
}
mysqli_query($con, "set names utf8");
/*
$index=0;
while($index<1000) {
$result = mysqli_query($con, "INSERT INTO `test`.`user` (`Id` ,`UserName` ,`Password` ,`Email`)VALUES
(NULL , '刘志伟', '1122', '154651566@qq.com')");
$index++;
}
*/
$result = mysqli_query($con, "SELECT * FROM USER");
//$row = mysqli_fetch_assoc($result);
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
$json = json_encode($data);
//echo $json;
//echo "{"."\"data\"".":"."$json"."}";
echo "{".'"data"'.":"."$json"."}";
//$breed = array_slice($row, 8, 24);
//foreach ($breed as $k=>$v) {
// $data[]=array($k,floatval($v));
//}
//$data=json_encode($data);
//echo "{".'"data"'.":".$data."}";
//echo $data;
//echo ($data);
//while ($row = mysqli_fetch_assoc($result)) {
// print_r($row);
//echo "<br>";
// $breed = array_slice($row, 8, 24);
// $data = json_encode($breed);
//echo $data;
// print_r($data);
// echo "<br>";
//}
mysqli_close($con);
?>
这几天一直弄json,之前了解点json的概念的,但是没有接触到怎么使用,前几天接了个小项目,开始搞php,mysql,jquery, Ajax, 把之前学的知识都整合在一起,发现自己的知识体系不是很完善,看到网上有好多json例子,有好多例子,用处也有很多,什么highcharts,echarts,datatable,web应用都用到json。还是要多实践。。。
有句话,实践是检验真理的一切