<!doctype html><html><head><meta charset="utf-8"><title>登錄、注冊(cè)</title></head><body><form action="" method="post"> <table width="355" border="3" align="center"> <tr> <td align="center" height="30">學(xué)生登記表</td> </tr> <tr> <td align="center">姓名：<input type="text" name="user_name"></td> </tr> <tr> <td align="center">學(xué)號(hào)：<input type="text" name="user_id"></td> </tr> <tr> <td align="center">電話：<input type="text" name="user_phone"></td> </tr> <tr> <td align="center">地址：<input type="text" name="user_address"></td> </tr> <tr> <td align="center"><input type="submit" name="submit" value="提交"></td> </tr> <tr> <td> <a href="mysql_row.php" target="_blank">查看數(shù)據(jù)庫(kù)</a> </td> </tr> </table></form> <?phpif(isset($_POST['submit'])){ $errot=array(); if(empty($_POST['user_id'])){ $errot[]='學(xué)號(hào)不能為空'; }else{ $user_id=$_POST['user_id']; } if(empty($_POST['user_name'])){ $errot[]='名字不能為空'; }else{ $user_name=$_POST['user_name']; } if(empty($_POST['user_phone'])){ $errot[]='電話不能為空'; }else{ $user_phone=$_POST['user_phone']; } if(empty($_POST['user_address'])){ $errot[]='名字不能為空'; }else{ $user_address=$_POST['user_address']; } if(empty($errot)){ header('Content-Type:text/html;charset=utf-8'); //數(shù)據(jù)庫(kù)的服務(wù)器類(lèi)型是mysql $dbms='mysql'; //數(shù)據(jù)庫(kù)服務(wù)器主機(jī)名、端口號(hào)、選擇的數(shù)據(jù)庫(kù) $host='localhost'; $port='3306'; $dbname='book'; //用戶(hù)名和密碼 $user='root'; $pwd=null; $dsn="$dbms:host=$host;port=$port;dbname=$dbname"; $options=array(PDO::MYSQL_ATTR_INIT_COMMAND=>"set names utf8"); try{ //實(shí)例化PDO創(chuàng)建數(shù)據(jù)庫(kù)服務(wù)器連接 $pdo=new PDO($dsn,$user,$pwd,$options); $sql1='select * from user where id='.$user_id; //判斷重復(fù)數(shù)據(jù) $rs=$pdo->query($sql1); var_dump($rs); if($rs){ die('此數(shù)據(jù)重復(fù)提交'); }else{ //if(isset($_post['tijao'])){ //執(zhí)行SQL語(yǔ)句 $sql="insert into user values(null,:name,:id,:phone,:address)"; //生成預(yù)處理語(yǔ) $stmt=$pdo->prepare($sql); // $name=$_POST['user_name']; // $id=$_POST['user_id']; // $phone=$_POST['user_phone']; // $address=$_POST['user_address']; $stmt->bindParam(":name",$user_name); $stmt->bindParam(":id",$user_id); $stmt->bindParam(":phone",$user_phone); $stmt->bindParam(":address",$user_address); if($stmt->execute()){ echo "成功.."; }else{ echo "失敗"; } } }catch(PDOExcption $e){ echo $e->getMessage().'<br>'; } }else{ var_dump($errot); die("未填完！"); } }?><br/><br/></body></html>
1 回答
hallo_monde
TA貢獻(xiàn)3條經(jīng)驗(yàn) 獲得超1個(gè)贊
這個(gè)一般不存在問(wèn)題吧? 賬號(hào) 一般在數(shù)據(jù)庫(kù)中 不是都是設(shè)置成unique 唯一的嗎? 就算你沒(méi)有設(shè)置 直接一個(gè)sql語(yǔ)句? select name from 表名 where name = 傳過(guò)來(lái)的值? 如果這條sql語(yǔ)句返回真不就是存在該用戶(hù)了嗎
-
小楊的樣返回的一直是假
- 1 回答
- 1 關(guān)注
- 1546 瀏覽
添加回答
舉報(bào)
0/150
提交
取消