PHP查询mysql

MZZ骏马

于 2024-02-21 16:21:48 发布

阅读量393

点赞数 6

文章标签： php mysql android

本文链接：https://blog.csdn.net/qq_30754685/article/details/136214745

版权

<?php
       $link=mysqli_connect("localhost","root","123456");      //链接数据库
       mysqli_select_db($link,"realdb");                       
       mysqli_query($link,"set names 'utf8'");                   //设置字符集
       $str1 = "select count(id) as count from realdata";         //数据库查询语句
       $result1 = mysqli_query($link,$str1);           
       $row1 = mysqli_fetch_row($result1);           //将结果以数组的形式反馈给result1
       $count = $row1[0];           
       $endpage = ceil($count/18);
       if(isset($_GET['page']))
       {
       	$page = $_GET['page'];
       }
       else
       {
       	$page =1;
       }
       $str = "select * from realdata";    //查询语句在stu中进行查询
       if($page!="")
       {
       	$str .= " limit ".(($page-1)*18).",18";       //设置数据的条数
       }
       $result = mysqli_query($link,$str);
        $arr = array();
       while($row = mysqli_fetch_array($result)) {
       	$arr[]=$row;
       }
       mysqli_close($link);
?>
<!DOCTYPE html>
<html>
<head>
	<title></title>
	<script>
		function front()
		{
           var page=parseInt("<?php echo $page?>");
           if(page!=1)
           {
           	page-=1;
           }
           window.location.href="?page="+page;
		}
		function next()
		{
         var page=parseInt("<?php echo $page;?>");
         var endpage = parseInt("<?php echo $endpage;?>");
         if(page!=endpage)
         {
         	page+=1;
         }
           window.location.href="?page="+page;

		}
	</script>
	<style>
		table,td
		{
			border: 1px solid #000;
		}
	</style>
</head>
<body>
      <br>
	  <h1 align="center">                 历史数据报表</h1>
	  <br>
	  <div style="background-color:#FAF4FF;text-align: center;" >
      <table cellpadding="1" spacpadding="1" width="70%" height="98%">
          
          <tr>
          <th>编号</th>
          <th>姓名</th>
          <th>年龄</th>
          <th>专业</th>
          <th>班级</th>
		  <th>时间</th>
          </tr>
          <?php
          foreach ($arr as $key => $value)
           {
          ?>
          <tr>
          	<td style="background-color:#C4E1FF;" rowspan="1"><?php echo $value[0];?></td>
          	<td><?php echo $value[1];?></td>
          	<td style="background-color:#C4E1FF;" rowspan="1"><?php echo $value[2];?></td>
          	<td><?php echo $value[3];?></td>
          	<td style="background-color:#C4E1FF;" rowspan="1"><?php if($value[4]>4)echo "no"; else  echo $value[4];?></td>
			<td " rowspan="1" width="20%"><?php echo $value[6];?></td>
          </tr>
      <?php }?>
      </table>
      <a href="?page=1">首页</a>
      <a fontsize="20" href="javascript:;" onclick="front()">上一页</a>
      <a href="javascript:;" onclick="next()">下一页</a>
      <a href="?page=<?php echo $endpage;?>">尾页</a>
	  </div>
</body>
</html>