网站地图
【www.gdgbn.com--安卓教程】
<script type="text/网页特效">
function checkusername(input){
var name = input.value;
var url = "checkusername.php教程?username=" + name;
var xmlhttp = getxmlhttpobject();
xmlhttp.onreadystatechange = function(){
if (xmlhttp.readystate==4){
$$("pmt_username").innerhtml = xmlhttp.responsetext;
}
}
xmlhttp.open("get",url,true);
xmlhttp.send(null);
}
function getxmlhttpobject(){
var xmlhttp=null;
try{
// firefox, opera 8.0+, safari
xmlhttp=new xmlhttprequest();
}catch (e){
// internet explorer
try{
xmlhttp=new activexobject("msxml2.xmlhttp");
}catch (e){
xmlhttp=new activexobject("microsoft.xmlhttp");
}
}
return xmlhttp;
}
function checkform(form){
try{
assertnonempty(form.username);
assertnonempty(form.pwd);
// assertint(form.mobile);
} catch(e){
return false;
}
return true;
}
function assertnonempty(obj){
if(obj.value == ""){
var tds = gettdelems(obj);
var text = tds[0].innerhtml;
tds[1].innerhtml = text.slice(0,-1) + "不能为空";
obj.focus();
obj.select();
throw new exception();
}
}
function assertint(obj){
var v = obj.value;
if(/d{11}/.test(v)){
alert("ok");
} else {
alert("error");
}
if(number(v) != v){
var tds = gettdelems(obj);
var text = tds[0].innerhtml;
tds[1].innerhtml = text.slice(0,-1) + "应该是数值";
obj.focus();
obj.select();
throw new exception();
}
}
window.onload = function(){
// alert($$("username").type);
// $$("abc").onkeydown = mobilekeydown;
}
function gettdelems(obj){
var tr = obj.parentnode.parentnode;
var tds = tr.getelementsbytagname("td");
return [tds[0],tds[2]];
}
function mobilekeydown(e){
e = e || event;
return e.keycode >47 && e.keycode < 59;
}
function $$(id){
return document.getelementbyid(id);
}
function checkcode(input){
var name = input.value;
var url = "checkcode.php?code=" + name;
var xmlhttp = getxmlhttpobject();
xmlhttp.onreadystatechange = function(){
if (xmlhttp.readystate==4){
$$("code").innerhtml = xmlhttp.responsetext;
}
}
xmlhttp.open("get",url,true);
xmlhttp.send(null);
}
</script>
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 "
用户名
姓名
性别
年龄
手机
通信地址
邮件地址
出生日期
";
while($row = mysql_fetch_assoc($res)){
$photo = $row["photo"] ? "
echo "
{$row["username"]}
{$row["name"]}
{$row["sex"]}
{$row["age"]}
{$row["mobile"]}
{$row["address"]}
{$row["email"]}
{$row["birthday"]}
";
}
echo "";
function errormsg($str){
die("<script type="text/javascript">alert("" . $str . "");</script>");
}
?>
最简单数据库结构
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.111cn.net/down/code/php/qitayuanma/2010/1220/22331.html