PHP分页函数 自己收藏只用【上一页】123456【 下一页】

//SQL分页函数输出limit!
function genpage($sql,$page_size=20)
{
        $page = $_GET["p"];
        $eachpage = $page_size; 
		$pagesql = strstr($sql," from "); 
		$pagesql = "select count(*) as ids ".$pagesql; 
		$conn = mysql_query($pagesql) or die(mysql_error()); 
		if($rs = mysql_fetch_array($conn)) $sums = $rs[0]; 
		$pages = ceil(($sums-0.5)/$eachpage)-1; 
		$pages = $pages>=0?$pages:0; 
		$prepage = ($page>0)?$page-1:0; 
		$nextpage = ($page<$pages)?$page+1:$pages; 
		$startpos = $page*$eachpage; 
       $limit .=" $startpos,$eachpage ";
	 return $limit;
}

/** 
* 生成页码列表 
* 
* @param int $element_total_count 元素总数 
* @param int $current_page 当前页 
* @param int $per_page_elem_count 每页元素数 
* @param int $show_page_num 列表显示的页码数 
* @param string $up_down_class 上下翻页样式 
* @param string $num_class 当前页页码数字样式 
* @param string $href 页面链接 
* @param string $page_symbol 传递页码数的链接参数 
* @return string 
*/ 
function get_page_link_list($element_total_count,$current_page=1,$per_page_elem_count=10,$show_page_num=10,$up_down_class,$num_class,$href,$page_symbol='p') 
{ 
    if(empty($href)) 
    { 
        //自动取得剔除页码参数的页面链接 
        $page_name = basename($_SERVER['PHP_SELF']); 
        $params = $_SERVER['QUERY_STRING']; 
        $params_str = ''; 
        if(!empty($params)) 
        { 
            $params = str_replace('&', '&', $params); 
            $params_array = explode('&', $params); 
            foreach($params_array as $param) 
            { 
                if(!empty($param)) 
                { 
                    $index = strpos($param, '='); 
                    if($index) 
                    { 
                        $key = substr($param, 0, $index); 
                        if($key && $key != $page_symbol) 
                            $params_str .= $param . '&'; 
                    } 
                } 
            } 
        } 
        if(!empty($params_str)) 
            $href = $page_name . '?' . $params_str; 
        else 
            $href = $page_name; 
         
        $href = rtrim($href,'&'); 
    } 
     
    $prefix = strpos($href,"?") ? "&" : "?"; 
    $prefix .= $page_symbol; 
     
    $page_total_count = ceil($element_total_count/$per_page_elem_count); 
    if(intval($element_total_count)< 1 || !isset($element_total_count)) 
    { 
        return ''; 
    } 
    if($element_total_count <= $per_page_elem_count) 
        return ''; 
    if($current_page>$page_total_count) 
        $current_page = 1; 
     
    if(strpos($href,"#")) 
    { 
        $label = substr($href,strpos($href,"#")); 
        $href = substr($href,0,strpos($href,"#")); 
    } 
     
    /* 生成页码 */ 
    if($current_page > ceil($show_page_num/2)) 
    { 
        $start = $current_page - ceil($show_page_num/2); 
        $end = (($current_page+ceil($show_page_num/2))<$page_total_count) ? 
            $current_page+ceil($show_page_num/2)-1 : $page_total_count; 
    } 
    else 
    { 
        $start = 1; 
        $end = ($show_page_num>$page_total_count) ? $page_total_count : $show_page_num; 
    } 
    if(!empty($num_class)) 
        $num_class_str = ' class="'.$num_class.'"'; 
    else 
        $num_class_str = ''; 
    $page_num_string = ''; 
     
    for($i=$start;$i<=$end;$i++) 
    { 
        if(intval($i) == intval($current_page)) 
            $page_num_string .= '<a'.$num_class_str.'>'.$i.'</a>'; 
        else 
            $page_num_string .= '<a href="'.$href.$prefix.'='.$i.$label.'">'.$i.'</a>'; 
    } 
     
    /* 上下翻页 */ 
    $prev_page = (intval($current_page-1)>0)?intval($current_page-1):0; 
    $next_page = (intval($current_page)<$page_total_count) ? intval($current_page+1) : 0; 
    if(!empty($up_down_class)) 
        $up_down_class_str = ' class="'.$up_down_class.'"'; 
    else 
        $up_down_class_str = ''; 
     
    $page_up_string = ''; 
     
    if(intval($prev_page) > 0) 
        $page_up_string = '<a href="'.$href.$prefix.'='.$prev_page.$label.'"'.$up_down_class_str.'>上一页</a>'; 
    else 
        $page_up_string = '<a'.$up_down_class_str.'>上一页</a>'; 
    $page_down_string = ''; 
     
    if(intval($next_page) > 0) 
        $page_down_string .= '<a href="'.$href.$prefix.'='.$next_page.$label.'"'.$up_down_class_str.'>下一页</a>'; 
    else 
        $page_down_string .= '<a'.$up_down_class_str.'>下一页</a>'; 
    /* 返回结果 */ 
    return $page_up_string . $page_num_string . $page_down_string; 
}

<?php include_once("function.php"); if($_POST[tj]) { $username=$_POST[username]; $identity=$_POST[user_number]; $phone=$_POST[user_tel]; $address=$_POST[address]; $carid=$_POST[car_number]; $cardescribe=$_POST[car_content]; $carluxian=$_POST[car_road]; car($username,$identity,$phone,$address,$carid,$cardescribe,$carluxian); echo "<script>alert('添加成功');</script>"; } if($_POST[update]) { $cid =$_POST[carid]; $username=$_POST[username]; $identity=$_POST[user_number]; $phone=$_POST[user_tel]; $address=$_POST[address]; $carid=$_POST[car_number]; $cardescribe=$_POST[car_content]; $carluxian=$_POST[car_road]; updatecar($username,$identity,$phone,$address,$carid,$cardescribe,$carluxian); echo "<script>alert('修改成功')</script>"; } if($_POST[delete]) { $cid=$_POST[car_number]; deletecar($cid); echo "<script>alert('删除成功')</script>"; } $result=selectcarid(); $yih=null; if($_POST[f]){ $cid1=$_POST[select1]; $yih=getCar($cid1); } ?> <html> <head><title>物流配送信息网</title> <script> function selectCar(){ document.getElementById('f').value="1"; document.forms[0].submit(); } function ck() { document.getElementById('cid').value="id"; } function bk() { document.getElementById('cid').value="pp"; } </script> </head> <body> <form method="POST"> <input type="hidden" name="f"> <table border="1" width="500px" height="20px"> <tr> <td align="center" colspan="2">车源信息管理: <select name="select1" onchange="selectCar()"> <option selected="selected">请选择</option> <?php while ($row=mysql_fetch_array($result,MYSQL_BOTH)) { ?> <option value="<?php echo $row[carid] ?>"><?php echo $row[carid] ?></option> <?php } ?> </select> </td> </tr> </table> <table width="685" border="1" cellpadding="1" cellspacing="1" bgcolor="#99FFCC"> <tr> <td width="80" height="26" align="center">姓名:</td> <td width="218"><input type="text" name="username" value="<?php echo $yih[username]?>" /></td> <td width="83" height="22" align="center">车牌号码:</td> <td width="281"><input name="car_number" type="text" value="<?php echo $yih[carid]?>" /></td> </tr> <tr> <td height="22" align="center">身份证号:</td> <td><input name="user_number" type="text" value="<?php echo $yih[identity]?>"/></td> <td rowspan="2" align="center">车辆描述:</td> <td rowspan="2" ><textarea name="car_content" cols="30" rows="5"><?php echo $yih[cardescribe]?></textarea></td> </tr> <tr> <td height="22" align="center">电话:</td> <td><input name="user_tel" type="text" value="<?php echo $yih[phone]?>"/></td> </tr> <tr> <td height="22" align="center">地址:</td> <td ><textarea name="address" id="address"><?php echo $yih[address]?></textarea></td> <td align="center">运输路线:</td> <td ><textarea name="car_road" cols="30" rows="5" id="car_road"><?php echo $yih[carluxian]?></textarea></td> </tr> <tr> <td> </td> <td align="right"><input type="submit" name="tj" value="提交" /></td> <td align="center"><input type="submit" name="update" value="修改" onclick="ck(<?php echo $yih[carid]?>)"></td> <td><input type="submit" name="delete" value="删除" onclick="bk(<?php echo $yih[carid]?>)"></td> </tr> </table> <input type="hidden" name="cid" value=""/> </form> </body> </html>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值