PHP菜鸟入门之简单的登录注册

PHP菜鸟入门之简单的登录注册（增删改查）

刚入门的时候做的，很多东西还不会就做的麻烦了些，样式简洁
功能：登录注册注销。登陆成功则显示信息，登录失败则提示错误。
登录页面login.html：

please login




name:      



password:





还没有账号?点此处注册 

注册页面（有用户名的正则判断）register.php

getMessage();
}
?>
please input your message

">name:     *
password: *
 去登陆

主页面（登录之后的页面无论是否成功都跳转到这个页面）login.php

 $value) {$search_user = $value["count(uname)"];}/*数据库找到了此人*/if ($search_user == 1) {$display = true;/*欢迎*/$result_text = "welcome " . $_POST["name"] . "!!! 请选择您要进行的操作(修改/注銷)";echo "

";/*emp,score两表联查*/$sql_emp = "select e.*,s.* from emp e,score s where e.uname='" . $search_name . "' and e.uname = s.uname;";$emp = sqlQuery('test', $sql_emp);$sql_max = 'select max(math) from test.score;';$score_max = sqlQuery('test', $sql_max);$sql_min = 'select min(chinese) from test.score;';$score_min = sqlQuery('test', $sql_min);} else {/*用户不存在*/$display = false;$result_text = "please check your username and password";throw new Exception('your password or username is wrong');}
} catch (Exception $e) {echo  $e->getMessage();
}
?>


name:    " placeholder="" readonly />
password:
(修改成功会直接前往登录主页！)
  注销  回到登录页面

 $value) {$total_score = $value["chinese"] + $value["math"];$average_score = $total_score / 2;echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";}foreach ($score_max as $key => $value) {echo "数学最高分是:";echo $value["max(math)"];}foreach ($score_min as $key => $value) {echo "语文最低分是";echo $value["min(chinese)"];}}?>
name
gender
dept
math_score
chinese_score
total_score
average_score
" . $value["uname"] . "
" . $value["gender"] . "
" . $value["dept"] . "
" . $value["math"] . "
" . $value["chinese"] . "
" . $total_score . "
" . $average_score . "

删除方法：delete.php

getMessage();
}
echo "
";
echo "点击前往登录页面";
echo "
";
echo "点击前往注册页面";
?>

修改方法modify.php

getMessage();
}
?>

错误页面error.php

name:    

连接数据库方法 connection.php(我放在了db文件夹下面，注意路径)

 "set names utf8"));} catch (PDOException $e) {die("Error:" . $e->getMessage() . "
");}return $dbh;
}
function sqlQuery($udb_name, $sql)
{//初始化一个PDO对象$dbh =  dbConn($udb_name);$shou = $dbh->query($sql);return $shou;
}
function sqlExec($udb_name, $sql)
{//初始化一个PDO对象$dbh = dbConn($udb_name);$num = $dbh->exec($sql);return $num;
}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！