个人中心
文章发布
退出
作者热门文章
- html - 出于某种原因，IE8 对我的 Sass 文件中继承的 html5 CSS 不友好？
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景？
25
4
当我尝试在分页页面上的两个日期之间搜索时，结果出现在第一页上，而当按“下一步”时，则不显示任何内容
请找到代码并尝试提供帮助，注意:我用谷歌搜索，但只是通过名称搜索找到分页
<script>
src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script>
$(document).ready(function() {
$("tr:odd").addClass("odd");
});
</script><style type="text/css">
.odd{
background-color:#ccc;
}
@charset "utf-8";
div.pagination {
padding: 3px;
margin: 3px;
}
div.pagination a {
padding: 2px 5px 2px 5px;
margin: 2px;
border: 1px solid #AAAADD;
text-decoration: none; /* no underline */
color: #000099;
}
div.pagination a:hover, div.pagination a:active {
border: 1px solid #000099;
color: #000;
}
div.pagination span.current {
padding: 2px 5px 2px 5px;
margin: 2px;
border: 1px solid #000099;
font-weight: bold;
background-color: #000099;
color: #FFF;
}
div.pagination span.disabled {
padding: 2px 5px 2px 5px;
margin: 2px;
border: 1px solid #EEE;
color: #DDD;
}
</style><head>
<meta charset="utf-8">
<title>Untitled Document</title>
</head>
<body>
<form action="topics1.php" method="post">
<input type="date" name="date"/>
<input type="date" name="date1"/>
<input type="submit" value="search"/>
</form>
<br/>
<?php
/*
date SQL isset
*/
$date1 = isset ($_POST['date']) ? $_POST['date'] : "";
$date2 = isset ($_POST['date1']) ? $_POST['date1'] : "";
/*
Place code to connect to your DB here.
*/
$connect=mysqli_connect('localhost','root','123456','liwa');
mysqli_set_charset($connect,'utf8mb4');
// include your code to connect to DB.
$tbl_name="sat"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name ";
$total_pages = mysqli_fetch_array(mysqli_query($connect,$query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = "topics1.php"; //your file name (the name of this file)
$limit = 3; //how many items to show per page
$page =isset ($_GET['page']) ? $_GET['page'] : "";
if($page)
$start = ($page - 1) * $limit;//2-1*10 page 2 //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0
/* Get data. */
$sql = "SELECT * FROM sat
WHERE date BETWEEN '$date1' AND '$date2'
LIMIT $start, $limit ";
$result = mysqli_query($connect,$sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev\"><< previous</a>";
else
$pagination.= "<span class=\"disabled\"><< previous</span>";
//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next\">next >></a>";
else
$pagination.= "<span class=\"disabled\">next >></span>";
$pagination.= "</div>\n";
}
//this is the loop
?>
<?php
echo "<table border='1' width='50%' cellpadding='0' cellspacing='0'>";
while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){
echo"<tr>";
echo"<td>";
echo $row['Suggestions'];
echo"</td>";
echo"<td>";
echo $row['date'];
echo"</td>";
echo"</tr>";
}
echo "</table>";
?>
<?=$pagination?>
</body>
</html>最佳答案
我找到了问题的解决方案，无论如何还是谢谢
<body>
<?php
ini_set('display_errors', 1);
error_reporting(~0);
$date1 = null;
if(isset($_POST["date1"]))
{
$date1 = $_POST["date1"];
}
if(isset($_GET["date1"]))
{
$date1 = $_GET["date1"];
}
$date2 = null;
if(isset($_POST["date2"]))
{
$date2 = $_POST["date2"];
}
if(isset($_GET["date2"]))
{
$date2 = $_GET["date2"];
}
?>
<form name="frmSearch" method="post" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
<table width="599" border="1">
<tr>
<th>Keyword
<input name="date1" type="date" id="txtKeyword" value="<?php echo $date1;?>">
<input name="date2" type="date" id="txtKeyword" value="<?php echo $date2;?>">
<input type="submit" value="Search">
<br/>
<?php
/*
date SQL isset
*/
/*
Place code to connect to your DB here.
*/
$connect=mysqli_connect('localhost','root','123456','liwa');
mysqli_set_charset($connect,'utf8mb4');
// include your code to connect to DB.
$tbl_name="sat"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;
/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name ";
$total_pages = mysqli_fetch_array(mysqli_query($connect,$query));
$total_pages = $total_pages['num'];
/* Setup vars for query. */
$targetpage = "topics1.php"; //your file name (the name of this file)
$limit = 3; //how many items to show per page
$page =isset ($_GET['page']) ? $_GET['page'] : "";
if($page)
$start = ($page - 1) * $limit;//2-1*10 page 2 //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0
/* Get data. */
$sql = "SELECT * FROM sat
WHERE date BETWEEN '$date1' AND '$date2'
LIMIT $start, $limit ";
$result = mysqli_query($connect,$sql);
/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1
/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$prev&date1=$date1&date2=$date2\"><< previous</a>";
else
$pagination.= "<span class=\"disabled\"><< previous</span>";
//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$counter&date1=$date1&date2=$date2\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$counter&date1=$date1&date2=$date2\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$lpm1&date1=$date1&date2=$date2\">$lpm1</a>";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$lastpage&date1=$date1&date2=$date2\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=1&date1=$date1&date2=$date2\">1</a>";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=2&date1=$date1&date2=$date2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$counter&date1=$date1&date2=$date2\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$lpm1&date1=$date1&date2=$date2\">$lpm1</a>";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$lastpage&date1=$date1&date2=$date2\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=1&date1=$date1&date2=$date2\">1</a>";
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=2&date1=$date1&date2=$date2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$counter&date1=$date1&date2=$date2\">$counter</a>";
}
}
}
//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$_SERVER[SCRIPT_NAME]?page=$next&date1=$date1&date2=$date2\">next >></a>";
else
$pagination.= "<span class=\"disabled\">next >></span>";
$pagination.= "</div>\n";
}
//this is the loop
?>
<?php
echo "<table border='1' width='50%' cellpadding='0' cellspacing='0'>";
while ($row=mysqli_fetch_array($result,MYSQLI_ASSOC)){
echo"<tr>";
echo"<td>";
echo $row['Suggestions'];
echo"</td>";
echo"<td>";
echo $row['date'];
echo"</td>";
echo"</tr>";
}
echo "</table>";
?>
<?=$pagination?>
</body>关于php mysql 分页和两个日期之间的搜索，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/39425018/
25
4
0
我在 JavaScript 文件中运行 PHP，例如...... var = '';). 我需要使用 JavaScript 来扫描字符串中的 PHP 定界符(打开和关闭 PHP 的 )。 我已经知道使
我希望能够做这样的事情: php --determine-oldest-supported-php-version test.php 并得到这个输出: 7.2 也就是说，php 二进制检查 test.
我正在开发一个目前不使用任何框架的大型 php 站点。我的大问题是，随着时间的推移慢慢尝试将框架融入应用程序是否可取，例如在创建的新部件和更新的旧部件中？ 比如所有的页面都是直接通过url服务的，有几
下面是我的源代码，我想在同一页面顶部的另一个 php 脚本中使用位于底部 php 脚本的变量 $r1。我需要一个简单的解决方案来解决这个问题。我想在代码中存在的更新查询中使用该变量。 $name)
我正在制作一个网站，根据不同的情况进行大量 PHP 重定向。就像这样...... header("Location: somesite.com/redirectedpage.php"); 为了安全起见
我有一个旧网站，我的 php 标签从 因为短标签已经显示出安全问题，并且在未来的版本中将不被支持。 关于php - 如何避免在 php 文件中写入
我有一个用 PHP 编写的配置文件，如下所示， 所以我想用PHP开发一个接口(interface)，它可以编辑文件值，如$WEBPATH , $ACCOUNTPATH和 const值(value)观
我试图制作一个登录页面来学习基本的PHP，首先我希望我的独立PHP文件存储HTML文件的输入(带有表单)，但是当我按下按钮时(触发POST到PHP脚本) )我一直收到令人不愉快的错误。 我已经搜索了S
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
这个问题已经有答案了: 已关闭11 年前。 Possible Duplicate: What is the max key size for an array in PHP? 正如标题所说，我想知道
我正在寻找一种让 PHP 以一种形式打印任意数组的方法，我可以将该数组作为赋值包含在我的(测试)代码中。 print_r 产生例如: Array ( [0] => qsr-part:1285 [1]
关闭。这个问题需要多问focused 。目前不接受答案。 想要改进此问题吗？更新问题，使其仅关注一个问题 editing this post . 已关闭 9 年前。 Improve this ques
我在 MySQL 数据库中有一个表，其中存储餐厅在每个工作日和时段提供的菜单。 表结构如下: i_type i_name i_cost i_day i_start i_
我有两页。 test1.php 和 test2.php。 我想做的就是在 test1.php 上点击提交，并将 test2.php 显示在 div 中。这实际上工作正常，但我需要向 test2.php
我得到了这个代码。我想通过textarea更新mysql。我在textarea中回显我的MySQL，但我不知道如何更新它，我应该把所有东西都放进去吗，因为_GET模式没有给我任何东西，我也尝试_GET
首先，我是 php 的新手，所以我仍在努力学习。我在 Wordpress 上创建了一个表单，我想将值插入一个表(data_test 表，我已经管理了)，然后从 data_test 表中获取所有列(id
我有以下函数可以清理用户或网址的输入: function SanitizeString($var) { $var=stripslashes($var); $va
我有一个 html 页面，它使用 php 文件查询数据库，然后让用户登录，否则拒绝访问。我遇到的问题是它只是重定向到 php 文件的 url，并且从不对发生的事情提供反馈。这是我第一次使用 html、
我有一个页面充满了指向 pdf 的链接，我想跟踪哪些链接被单击。我以为我可以做如下的事情，但遇到了问题: query($sql); if($result){
我正在使用 从外部文本文件加载 HTML/PHP 代码 $f = fopen($filename, "r"); while ($line = fgets($f, 4096)) { print $l
我是一名优秀的程序员,十分优秀！