本文目錄一覽：
php mysql用戶註冊
?php
if($_POST){
extract($_POST);
if(trim($username)==”){ //提交後檢測
echo ‘用戶名不能為空’;
exit();
}
if(trim(password1)!=” password1==password2){
$password = md5($password1);
}else{
echo ‘兩次輸入的密碼不一至！’;
exit();
}
mysql_query(“insert into 表 (username,password) values(‘$username’,’$password’)”);
}
?
!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “”
html xmlns=””
head
meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ /
titletest/title
/head
script type=”text/javascript”
function $(id){return document.getElementById(id).value;}
function checkForm(){ //提交前檢測
if($(‘username’)==”){
alert(‘用戶名不能為空！’);
return false;
}
if($(‘username’).length 11){
alert(‘用戶名不超過11位’);
return false;
}
if($(‘password1’)==”){
alert(‘密碼不能為空！’);
return false;
}
if($(‘password1’)!=$(‘password2’)){
alert(‘兩次輸入的密碼不一至！’);
return false;
}
return true;
}
/script
body
form id=”form1″ name=”form1″ method=”post” action=”” onsubmit=”return checkForm();”
p
用戶名：
input type=”text” name=”username” id=”username” onkeyup=”value=value.replace(/[\W]/g,”) ” onbeforepaste=”value=value.replace(/[\W]/g,”)”/
/p
p
密碼：
input type=”text” name=”password1″ id=”password1″ /
/p
p重複密碼：
input type=”text” name=”password2″ id=”password2″ /
/p
p
input type=”submit” name=”button” id=”button” value=”提交” /
/p
/form
/body
/html
PHP+MySql註冊登錄
你看一下我這個能不能明白，我也是學這個的，有時間可以一起探討一下，我QQ：772965552，問題：13796730936
先建數據庫
CREATE DATABASE yonghudenglu;
USE yonghudenglu;
CREATE TABLE yonghudenglu (
id int(10) unsigned,
name varchar(50),
xingbie varchar(50),
mima varchar(50),
);
註冊頁面：
?php
//連接數據庫
$link = mysql_connect(‘localhost’, ‘root’, ‘123456’);
//判斷連接是否成功
if (!$link)
{
die(‘Could not connect: ‘ . mysql_error());
}
//選擇數據庫
mysql_select_db(“yonghudenglu”);
//判斷姓名是否為空
if (!empty($_POST[‘name’]))
{
if (!empty($_POST[‘xingbie’]))
{
if (!empty($_POST[‘mima’]))
{
$name=($_POST[‘name’]);
$xingbie=($_POST[‘xingbie’]);
$mima=($_POST[‘mima’]);
$xinmima=($_POST[‘xinmima’]);
$query=”select name,xingbie from yonghudenglu where name=’$name’ and xingbie=’$xingbie'”;
$result=mysql_query($query);
$num_rows = mysql_num_rows($result);
if ($num_rows0)
{
echo “您輸入的用戶名已經有人註冊了，請重新輸入！”;
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您輸入的用戶名已經有人註冊,請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
else
{
if ($mima==$xinmima)
{
$sql1=”insert into yonghudenglu (name,xingbie,mima) values(‘$name’,’$xingbie’,’$mima’);”;
mysql_query($sql1);
mysql_query(“commit”);
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”恭喜您註冊成功！\”);\r\n”;
echo ” location.replace(\”10.htm\”);\r\n”; // 自己修改網址
echo “/script”;
exit;
}
else
{
#echo “您沒有輸入密碼，請重新輸入！”;
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您輸入的兩次密碼不一樣，請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
}
else
{
#echo “您沒有輸入密碼，請重新輸入！”;
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您沒有輸入密碼，請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
else
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您沒有選擇性別，請重新選擇！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
else
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您沒有輸入姓名，請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
?
登陸頁面：
?php
$link = mysql_connect(‘localhost’, ‘root’, ‘123456’);
if (!$link)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db(“yonghudenglu”);
if (!empty($_POST[‘name’]))
{
if (!empty($_POST[‘mima’]))
{
$name=($_POST[‘name’]);
$mima=($_POST[‘mima’]);
$quer=”select name,mima from yonghudenglu where name=’$name'”;
$result=mysql_query($quer);
$num_rows = mysql_num_rows($result);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
if ($num_rows0)
{
$mima1=$row[“mima”];
if ($mima==$mima1)
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”登陸成功\”);\r\n”;
echo ” location.replace(\”12.html\”);\r\n”; // 自己修改網址
echo “/script”;
exit;
}
else
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您輸入的密碼不正確！請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
else
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您還沒有註冊，請先註冊！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
else
{
#echo “您沒有輸入密碼，請重新輸入！”;
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您沒有輸入密碼，請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
}
else
{
echo “script language=\”JavaScript\”\r\n”;
echo ” alert(\”您沒有輸入姓名，請重新輸入！\”);\r\n”;
echo ” history.back();\r\n”;
echo “/script”;
exit;
}
?
不會就加我啊，哈哈
怎麼用php程序將登錄或者註冊信息寫進數據庫（mysql）？
$query=”select * from reg where username=’$username’ and pwd=’$pwd'”;
將該語句這樣寫：$query = sprintf(“select * from reg where username=%s and pwd=%s “, $username, $pwd);
php+mysql怎麼做登錄註冊
首先得到提交的數據
鏈接數據庫,查詢數據庫,查詢username 和pwd
提交的username 和 pwd 跟數據庫查詢的username 和pwd做對比,
都相等那就是登陸成功
?php
mysql_connect(‘localhost’,’root’,’123′);
mysql_select_db(‘lx’);
mysql_query(“SET CHARACTER SET utf8”);
mysql_query(“SET NAMES utf8”);
//數據庫lx 表user 字段id username pwd
//用md5加密,可以自己試試
if(isset($_POST[‘user’])$_POST[‘tijiao’] == ‘success’){
$query = mysql_query(“select pwd from user where username = ‘”.$_POST[‘user’].”‘”);
$num = mysql_num_rows($query);
if($num 0 ){
while($info = mysql_fetch_array($query)){
if($info[‘pwd’] == md5($_POST[‘pwd’])){
echo ‘登陸成功’;
}else{
echo ‘登陸失敗’;
}
}
}else{
echo ‘登陸失敗’;
}
}
?
form action=”” method=”get”/
table border=”0″ cellspacing=”0″ cellpadding=”0″
tr
td class=”fieldKey” width=”30%”用戶名:/td
td class=”fieldValue” width=”100%”input type=”text” name=”user” //td
/tr
trtd height=”10″/td/tr
tr
td class=”fieldKey”密碼:/td
td class=”fieldValue”input type=”password” name=”pwd” //td
/tr
/table
input type=”hidden” name=”tijiao” value=”success” /
input type=”submit” value=”登陸”/
/form
原創文章，作者：HKWH，如若轉載，請註明出處：https://www.506064.com/zh-hk/n/144591.html
微信掃一掃 
支付寶掃一掃 