1 建立數據庫、注冊表
create database test;
create table test.login(
id int primary key,
name varchar(20) not null,
password varchar(20) not null
);
insert into test.login values
('1','hong','1234'),
('2','linxiang','1234'),
('3','chen','99a9s'),
('4','luxi','aabe2'); 
2 建立jsonreader.php和get.php
jsonreader.php調用json.js
get.php讀取數據庫數據
jsonreader.php =>
<html>
<head>
<title>注冊-Liehuo.Net</title>
<link rel="stylesheet" type="text/css" href="../ext/resources/css/ext-all.css" />
<script type="text/javascript" src="../ext/adapter/ext/ext-base.js"></script>
<script type="text/javascript" src="../ext/ext-all.js"></script>
<script type="text/javascript" src="json.js"></script>
</head>
<body>
<div id='grid'></div>
</body>
</html>
get.php=>
<?php
$conn=mysql_connect("localhost","root","123");
mysql_select_db("test");
$sql="select id,name,password from login";
$result=mysql_query($sql,$conn);
while($row=mysql_fetch_array($result))
{
$arr4[]=$row;
}
echo json_encode($arr4);
?>
3 extjs文件json.js編寫
json.js=>
Ext.onReady(function() {
store=new Ext.data.JsonStore({
url:'get.php',
data:[],
fields:[
{name:'id'},
{name:'name'},
{name:'password'}
]
});
store.load();
new Ext.grid.GridPanel({
store:store,
mode:'remote',
title:'簡單Grid表格示例',
applyTo:'grid',
width:250,
height:150,
frame:true,
columns:[
{header:"id",width:50,dataIndex:'id',sortable:true},
{header:"姓名",width:80,dataIndex:'name',sortable:true},
{header:"年齡",width:80,dataIndex:'password',sortable:true}
]
})
});
4 運行http://localhost/register/jsonreader.php
5 總結
php獲取mysql的數據，轉換為數組，然后運用json_encode
while($row=mysql_fetch_array($result))
{
$arr4[]=$row;
}
echo json_encode($arr4);
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
