您现在的位置是：首页 >

php增删改查带数据库解析Extjs与php数据交互(增删查改)

火烧 2021-07-06 21:08:13 1043

解析Extj 与 h 数据交互增删查改　　代码如下: lt gt lt head gt //搜索暂时没做数据是出来了但是却没法显示 lt li k rel=" tyle heet" ty e=

解析Extjs与php数据交互(增删查改)

　　代码如下:

<> <head> //搜索暂时没做数据是出来了但是却没法显示 <link rel="stylesheet" type=text/css href=" /js/resources/css/ext all css"/> <script type=text/javascript src= /js/jquery js></script> <script type=text/javascript src= /js/ext base js></script> <script type=text/javascript src= /js/ext all js></script> <script type=text/javascript src= /js/ext lang zh_CN min js></script> <script type=text/javascript> Ext QuickTips init(); //初始化快速提示对象 function test() { Ext Msg alert( title test yii ext ); } function renderSex(value) { if (value == male ) { return "<span style= color:red;font weight:bold; >红男</span><img src= /images/male jpg />"; } else { return "<span style= color:green;font weight:bold; >绿女</span><img src= /images/female png />"; } } function init() { // 创建url访问类 var url = index php ; var _proxy = new Ext data HttpProxy({url:url}); // 数据问题参数 var _jsonProperty = "totalProperty"; //数据根目录参数 var _jsonRoot = "root"; //Record显示列表对应关系 var _record = [{name: id } {name: name } {name: pass } {name: sex } {name: email }]; //创建JSONReader对象需要设置记录总数根目录名称记录映射 var _reader = new Ext data JsonReader({totelPropetty:_jsonProperty root:_jsonRoot} _record); /** * 封装一个客户端的Record对象缓存为GridPanel提供数据入口 * 需要两个必须的参数 * 提供数据的地址 Proxy 代理类 * 数据的读取方式 Reader 类这里通过JsonReader读取 */ var _store = new Ext data Store({ proxy:_proxy reader:_reader }); /** ColumnModel * 数据在页面上显示标题信息 * 顺序和Record对应 * sortable 是否排序 * dataIndex 进行对应的列对应Record中的NAME * * handler方法中第一个参数表示父类的对象本例中为GridPanel对象 * 第二个参数表示第几行 * 第三个参数表示第几列 */ var _cm = new Ext grid ColumnModel([ new Ext grid RowNumberer() new Ext grid CheckboxSelectionModel() {header:"ID" dataIndex:"id" width: sortable:true menuDisabled:true} {header:"用户名" dataIndex:"name" width: sortable:true} {header:"密码" dataIndex:"pass" width: sortable:true} {header:"性别" dataIndex:"sex" width: sortable:true renderer:renderSex} {header:"电子邮箱" dataIndex:"email" width: sortable:true} ]); /////////////////////////搜索 var logins = new Ext form FormPanel({ id: myform //分配表单id title: 按用户名搜索 width: defaultType: textfield frame: true // method: POST collapsible: true //可折叠 bodyPadding: layout: column //列布局 margin: items: [{ fieldLabel: 姓名 labelWidth: id: name }] buttons: [{ // xtype: button text: 搜索 margin: handler: search } { // xtype: button text: 隐藏 margin: handler: hide }] renderTo: "search" }) logins hide(); function hide() { logins hide(); } /////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////// //获取数据 var ds = new Ext data Store({ //proxy告诉我们从哪获得数据 Ext data MemoryProxy专门解析js变量 //proxy:new Ext data MemoryProxy(data) //通过获取数据 proxy:new Ext data HttpProxy({ url:url}) //获取json数据 reader:new Ext data JsonReader({ totalProperty: totalProperty root: root } Ext data Record create([ {name: id } {name: name } {name: pass } {name: sex } {name: email } ])) }); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////// //自动分页 var _pageSize = ; var _toolbar = new Ext PagingToolbar({ store:ds pageSize:_pageSize displayInfo:true displayMsg: 显示第{ }条到第{ }条记录一共{ }条 emptyMsg: 暂无数据 }); //顶部工具栏按钮 var t_toolbar = [ {id:"addData" text:"用户添加" handler:addUser} " " {id:"updateData" text:"用户修改" listeners:{"click":updateUser}} " " {id:"deleteData" text:"删除选中用户" handler:removeUser} " " {id:"test" text:"测试选中" handler:cSelects} " " {id:"search" text:"搜索" handler:jump} ]; /** * GridPanel对象 * 数据列表页面 * 必须设置 Store 数据访问对象和标题栏显示信息 * 即 Store和ColumnModel对象 */ var _grid = new Ext grid GridPanel({ headerAsText: false // 如果有标题栏隐藏标题栏 collapsible: true //可折叠 height: width: frame:true //圆角边框 store:ds title: 测试yii整合Ext cm:_cm bbar : _toolbar tbar : t_toolbar }); ds load({params:{start: limit:_pageSize}}); _grid render( test_id ); //_grid render(); var fpanel; function f(){ fpanel = new Ext form FormPanel ({ frame : true //边框圆角并且有背景色 labelAlign : right waitMsgTarget : true autoScroll : true buttonAlign : center items : [ {xtype:"hidden" name:"id"} {xtype:"textfield" fieldLabel:"用户名" name:"name" anchor : " " allowBlank:false //是否允许为空 blankText:"用户名不允许为空！" labelWidth : } {xtype:"radiogroup" fieldLabel:"性别" columns: allowBlank:false blankText:"性别不允许为空！" items:[{boxLabel: 男 name: sex inputValue: male } {boxLabel: 女 name: sex inputValue: female }]} {xtype:"textfield" fieldLabel:"密码" name:"pass" allowBlank:false //是否允许为空 blankText:"密码不允许为空！" anchor : " "} {xtype:"textarea" fieldLabel:"电子邮箱" name:"email" allowBlank:false //是否允许为空 blankText:"邮箱不允许为空！" anchor : " "} ] }); } var win; function addUser() { f(); win = new Ext Window ({ title:"新增用户" id:"win" //animEl:"fly" //layout:"fit" width: height: closeAction : "close" plain : true modal : true // 模态窗口当打开当前窗口时后面的内容被遮挡 bodyStyle:"padding: px px" layout:"form" labelWidth: items:[fpanel] buttons:[ {text:"保存" handler :function() { //在保存的时候因为Id值为空所以不能转换到后台后台报类型转换异常可以将Id设值为 //在后台处理的时候对于值为的Id不获取 fpanel findByType("hidden")[ ] setValue( ); fpanel getForm() submit({ url : "add php" method : "POST" waitMsg : "保存数据 " success : function(form action) { // 业务成功 Ext MessageBox alert( 提示添加成功! ); win close(); ds load({params:{ start: limit:_pageSize} }); } failure : function(form action) { // 业务失败 obj = Ext util JSON decode(action response responseText); Ext MessageBox alert( 提示 obj errors reason); win close(); ds load({params:{ start: limit:_pageSize} }); } }); } } { text:"重置" handler:function() { fpanel getForm() reset(); } } ] }) win show(); // 因为重复使用window 有可能在修改后fpanel中还存在数据所以要先重置 fpanel getForm() reset(); } function updateUser() { var win_ ; var a = ; f(); var selectedRecord = _grid getSelectionModel() getSelected(); // 获得多个数据 if (selectedRecord == undefined || selectedRecord == null) { Ext MessageBox alert("提示" "请先选择一条记录！"); } else { win_ = new Ext Window ({ title : "修改用户" width : height : closeAction : "hide" plain : true modal : true // 模态窗口当打开当前窗口时后面的内容被遮挡 bodyStyle : "padding: px px" //layout : "form" layout:"fit" labelWidth : items : [fpanel] buttons : [ {text:"修改" handler:function() {fpanel getForm() submit ({ url:"edit php" method:"POST" waitMsg:"数据修改中 " success:function(form action) { win_ hide(); Ext MessageBox alert("提示" "数据修改成功"); _ds reload(); } failure : function(form action) { win_ hide(); Ext MessageBox alert("提示" "<font color= red >数据修改失败</font>"); _ds load(); } }); } } { text : "重置" handler:function() { fpanel getForm() reset(); } } { text: 关闭 handler: function() { win_ close(); } } ] }); } win_ show(); // 将选中的数据load到window中显示 //alert(win_ ); win_ getComponent( ) getForm() loadRecord(selectedRecord); } function removeUser(btn) { var selectedRecord = _grid getSelectionModel() getSelected(); if (selectedRecord == undefined || selectedRecord == null) { Ext MessageBox alert("提示" "请先选择一条记录！"); } else { Ext MessageBox confirm("提示信息" "确定要删除吗？" function(btn) { if (btn == "yes") { Ext Ajax request( { url:"del php" method:"POST" params:{id : selectedRecord data id} success:function(request options) { var jsonRequest = Ext util JSON decode(request responseText); if (jsonRequest == true) { Ext Msg alert("提示信息" "删除成功"); _grid getStore() remove(selectedRecord); ds reload(); } else { Ext Msg alert("提示信息" "<font color= red >删除失败</font>"); } } failure : function() { Ext MessageBox show ({ title : "提示消息" msg : "删除时发生错误" }); } }); } }) } } function cSelects() { var selects = _grid getSelectionModel() getSelections(); alert("选中的总数为 "+selects length); } //////////////////////////////////////////////////////////////////////////////////////////////////////////////// function search(){ //fpanel GridPanel() reset();init(); logins getForm() submit({ //提交表单事件 //clientValidation: true method:"POST" //提交方式(POSTT和GET) url:"search php" //表单提交URL地址 waitMsg:"请稍等正在搜索 " //提交未完成提示框内容 waitTitle:"正在搜索" //提示框标题信息 }); var url = search php ; // store proxy=new Ext data HttpProxy({url:url}); ds reload(); //_proxy = new Ext data HttpProxy({url:url}); //ds load({params:{start: limit:_pageSize}}); //_grid render( test_id ); } function jump() { logins show(); } ////////////////////////////// } Ext onReady(init); </script> </head> <body> <p >　　 Index php文件

复制代码代码如下: <?php header("Content:text/;charset=utf "); $link = mysql_connect("localhost" "root" " ")or die( error mysql_error()); mysql_select_db("stu" $link); mysql_query( set names utf ); $sql = "select count(*) num from men"; $num = mysql_query($sql); $count = mysql_fetch_array($num); $start = $_POST[ start ]; $limit = $_POST[ limit ]; $sql = "SELECT * FROM men limit {$start} {$limit}"; /* if (!$_POST) { $sql = "SELECT * FROM member"; } else { $sql = "select * from member limit {$start} {$limit}"; } */ $data = array(); $result = mysql_query($sql ); while(!!$info = mysql_fetch_array($result MYSQL_ASSOC)) { $data[] = $info; } //$j = json_encode($data); $j = "{totalProperty: root:" json_encode($data) "}"; echo $j; ?>

　　 Add php文件如下

复制代码代码如下: <?php header("Content:text/;charset=utf "); $link = mysql_connect("localhost" "root" " ")or die( error mysql_error()); mysql_select_db("stu" $link); mysql_query( set names utf ); $name = $_POST[ username ]; $pwd = $_POST[ password ]; $time = $_POST[ regTime ]; $email = $_POST[ email ]; $sql = "INSERT INTO men (username password regTime email) VALUES ( {$name} {$pwd} {$time} {$email} )"; //mysql_query($sql) if (mysql_query($sql)) { echo ok ; } ?>

　　 Del php文件如下

复制代码代码如下: <?php header("Content:text/;charset=utf "); $link = mysql_connect("localhost" "root" " ")or die( error mysql_error()); mysql_select_db("stu" $link); mysql_query( set names utf ); $id = $_POST[ id ]; $sql = "DELETE FROM men WHERE id={$id}"; if (mysql_query($sql)) { echo ; } else { echo ; } ?> 复制代码代码如下: phpMyAdmin SQL Dump version 主机: localhost 生成日期: 年月日 : 服务器版本: PHP 版本: SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 数据库: `stu` 表的结构 `men` CREATE TABLE `men` ( `id` int( ) unsigned NOT NULL auto_increment `name` varchar( ) collate utf _unicode_ci NOT NULL `pass` varchar( ) collate utf _unicode_ci NOT NULL `sex` varchar( ) collate utf _unicode_ci NOT NULL `email` varchar( ) collate utf _unicode_ci NOT NULL PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf COLLATE=utf _unicode_ci AUTO_INCREMENT= ; 导出表中的数据 `men` INSERT INTO `men` (`id` `name` `pass` `sex` `email`) VALUES ( 赵四 female @qq ) ( 测试修改 male test@qq ) ( 赵勇 male sfsf@qq ) ( 赵勇 male sfsf@qq ) ( 赵勇 male sfsf@qq ) ( asdfsf asfsfsf male safsf ) ( male ) ( female ) ( female ) ( safdsdf sdf female sdf ) ( sdfsdf sdfsdf male sdf ) ( test test male test@qq ) ( saf asdfs male asdf ) ( dfgdfg dfgdfg male dfgdfg ) ( ertert erter male tertert ) ( asdf sdf male sdf ); lishixinzhi/Article/program/PHP/201311/21009

很赞哦！ (1043)

php增删改查带数据库解析Extjs与php数据交互(增删查改)

三字便利店名字大全三个字的便利店名字,三个字的便利店名字

易铭瑭詠塵!

php增删改查带数据库 解析Extjs与php数据交互(增删查改)

三字便利店名字大全 三个字的便利店名字,三个字的便利店名字

易铭瑭 詠塵!

php增删改查带数据库解析Extjs与php数据交互(增删查改)

三字便利店名字大全三个字的便利店名字,三个字的便利店名字

易铭瑭詠塵!