利用PHP實現登錄與註冊功能以及使用PHP讀取mysql資料庫——以表格形式顯示數據
登錄界面
<body>
<form action=”login1.php” method=”post”>
<div>用戶名:<input type=”text” name=”uid” /></div><br />
<div>密碼:<input type=”password” name=”pwd” /></div><br />
<div><input type=”submit” value=”登錄”/></div>
</form>
</body>
後台登錄處理
<?php
$uid = $_POST[“uid”];
$pwd = $_POST[“pwd”];
$db = new MySQLi(“localhost”,”root”,””,”0710_info”);
if(mysqli_connect_error()){
die(“連接失敗”);
}
$sql = “select pwd from users where uid='{$uid}'”;
//echo $sql;
$result = $db->query($sql);
$arr = $result->fetch_row();
//防止sql注入攻擊
if($arr[0]==$pwd && !empty($pwd)){
//跳轉到主界面(php方式)
header(“location:register_system.php”);
//JS跳轉頁面方式
/*echo “<script>
window.location.href=’register_system.php’
</script>”;*/
}else{
header(“location:login_system.php”);
}
?>
註冊界面
<body>
<form action=”register1.php” method=”post” >
<div style=”font-size:20px; font-weight:1000; font-family:微軟雅黑; margin-left:50px; margin-bottom:20px”>用戶註冊</div>
<div>用戶名:<input type=”text” name=”uid” /></div><br />
<div>登錄密碼:<input type=”password” name=”pwd” /></div><br />
<div>姓名:<input type=”text” name=”name” /></div><br />
<div>性別:
<input type=”radio” name=”sex” value=”1″ />男
<input type=”radio” name=”sex” value=”0″ />女
</div><br />
<div><input type=”submit” value=”註冊” onclick=”return check()”/></div>
</form>
</body>
JS表單驗證
<script>
function check(){
var uid = document.getElementsByTagName(“input”)[0].value;
if(uid == “”){
alert(“請輸入用戶名!”);
return false;
}
var pwd = document.getElementsByTagName(“input”)[1].value;
if(pwd == “”){
alert(“請輸入密碼!”);
return false;
}
var name = document.getElementsByTagName(“input”)[2].value;
if(name == “”){
alert(“請輸入姓名!”);
return false;
}
}
</script>
後台註冊處理
<?php
$uid = $_POST[“uid”];
$pwd = $_POST[“pwd”];
$name = $_POST[“name”];
$sex = $_POST[“sex”];
$db = new MySQLi(“localhost”,”root”,””,”0710_info”);
if(mysqli_connect_error()){
die(“連接失敗”);
}
$sql = “insert into users values(‘{$uid}’,'{$pwd}’,'{$name}’,{$sex})”;
$r = $db->query($sql);
if($r){
echo “註冊成功!”;
}else{
echo “註冊失敗！”;
}
?>
PHP讀取mysql資料庫——以表格形式顯示數據
<body>
<table width=”50%” border=”1″>
<tr>
<td>代號</td>
<td>姓名</td>
<td>性別</td>
<td>生日</td>
<td>民族</td>
</tr>
<?php
$db = new MySQLi(“localhost”,”root”,””,”0710_info”);
$sql = “select info.code,info.name,sex,birthday,nation.name from info join nation on info.nation=nation.code”;//聯合查詢
$result = $db->query($sql);
$arr = $result->fetch_all();
//var_dump($arr);
//利用foreach循環遍歷所有數據
foreach($arr as $v){
$sex = $v[2]?’男’:’女’;//利用三元運算符判斷性別
echo “<tr>
<td>{$v[0]}</td>
<td>{$v[1]}</td>
<td>{$sex}</td>
<td>{$v[3]}</td>
<td>{$v[4]}</td>
</tr>”;
}
?>
</table>
</body>
原創文章，作者：投稿專員，如若轉載，請註明出處：https://www.506064.com/zh-tw/n/259135.html
微信掃一掃 
支付寶掃一掃 
