21,894
社区成员




<?php
// 获取select值
$select_value = isset($_GET['select']) ? $_GET['select'] : '';
//echo $select_value;
//执行查询SQL
if($select_value==""){
_page("SELECT o_id FROM t_order",5);
$_result= mysql_query("SELECT * FROM t_order ORDER BY createtime DESC LIMIT $_pagenum,$_pagesize");
}
if($select_value=="option1"){
_page("SELECT o_id FROM t_order where status=0",4);
$_result1= mysql_query("SELECT * FROM t_order where status=0 ORDER BY createtime DESC LIMIT $_pagenum,$_pagesize");
//echo _num_rows($_result);
}
if($select_value=="option2"){
_page("SELECT o_id FROM t_order where status=1",20);
$_result= mysql_query("SELECT * FROM t_order where status=1 ORDER BY createtime DESC LIMIT $_pagenum,$_pagesize");
}
if($select_value=="option3"){
_page("SELECT o_id FROM t_order where status=2",20);
$_result= mysql_query("SELECT * FROM t_order where status=2 ORDER BY createtime DESC LIMIT $_pagenum,$_pagesize");
}[code=php]
<form action='order.php' style="margin-left:20px;">
<select name="select">
<option value="">全部状态</option>
<option value="option1" <?php
// 如果在上面获取的值和这个option里的值一样,
// 就打印selected,让这个option默认被选中
echo $select_value == 'option1' ? 'selected' : ''
?>>未付款</option>
<option value="option2" <?php
echo $select_value == 'option2' ? 'selected' : ''
?>>已付款待取件</option>
<option value="option3" <?php
echo $select_value == 'option3' ? 'selected' : ''
?>>已取件待送洗</option>
</select>
<input type="submit" value="查询" />
</form>
[elseif ($_type == 2) {
echo '<div id="page_text">';
echo '<ul>';
echo '<li>'.$_page.'/'.$_pageabsolute.'页 | </li>';
echo '<li>共有<strong>'.$_num.'</strong>个订单 | </li>';
if ($_page == 1) {
echo '<li>首页 | </li>';
echo '<li>上一页 | </li>';
} else {
echo '<li><a href="'.SCRIPT.'.php">首页</a> | </li>';
echo '<li><a href="'.SCRIPT.'.php?page='.($_page-1).'">上一页</a> | </li>';
}
if ($_page == $_pageabsolute) {
echo '<li>下一页 | </li>';
echo '<li>尾页</li>';
} else {
echo '<li><a href="'.SCRIPT.'.php?page='.($_page+1).'">下一页</a> | </li>';
echo '<li><a href="'.SCRIPT.'.php?page='.$_pageabsolute.'">尾页</a></li>';
}
echo '</ul>';
echo '</div>';
}
} elseif ($_type == 2) {
echo '<div id="page_text">';
echo '<ul>';
echo '<li>'.$_page.'/'.$_pageabsolute.'页 | </li>';
echo '<li>共有<strong>'.$_num.'</strong>个订单 | </li>';
if ($_page == 1) {
echo '<li>首页 | </li>';
echo '<li>上一页 | </li>';
} else {
echo '<li><a href="'.SCRIPT.'.php?select='.$select_value.'">首页</a> | </li>';
echo '<li><a href="'.SCRIPT.'.php?select='.$select_value.'&page='.($_page-1).'">上一页</a> | </li>';
}
if ($_page == $_pageabsolute) {
echo '<li>下一页 | </li>';
echo '<li>尾页</li>';
} else {
echo '<li><a href="'.SCRIPT.'.php?select='.$select_value.'&page='.($_page+1).'">下一页</a> | </li>';
echo '<li><a href="'.SCRIPT.'.php?select='.$select_value.'&page='.$_pageabsolute.'">尾页</a></li>';
}
echo '</ul>';
echo '</div>';
}