1.创建一个数据库连接
// 建立数据库连接
$conn = mysqli_connect ( "localhost", "root", "密码", "db_meeting" ) or die ( "连接数据库失败" );
if (! $conn) {
echo "连接失败";
} else {
echo "连接成功";
}
$query = "select userName,userPassword from tb_meeting_user";
$result = mysqli_query ( $conn, $query );
for($i = 0; $i < mysqli_num_rows ( $result ); $i ++) {
$data = mysqli_fetch_object ( $result );
echo $data->userName . '--' . $data->userPassword . '<br/>';
}
2.判断是否已经登录,以此为依据导入不同的页面
session_start ();
// 如果session里有用户名和id及登录权限,则进入管理页面,没有则进入登录页面
if (isset ( $_SESSION ['name'] ) && isset ( $_SESSION ['id'] ) && isset ( $_SESSION ['rights'] )) {
echo "<meta http-equiv=\"refresh\" content=\"0;url=manage.php\" />"; // 通过0秒刷新指定页面
} else {
echo "<meta http-equiv=\"refresh\" content=\"0;url=login.php\" />";
}
?>
跳转页面可以使用
if ($id=='100' && $password=='admin') {
//echo '合法用户';
header("Location:empManage.php");
}else{
//echo '非法用户';
header("Location:index.php");
}
一例访问数据库验证用户名密码案例
$id=$_POST['id'];
$password=$_POST['passsword'];
$conn=mysqli_connect('localhost','root','密码','db_human') or die('连接失败');
if ($conn){
echo '连接成功';
}else{
echo '连接失败'.mysqli_errno($conn);
}
$query="select id, password from tb_admin where id=$id";
$res=mysqli_query($conn, $query);
if ($row=mysqli_fetch_assoc($res)){
if ($row['password']==md5($password)) {
$name=$row['id'];
header("Location:empManage.php?name=$name");
//echo "<b>当前用户为".$row['id']."</b>";
}
}else{
echo '无返回结果';
header("Location:index.php");
}
mysqli_free_result($res);
mysqli_close($conn);
3.一个数据库查询后的分页功能
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>用户信息</title>
<style type="text/css">
.mytable{ border-collapse: collapse; width: 600px; margin:auto;}
td,th{padding:5px; border:1px solid gray;}
.pages{margin:25px auto; height:5px; width:100%; text-align:center}
</style>
</head>
<body>
<?php
//分页要用到的几个变量
$pageNow=1;
$rowCount=0;
$pageSize=3;
$pageCount=0;
//需要根据用户的点击来修改$pageNow的值
if (!empty($_GET['pageNow'])){
$pageNow=$_GET['pageNow'];
}
$conn=mysqli_connect('localhost','root','hujian790402','db_human') or die('连接失败');
//数据库记录数
/*
$queryDataCount="select count('id') from tb_emp";
$resultDataCount=mysqli_query($conn, $queryDataCount);
$rowCount=mysqli_num_rows($resultDataCount);
if ($row=mysqli_fetch_row($resultDataCount) ) {
$rowCount=$row[0];
}
echo $rowCount."<br/>";
*/
$queryDataCount="select * from tb_emp";
$resultDataCount=mysqli_query($conn, $queryDataCount);
$rowCount=mysqli_num_rows($resultDataCount);
//计算有多少页
$pageCount=ceil($rowCount/$pageSize);
$query="select * from tb_emp limit ". ($pageNow-1)*$pageSize.",".$pageSize."";
$res=mysqli_query($conn, $query);
echo "<table width='700' border='1' class='mytable'>";
echo "<tr><th>id</th><th>name</th><th>grade</th><th>email</th><th>salary</th><th>删除用户</th><th>修改用户</th>";
while ($row=mysqli_fetch_assoc($res)) {
//大括号在框架模板中表示引用变量
echo "<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['grade']}</td><td>{$row['email']}</td><td>{$row['salary']}</td><td><a href=#>删除用户</a></td><td><a href=#>修改用户</a></td></tr>";
}
echo "</table>";
echo "<div class='pages'>";
$nextPage=$prePage=0;
//打印出页码的超级连接
if ($pageNow>1) {
$nextPage=$pageNow-1;
echo "<a href='emplist.php?pageNow=$nextPage'>上一页</a> ";
}
for ($i = 1; $i <= $pageCount; $i++) {
echo "<a href='emplist.php?pageNow=$i'>$i</a> ";
}
if ($pageNow<$pageCount) {
$prePage=$pageNow+1;
echo "<a href='emplist.php?pageNow=$nextPage'>下一页</a> ";
}
//显示总页面
echo " 当前 {$pageNow} / {$pageCount} 页";
//指定跳转到某页
echo "<form action='emplist.php' >";
echo "跳转至:<input type='text' size='20' name='pageNow'/>";
echo "<input type='submit' value='跳转'/>";
echo "</form>";
echo "</div>";
mysqli_free_result($res);
mysqli_close($conn);
?>
</body>
</html>
结果:
4.雇员管理系统
请直接访问附件,不过不对外公开
点击下载