示例#1
0
    $tempquery = " where " . substr($condistion, 4);
}
$start = $p->findStart($limit);
$querycount = "select cd_id from tblcd " . $tempquery;
$count = mysql_num_rows(mysql_query($querycount));
$pages = $p->findPages($count, $limit);
if (isset($_GET['nav']) and is_numeric($_GET['nav'])) {
    $paging = "LIMIT " . $start . "," . $limit . " ";
} else {
    $paging = "LIMIT 0," . $limit . " ";
}
$orderby = "ORDER BY cd_id DESC";
$products = $prod->getListProduct($orderby, $condistion, $paging);
//echo mysql_error();
//echo $condistion;
$page_list = $p->pageList(sqlInjection($_GET['nav']), $pages);
?>
<style type="text/css">
ul.paging li a {
    background-color: #F8F8F8;
    border: 1px solid #E6E6E6;
    border-radius: 2px 2px 2px 2px;
    color: #666666;
    padding: 2px 6px;
	outline: medium none;
    text-decoration: none;
}
ul.paging li a:active {
    color: #0000CC;
}
ul.paging li a:hover, ul.paging li a.paging-active {
示例#2
0
        echo "<td colspan='4' style='background-image:url(../images/danhmuc.png)' height='30'><p style='color:#FFF; font-weight:bold;  text-align:center' >Sách {$so['0']} ({$so['1']} sách)  </p></td>";
        echo "</tr>";
        $stt = 0;
        while ($row = mysqli_fetch_row($result)) {
            if ($stt % 4 == 0) {
                echo "<tr>";
            }
            echo "<td valign='top'>";
            echo "<table align='center'>";
            echo "<tr><td align='center'><p style='font-weight:bold '><a href='list_sach.php?mas={$row['0']}'><b>{$row['1']}</b></a></td></tr>";
            echo "<tr><td align='center'><img width='140' height='140' src='../data/" . $row[7] . "'></td></tr>";
            echo "<tr><td align='center'>{$row['3']}.000 VND<a href=addcart.php?item={$row['0']}><img src='../images/dathang.gif' alt='đặt hàng' width='20' height='16' align='right' ></a></td></tr>";
            echo "</table>";
            echo "</td>";
            $stt++;
            if ($stt % 4 == 0) {
                echo "</tr>";
            }
        }
        echo "</table>";
        $pagelist = $p->pageList($_GET['page'], $pages);
        echo "<table align:'center' width='100%'>";
        echo "<p align:'center'>";
        echo "<td colspan='4' style='background-image:url(../images/danhmuc.png)' height='30'><p style='color:#FFF; font-weight:bold;  text-align:center' >";
        echo "Trang: {$pagelist} ";
        echo "</p>";
        echo "</table>";
    } else {
        echo "Không có sách!";
    }
}
示例#3
0
function getListVoucher()
{
    $p = new Pager();
    /* Show many results per page? */
    $limit = 100;
    /* Find the start depending on $_GET['page'] (declared if it's null) */
    $start = $p->findStart($limit);
    /* Find the number of rows returned from a query; Note: Do NOT use a LIMIT clause in this query */
    $count = mysql_num_rows(mysql_query("SELECT * FROM wp_voucher_post"));
    /* Find the number of pages based on $count and $limit */
    $pages = $p->findPages($count, $limit);
    /* Now we use the LIMIT clause to grab a range of rows */
    $result = mysql_query("SELECT * FROM wp_voucher_post LIMIT " . $start . ", " . $limit);
    /* Now get the page list and echo it */
    $pagelist = $p->pageList($_GET['page'], $pages);
    echo $pagelist;
}