extjs获取mysql_extjs 读取数据库数据

Ext.onReady(function(){Ext.QuickTips.init();varurl='mysql.php';var_proxy=newExt.data.HttpProxy({url:url});var_jsonProperty="totalProperty";var_jsonRoot="root";var_record=...

Ext.onReady(function(){ Ext.QuickTips.init(); var url = 'mysql.php'; var _proxy = new Ext.data.HttpProxy({url:url}); var _jsonProperty = "totalProperty"; var _jsonRoot = "root"; var _record = [ {name:'book_id'}, {name:'book_name'}, {name:'book_author'}, {name:'book_type'}, {name:'book_flag'} ];

var store = new Ext.data.Store({ proxy:_proxy, reader:new Ext.data.JsonReader({ totelPropetty:_jsonProperty, root:_jsonRoot },Ext.data.Record.create([ {name:'book_id'}, {name:'book_name'}, {name:'book_author'}, {name:'book_type'}, {name:'book_flag'} ])) }); var grid = new Ext.grid.GridPanel({ store:store, title: ' 简单Grid表格 ' , region:'center', applyTo: ' grid ' , width: 250 , height: 150 , frame: true , columns:[ {header:"书号",width: 50 ,dataIndex: 'book_id' ,sortable: true }, {header:"书名",width: 50 ,dataIndex: 'book_name' ,sortable: true }, {header:"作者",width: 50 ,dataIndex: 'book_author' ,sortable: true }, {header:"类型",width: 50 ,dataIndex: 'book_type' ,sortable: true }, {header:"有货",width: 50 ,dataIndex: 'book_flag' ,sortable: true } ] }); store.load();

});

mysql.php------------------------------------->

// 连接到数据库 $conn=mysql_connect($server_name, $username, $password);if (!$conn) { die('Could not connect: ' . mysql_error()); }else{ echo "连接成功！";} mysql_query("set names utf8");// 从表中提取信息的sql语句 $strsql="select * from library order by book_id";

//执行sql查询 mysql_select_db($mysql_database,$conn);$result=mysql_query($strsql);while( $row = mysql_fetch_array($result)){ $arr[] = $row;} $json_data = "{totalProperty:100,root:".json_encode($arr)."}"; echo $json_data

?>

页面什么也不显示，调试报错

展开