最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
完整php ajax用户注册与用户名验证实例
时间:2010-12-21 编辑:简简单单 来源:一聚教程网
checkusername.php文件
$username = $_get['username'];
mysql教程_connect('127.0.0.1', 'root', '') or die('could not connect: ' . mysql_error());
mysql_select_db('test');
//拼接sql语句时必须将用户输入的值做处理,替换特殊字符,用引号包含
$username = htmlentities($username,ent_quotes);
$sql = "select count(*) from user where username ='{$username}'";
$result = mysql_query($sql);
if($row = mysql_fetch_array($result, mysql_num)){
$cnt = $row[0];
if($cnt == 0) {
echo '用户名未被使用';
} else {
echo '用户名已被使用,请改换用户名';
}
}
?>
verifycode.php验证码程序
session_start();
$rnd = array_merge(range(0,9),range('a','z'));
shuffle($rnd);
$code = implode('',$rnd);
$code = substr($code,0,4);
$_session['verifycode'] = $code;
header("content-type: image/png");
$im = @imagecreate(50, 25) or die("cannot initialize new gd image stream");
$background_color = imagecolorallocate($im, 255, 255, 255);
$text_color = imagecolorallocate($im, 233, 14, 91);
imagestring($im, 5, 5, 5, $code, $text_color);
imagepng($im);
imagedestroy($im);
?>
checkcode.php 检测用户输入的验证码是否一致
session_start();
$code = $_get['code'];
echo strtoupper($code) == $_session['verifycode'] ? '验证码正确' : '验证码错误';
?>
register.php注册处理程序
session_start();
$filename = '';
if(isset($_files['photo'])){
$uploaddir = dirname(__file__) . directory_separator . 'upload';
$originfilename = $_files['photo']['name'];
$extname = strtolower(substr($originfilename,strrpos($originfilename,'.')+1));
$filename = time() . '.' . $extname;
$validext = array('jpg','jpeg','gif','png');
if(!in_array($extname,$validext)){
errormsg("错误的文件类型");
}
if($_files['photo']['size'] > 100*1024){
errormsg("文件太大,超过了100k");
}
$uploadfile = $uploaddir . directory_separator . $filename;
if(!move_uploaded_file($_files['photo']['tmp_name'], $uploadfile)) {
errormsg("照片上传失败");
}
}
$code = $_post['verifycode'];
if($code != $_session['verifycode']){
errormsg("验证码输入不正确");
}
mysql_connect('127.0.0.1', 'root', '');
mysql_select_db('test');
mysql_query('set names utf8');
$username = addslashes($_post['username']);
$pwd = md5($_post['pwd']);
$name = addslashes($_post['name']);
$sex = addslashes($_post['sex']);
$age = intval($_post['age']);
$mobile = addslashes($_post['mobile']);
$address = addslashes($_post['address']);
$email = addslashes($_post['email']);
$photo = $filename;
$birthday = addslashes($_post['birthday']);
$sql = "insert into user(username,pwd,name,sex,age,mobile,address,email,photo,birthday)
values('$username','$pwd','$name','$sex',$age,'$mobile','$address','$email','$photo','$birthday')";
if(!mysql_query($sql)){
errormsg('数据库教程写入不成功!');
}
$sql = 'select * from user';
$res = mysql_query($sql);
echo '
用户名 | 姓名 | 性别 | 年龄 | 手机 | 通信地址 | 邮件地址 | 出生日期 |
{$row['username']} | {$row['name']} | {$row['sex']} | {$row['age']} | {$row['mobile']} | {$row['address']} | {$row['email']} | {$row['birthday']} |
function errormsg($str){
die('');
}
?>
最简单数据库结构
drop database if exists test;
create database test character set utf8 collate utf8_general_ci;
use test;
create table user(
username char(10) primary key
,pwd char(32) not null
,name char(10) not null
,sex char(1) not null
,mobile char(11)
,age smallint
,address varchar(50)
,email varchar(30)
,photo varchar(20)
,birthday date
);
http://down.111com.net/down/code/php/qitayuanma/2010/1220/22331.html
-
上一个: php实用阶乘函数
-
下一个: php生成验证码类代码
相关文章
- PHP导出数据超时的优化建议解读 10-31
- PHP之mysql位运算解析 10-31
- Laravel实现登录跳转功能解析 10-31
- php双向队列解读 10-31
- Laravel异常上下文解决教程 10-24
- php数组查询元素位置方法介绍 10-24