</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); }
<?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); }