利用PHP实现登录与注册功能以及使用PHP读取mysql数据库——以表格形式显示数据

登录界面

后台登录处理

<?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 “”;*/

}else{

header(“location:login_system.php”);

}

?>

注册界面

JS表单验证

后台注册处理

<?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数据库——以表格形式显示数据

<?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 “

}

?>