网学网为广大网友收集整理了,ExtJS与PHP、MySQL实现存储的方法,希望对大家有所帮助!
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 register.php调用ExtJS文件
save.php数据存储
register.php=>
复制代码 代码如下:
<html>
<head>
<title>注册</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="register.js"></script>
</head>
<body>
</body>
</html>
save.php=>
复制代码 代码如下:
<?php
if(
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''password'']!=
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
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(''".
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''login'']."'',''".
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''name'']."'',''".
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''id'']."'',''".
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''password'']."'',''"
.
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''sex'']."'',''".
ExtJS与PHP、MySQL实现存储的方法_网学
浏览:
POST[''address'']."'')";
if(mysql_query($sql,$conn))
{
echo "注册成功";
}
else
{
echo "注册失败";
}
mysql_close($conn);
?>
3 ExtJs文件register.js编写 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:tr