Exemple #1
0
               </div>    
               <?php 
     $i++;
     $dem++;
 }
 if ($dem == 0) {
     printf('<div id="phantrang" style="color:#00F; font-size:30px; font-weight:bold">Không tìm thấy sản phẩm bạn đang tìm.</div>');
 }
 ?>
                     
                     <?php 
 // dem so mau tin co trong CSDL
 //$sql   = "SELECT COUNT(*) AS numrows FROM product";
 //$sql = sprintf('select count(*) as numrows from product where thuong');
 $sql = "select count(*) as numrows from product where codep like '%" . $th . "%'";
 $result = DataProvider::executeQuery($sql);
 $row = mysql_fetch_array($result, MYSQL_ASSOC);
 $numrows = $row['numrows'];
 // tinh tong so trang se hien thi
 $maxPage = ceil($numrows / $rowsPerPage);
 // hien thi lien ket den tung trang
 $self = "timkiemsp_admin.php";
 $nav = '';
 for ($page = 1; $page <= $maxPage; $page++) {
     if ($page == $pageNum) {
         $nav .= sprintf(' %s ', $page);
         // khong can tao link cho trang hien hanh
     } else {
         //$nav .= " <a href=\"$self?page=$page\">$page</a> ";
         $nav .= sprintf('<a href="%s?page=%s&txttimkiem=%s"> %s </a> ', $self, $page, $_REQUEST['txttimkiem'], $page);
     }
Exemple #2
0
								<?php 
        }
    }
    ?>
                  </div>    
                  <?php 
    $i++;
}
?>
					
                       
					<?php 
// dem so mau tin co trong CSDL
//$sql   = "SELECT COUNT(*) AS numrows FROM product";
$sql1 = sprintf('select count(*) as numrows from product where nguoidang = "Hảo"');
$result1 = DataProvider::executeQuery($sql1);
$row = mysql_fetch_array($result1, MYSQL_ASSOC);
$numrows1 = $row['numrows'];
// tinh tong so trang se hien thi
$maxPage1 = ceil($numrows1 / $rowsPerPage1);
// hien thi lien ket den tung trang
$self1 = "admin.php";
$nav1 = '';
for ($page1 = 1; $page1 <= $maxPage1; $page1++) {
    if ($page1 == $pageNum1) {
        $nav1 .= sprintf(' %s ', $page1);
        // khong can tao link cho trang hien hanh
    } else {
        //$nav .= " <a href=\"$self?page=$page\">$page</a> ";
        $nav1 .= sprintf('<a href="%s?page=%s"> %s </a> ', $self1, $page1, $page1);
    }