Complete php ajax user registration and username verification example_PHP tutorial

 
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  
   
   
   
  
  

用户名：
密码：
重复密码：
姓名：
性别：	男     女
年龄：
手机：
通信地址：
邮件地址：
用户照片：
出生日期：
验证码：

checkusername.php file

$username = $_get['username'];
mysql tutorial_connect('127.0.0.1', 'root', '') or die('could not connect: ' . mysql_error());
mysql_select_db('test');

//When splicing sql statements, the values ​​entered by the user must be processed, special characters replaced, and
included in quotation marks $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 'Username not in use';
} else {
echo 'The username has been used, please change the username';
}
}
?>

verifycode.php verification code program

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 checks whether the verification code entered by the user is consistent
session_start();

$code = $_get['code'];

echo strtoupper($code) == $_session['verifycode'] ? 'Verification code is correct' : 'Verification code is wrong';
?>

register.php registration handler

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("Wrong file type");
}

if($_files['photo']['size'] > 100*1024){
errormsg("The file is too large, exceeding 100k");
}
$uploadfile = $uploaddir . directory_separator . $filename;

if(!move_uploaded_file($_files['photo']['tmp_name'], $uploadfile)) {
errormsg("Photo upload failed");
}
}

$code = $_post['verifycode'];
if($code != $_session['verifycode']){
errormsg("The verification code input is incorrect");
}

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('Database tutorial writing failed!');
}

$sql = 'select * from user';
$res = mysql_query($sql);
echo '
 

  
   
   
   
   
   
   
   
   

  
';
while($row = mysql_fetch_assoc($res)){
 $photo = $row['photo'] ? "" : '';
 echo "
  
   
   
   
   
   
   
   
   

  
 ";
 
}

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.bKjia.c0m/down/code/php/qitayuanma/2010/1220/22331.html

http://www.bkjia.com/PHPjc/631710.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/631710.htmlTechArticle!doctype html public -//w3c//dtd html 4.01 transitional//en http://www.w3.org/tr/html4/loose.dtd html head meta http-equiv=content-type content=text/html; charset=gb2312 titleinser...