?? list.php
字號:
<?php include ("../inc/db.php"); include ("../inc/phpmkrfn.php"); include ('../inc/xtpl.php'); include ("../inc/pageft.php"); $xtpl=new XTemplate ("listview.html"); $conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);//總頁數$sSql ="select * from gongyins";$result=phpmkr_query($sSql,$conn);$total=phpmkr_num_rows($result);//調用pageft(),每頁顯示10條信息(使用默認的20時,可以省略此參數),使用本頁URL(默認,所以省略掉)。pageft($total,15); $sSql ="select * from gongyins limit $firstcount,$displaypg"; $rs = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql); while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) { $xtpl->assign("DATA",$row); /* assign array data */ $xtpl->parse("main.table.row"); /* parse a row */ } $xtpl->parse("main.table"); /* parse the table */ $xtpl->assign("PAGEINFO",$pagenav); //分頁 $xtpl->parse("main"); $xtpl->out("main");?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -