如何对两个select语句进行分页
How do pagination for two select statement together?
php查询后:
<?php
$today = date('D, d M, Y');
$sql = "SELECT * FROM table WHERE date = '$today'";
if($_POST!=""){
$mydate = mysql_real_escape_string($_POST['datepicker']);
if($mydate!=""){
$sql = "SELECT * FROM table WHERE date = '$mydate'";
}
}
$num_results_per_page = 8;
$num_page_links_per_page = 5;
$pg_param = "";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);
pagination($sql, $num_results_per_page, $num_page_links_per_page, $pg_param);
if($pg_error == '')
{
if(mysql_num_rows($pg_result) > 0)
{
while($data = mysql_fetch_assoc($pg_result))
{
echo "
.......................
.......................
.......................
";
}
echo "</br>". $pagination_output;
}
else
{
echo "No Data.";
}
}
else
{
echo $pg_error;
}
?>
Pagination.php
<?php
$pg_error = '';
$pg_result = '';
$pagination_output = '';
$max_pages = '';
$page_id = '';
$page_numbers_per_page = '';
$pg_user_param = '';
function pagination($sql, $num_results_per_page, $num_page_links_per_page, $pg_param)
{
global $pg_error, $pg_result, $max_pages, $page_id, $page_numbers_per_page, $pg_user_param;
$user_sql = $sql;
$page_numbers_per_page = $num_page_links_per_page;
$results_per_page = $num_results_per_page;
$pg_user_param = $pg_param;
$all_results = mysql_query($user_sql);
if($all_results)
{
if(empty($all_results))
{
$total_results = 0;
}
else
{
$total_results = mysql_num_rows($all_results);
}
$max_pages = ceil($total_results / $results_per_page);
if(isset($_GET['page_id']))
{
$page_id = (int) $_GET['page_id'];
if($page_id > $max_pages || empty($page_id))
{
$page_id = 1;
}
}
else
{
$page_id = 1;
}
$page_id_temp = ($page_id - 1) * $results_per_page;
$sql_offset = $page_id_temp;
$user_sql .= " limit $sql_offset, $results_per_page";
$pg_result = mysql_query($user_sql);
Create_Links();
}
else
{
$pg_error = 'Error with the sql query you entered: '.mysql_error();
}
}
?>
对于第一个查询分页工作正常($today select)。但是对于第二个($mydate select)不能正常工作。还是$today select。任何想法?
您可以执行UNION将SQL语句组合成一个结果集,并在该结果集上使用分页。
http://dev.mysql.com/doc/refman/5.0/en/union.html$today = date('D, d M, Y');
$sql = "SELECT * FROM table WHERE date = '$today'";
if($_POST!=""){
$mydate = mysql_real_escape_string($_POST['datepicker']);
if($mydate!=""){
$sql = "SELECT * FROM table WHERE date = '$mydate'";
可以:$today = date('D, d M, Y');
if($_POST!=""){
$mydate = mysql_real_escape_string($_POST['datepicker']);
if($mydate!=""){
$sql = "SELECT * FROM table WHERE date = '$mydate' UNION SELECT * FROM table WHERE date = '$today'";
相关文章:
- SELECT FROM WHERE语句在使用变量时不起作用…
- 使用SQLite FTS3,如何连接或嵌套SELECT语句以获得行加代码段
- 动态生成 jQuery select 语句
- .post javascript with PHP 以启用 select 语句返回
- 从 select 中获取 ID,并在 if 语句中使用它们
- 在 Ruby on Rails 中使用带有 If 语句的 Select Option 表单
- 如何对返回数据列表的清除Select语句进行编码
- 使用php的动态变量从sql select和update语句的下拉列表中获取
- 使用JavaScript填充HTML select语句
- 定义函数并在select语句中用作onchange,而不是直接使用.change(function)
- 如何在select表单中使用if-else语句
- 使用select语句进行动态图像交换
- Prototype - select语句对某些元素不起作用
- 从select html标签中选择的值在javascript if/else语句中没有产生正确的结果
- HTML5SQL使用SELECT语句从web数据库检索记录
- 如何在HTML中使用if语句(JavaScript)和select标记
- 从javascript while循环中创建一个select语句
- 从输入字段获取变量值,并在SELECT-WHERE语句中使用它
- 如何对两个select语句进行分页
- 如何设置select语句的值