1.下面代码可以实现在同一页中查询功能和分页显示功能,并且该文件可以单独执行,不依赖其他文件;
你必须修改相应的数据库连接。
2.数据库中user1用户表的结构如下图所示:
3.xianshi3.php文件的源代码下所示:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form method="post" action="#" name="form1" id="form1">
<input type="text" name="chaxunname" id="chaxunname">
<input type="submit" onclick="myFunction1()" name="chaxunbutton" id="chaxunbutton" value="查询">
</form>
<?php
if((@ $_GET['page'])==""){
$page=1;
}else{
$page=intval($_GET['page']);
}
$chaxunname = $_POST['chaxunname'];
$chaxun = $_GET['chaxunname'];
if (empty($chaxunname)) {
$chaxunname = $chaxun;
}else{
$page=1;
}
//if($page==1)
//{
// $chaxunname=$_POST['chaxunname'];
//}
//else
//{
// $chaxunname=$_GET['chaxunname'];
//}
//echo $chaxunname;
//echo("<br/>");
//echo $page;
//$chaxunname="laohuang";
//设置每页最大能显示的数量
$pagesize=2;
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'rootroot';
$dbbase = 'labor';
$conn = mysqli_connect($dbhost,$dbuser,$dbpass,$dbbase);
if( mysqli_connect_errno($conn) )
{
die('Could not connect: ' . mysqli_connect_error());
}
else
{
echo("connected succeed" . "<br />");
//获取结果集的记录数
$row = mysqli_fetch_array(mysqli_query($conn, "select count(1) from user1 where username='$chaxunname'"));
$recordcount = $row[0];
echo("总共的查询页数" .$recordcount. "<br />");
//计算总页数
if ($recordcount == 0) {
$pagecount = 0;
} else
if ($recordcount < $pagesize || $recordcount == $pagesize) {
$pagecount = 1;
//如果 记录 总数 量小 于 每页 显示 的 记录 数量, 则 只有 一页
} else {
if ($recordcount % $pagesize == 0) {
$pagecount = $recordcount / $pagesize;
//如果 没有 余数, 则 页数 等于 总 记录 数量 除以 每页 显示 记录 的 数量
} else {
$pagecount = (int)($recordcount / $pagesize) + 1;
//取 记录 总数 量 不能 整除 每页 显示 记录 的 数量,
// 则 页数 等于 总 记录 数量 除以 每页 显示 记录 数量 的 结果 取整 再加 1
}
}
echo("当前页码:" . $page . "/" . $pagecount . "<br />");
}
?>
<form method="post" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>">
<table width="449" border="1">
<tr>
<td>UserId</td>
<td>UserName</td>
<td>PassWord</td>
<td>UserRole</td>
</tr>
<?php
//循环显示当前页面的记录
//echo $page;
//echo "xxxxx";
//$sql="select * from clerk limit" .($page-1)*$pagesize.",".$pagesize; //$page为当前页码
$sql=($page-1)*$pagesize;
$result=mysqli_query($conn,"select * from user1 where username='$chaxunname' limit {$sql},{$pagesize}");
while($row=mysqli_fetch_array($result))
{
$userhao = $row['userid'];
$xinming = $row['username'];
$mima = $row['password'];
$juese = $row['userrole'];
?>
<tr>
<td><input onclick="myFunction()" type="text" value="<?=$userhao?>"></td>
<td><input type="text" value="<?=$xinming?>"></td>
<td><input type="text" value="<?=$mima?>"></td>
<td><input type="text" value="<?=$juese?>"></td>
<td><input type="submit" value="修改"></td>
<td><input type="submit" value="删除"></td>
</tr>
<?php }
//mysqli_close($conn);
//显示分页链接
if($page==1){
echo("第一页");
}
else
echo("<a href=xianshi3.php?page=1"."&chaxunname=".$chaxunname.">第一页</a>");
//设置上一页连接
if($page==1){
echo("上一页");
}
else
echo("<a href=xianshi3.php?page=".($page-1)."&chaxunname=".$chaxunname.">上一页</a>");
//设置下一页链接
if($page==$pagecount){
echo("下一页");
}
else
echo("<a href=xianshi3.php?page=".($page+1)."&chaxunname=".$chaxunname.">下一页</a>");
//设置最后一页
if($page==$pagecount){
echo("最后一页");
}
else
echo("<a href=xianshi3.php?page=".$pagecount."&chaxunname=".$chaxunname.">最后一页</a>");
?>
<tr>
<td><input id="bianhaoz" name="bianhaoz" type="text" value=""></td>
<td><input id="xingmingz" name="xingmingz" type="text" value=""></td>
<td><input id="mimaz" name="mimaz" type="text" value=""></td>
<td><input id="juesez" name="juesez" type="text" value=""></td>
</tr>
<!--
<tr>
<td>
<input name="update" type="submit" id="update" value="Update">
</td>
</tr>
-->
</table>
<input name="update" type="submit" id="update" value="Update">
</form>
<script>
function myFunction()
{
var str=document.activeElement;
// console.log('oo',str.value);
var str0=str.value;
var str1=document.activeElement.parentNode.parentNode.children[1].children[0].value;
var str2=document.activeElement.parentNode.parentNode.children[2].children[0].value;
var str3=document.activeElement.parentNode.parentNode.children[3].children[0].value;
//console.log(document.activeElement.parentNode.parentNode.children[2].children[0].value);
//console.log(str2);
// console.log(str3);
document.getElementById('bianhaoz').value=str0;
document.getElementById('xingmingz').value=str1;
document.getElementById('mimaz').value=str2;
document.getElementById('juesez').value=str3;
}
</script>
<?php
//更新功能的实现
if(isset($_POST['update']))
{
$userid1 = $_POST['bianhaoz'];
echo $userid1;
// echo "nihao";
$username1 = $_POST['xingmingz'];
echo $username1;
$password1 = $_POST['mimaz'];
echo $password1;
$userrole1 = $_POST['juesez'];
echo $userrole1;
//$sql = mysql_query("UPDATE anstalld SET mandag = '$mandag',tisdag = '$tisdag',onsdag = '$onsdag',torsdag = '$torsdag',fredag = '$fredag' WHERE namn = '$namn'");
$sql = "UPDATE user1 SET username = '$username1',password='$password1',userrole = '$userrole1' WHERE userid = '$userid1'";
//$retval = mysql_query( $sql,$conn );
$retval = mysqli_query($conn,$sql);
if(! $retval )
{
die('Could not update data: ' . mysqli_error($conn));
}
echo "Updated data successfully\n";
mysqli_close($conn);
}
?>
</body>
</html>