ExtJS与PHP、MySQL实现存储

2010-03-29 22:28 夜雨瞳阅读(2148) 评论(0) 编辑收藏举报

1 建立数据库、注册表

create database db_register;
create table db_register.tb_register(
reg_loginid varchar(20) primary key,
reg_name varchar(20) not null,
reg_id int not null,
reg_password varchar(20) not null,
reg_sex varchar(2),
reg_address varchar(50)
);

2 建立register.php和save.php

save.php数据存储

save.php=>

<?php
if($_POST['password']!=$_POST['repassword'])
{
//不执行存储
    exit;
}

$conn=mysql_connect("localhost","root","123");
mysql_select_db("db_register");

$sql="insert into tb_register(reg_loginid,reg_name,reg_id,reg_password,reg_sex,reg_address)
values('".$_POST['login']."','".$_POST['name']."','".$_POST['id']."','".$_POST['password']."','"
.$_POST['sex']."','".$_POST['address']."')";
if(mysql_query($sql,$conn))
{
    echo "注册成功";
}
else
{
    echo "注册失败";
}
mysql_close($conn);
?>

3 ExtJs文件register.js编写

代码

Ext.onReady(function() {
    function registerhandler(){
        var values = Ext.getCmp("form").getForm().getValues();        //获取form里textfield、radio等值
        Ext.Ajax.request({
               url: 'save.php',
               success: function() {Ext.Msg.alert("success");},
               method: "post",
               failure: function(){Ext.Msg.alert("failure");},
               params: values
            });
    }
    var form = new Ext.form.FormPanel({
        id: 'form',
        baseCls: 'x-plain',
        layout:'absolute',
        url:'save-form.php',
        defaultType: 'textfield',
        items: [{
            x: 0,
            y: 0,
            xtype:'label',
            text: '登录帐户:'
        },{
            x: 80,
            y: 0,
            name:'login',
            anchor:'100%'
        },{
            x: 0,
            y: 30,
            xtype:'label',
            text: '用户姓名:'
        },{
            x: 80,
            y: 30,
            name:'name',
            anchor: '100%',
        },{
            x:0,
            y:60,
            xtype:'label',
            text:'身份证号:'
        },{
            x:80,
            y:60,
            name:'id',
            anchor:'100%',
        },{
            x:0,
            y:90,
            xtype:'label',
            text:'用户密码:'
        },{
            x:80,
            y:90,
            inputType:'password',
            name:'password',
            anchor:'100%',
        },{
            x:0,
            y:120,
            xtype:'label',
            text:'密码确认:',
        },{
            x:80,
            y:120,
            name:'repassword',
            inputType:'password',
            anchor:'100%',
        },{
            x:80,
            y:150,
            xtype:'radio',
            name:'sex',
            fieldLabel:'性别',
            boxLabel:'男',
            inputValue:'b'                //radio的取值为:b
        },{
            x:0,
            y:152,
            xtype:'label',
            text:'性别:'
        },{
            x:140,
            y:150,
            xtype:'radio',
            name:'sex',
            fieldLabel:'性别',
            boxLabel:'女',
            inputValue:'g'                //radio的取值为:g
        },{
            x:0,
            y:180,
            xtype:'label',
            text:'用户住址'
        },{
            x:80,
            y:180,
            name:'address',
            anchor:'100%'
        }]
    });

    var window = new Ext.Window({
        title: '注册帐户',
        width: 400,
        height:300,
        minWidth:400,
        minHeight: 300,
        layout: 'fit',
        plain:true,
        bodyStyle:'padding:5px;',
        buttonAlign:'center',
        items: form,
        buttons: [{
            text: '注册',
            handler:registerhandler
        },{
            text: '取消'
        }]
    });

    window.show();
});

4 运行http://localhost/register/register.php