PHP DiaOcPhapLyBUS::countAllBySQL示例

示例#1

文件： phapluat.php 项目： edconan93/real-estate-website

									<?php 
include "../BUS/DiaOcPhapLyBUS.php";
$rs = DiaOcPhapLyBUS::GetAllDiaOcPhapLy();
$curPage = 1;
$totalItems = null;
$business = null;
if (isset($_REQUEST['page'])) {
    $curPage = $_REQUEST['page'];
}
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
$strLink = "phapluat.php?";
$strSQL = "select * from diaocphaply";
$strCountSQL = str_replace("*", " count(*) ", $strSQL);
$totalItems = DiaOcPhapLyBUS::countAllBySQL($strCountSQL);
$strSQL .= " limit {$offset},{$maxItems}";
$business = DiaOcPhapLyBUS::getAllBySQL($strSQL);
echo DiaOcPhapLyBUS::display($strLink, $business, $totalItems, $curPage, $maxPages, $maxItems);
?>
							</div>
						</td>
					</tr>
				</table>
				<br>
						
			</td>
		</tr>
	</table>
<?php 
include "../include/footer.php";