標籤：
1、登入
html代碼
<body><form action="dlchuli.php" method="post"><div>使用者名稱:<input type="text" name="uid"/></div><div>密碼: <input type="text" name="pwd"/></div><input type="submit" value="登入"/></form></body>
處理頁面代碼
<?phpheader("content-type:text/html;charset=utf-8");$uid=$_POST["uid"];$pwd=$_POST["pwd"];$dx=new MySQLi("localhost","root","123","nation");!mysqli_connect_error() or die("串連失敗");$sql="select pwd from nation1 where uid={$uid}";$result=$dx->query($sql);$attr=$result->fetch_row();if($attr[0]==$pwd){ header("location:zhuye.php"); }else{ echo "密碼錯誤"; }
方法二:
<?phpheader("content-type:text/html;charset=utf-8");$uid=$_POST["uid"];$pwd=$_POST["pwd"];$dx=new MySQLi("localhost","root","123","nation");!mysqli_connect_error() or die("串連失敗");$sql="select count(*) from nation1 where uid={$uid} and pwd={$pwd}";$result=$dx->query($sql);//$result是一個數組、對象$attr=$result->fetch_row();//此方法不夠安全，不使用if($attr[0]>0){ echo "返回首頁面";}else{ echo "使用者名稱密碼錯誤"; }
2、註冊
html代碼
<body><form action="zcchuli.php" method="post"><div>代號:<input type="text" name="ids"/></div><div>姓名:<input type="text" name="name"/></div><div>民族:<input type="text" name="nation"/></div><div>性別:<input type="radio" value="1" name="sex"/>男<input type="radio" value="0" name="sex"/>女</div><br /><input type="submit" value="註冊"/></form></body>
處理頁面代碼
<?phpheader("content-type:text/html;charset=utf-8");$code=$_POST["ids"];$name=$_POST["name"];$nation=$_POST["nation"];$sex=$_POST["sex"];$s=$sex==1?true:false;//擷取到的都是value值$dx=new MySQLi("localhost","root","123","nation");!mysqli_connect_error() or die("串連失敗");$sql="insert into nation values(‘$code‘,‘$name‘,‘$nation‘,‘$s‘)";$result=$dx->query($sql);if($result){ header("location:zhuce.php"); }else{ echo "註冊失敗"; }?>
php物件導向方式訪問資料庫案例-----登入和註冊
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
