//header("Content-type: text/html; charset=utf8");
//include('incsession.php');
//include('config.php');
//include('keya.inc');
?>
include('./JS/fixedHeade.php'); //載入
// $fromname= $fromname;
//echo "$fromname";
?>
include("application.php");
if (!isset($_SESSION["USER"]["user"]["username"])){
echo "請登入!! ";
}
else { //有登入
//echo $_SESSION["USER"]["user"]["username"];
if ($_SESSION["USER"]["user"]["username"]=='cch' or $_SESSION["USER"]["user"]["username"]=='pupai' ) {
?>
}
$rresult = db_query("
SELECT * FROM om1
");
//$page變量標示當前顯示的頁
if(!isset($page)) $page=1;
if($page==0) $page=1;
//得到當前查詢到的紀錄數 $nNumRows
if(($nNumRows= mysql_num_rows($rresult))<=0)
{
echo "沒有紀錄";
exit;
};
$gPageSize= $nNumRows;
//得到最大頁碼數MaxPage
$MaxPage = (int)ceil($nNumRows/$gPageSize);
if((int)$page > $MaxPage)
$page=$maxPage;
?>
| echo "第
$page 頁,共 $MaxPage 頁,共 $nNumRows 筆";?> | |
//根據偏移量($page - 1)*$gPageSize,運用mssql_data_seek函數得到要顯示的頁面
if( mysql_data_seek($rresult,($page-1)*$gPageSize) )
{
$i=0;
//循環顯示當前紀錄集
for($i;$i<$gPageSize;$i++)
{
echo "";
//得到當前紀錄,填充到數組$arr;
$arr= mysql_fetch_row($rresult);
if($arr)
{
//循環顯示當前紀錄的所有字段值
for($nOffSet = 0;$nOffSet < count($arr);$nOffSet++)
{
//顯示轉成UTF8
if ($nOffSet==0 ) {
//$fsn=base64_encode($arr[0]);
// $arr[$nOffSet] = "".iconv("gb2312","utf-8","change").""; //變更
$arr[$nOffSet] = iconv("gb2312","utf-8",$arr[$nOffSet]);
}
else {
if ($nOffSet==2 ) {
$fname=base64_encode($arr[11]);
$arr[$nOffSet] = "".iconv("gb2312","utf-8",$arr[$nOffSet])."";}
else {
$arr[$nOffSet] = iconv("gb2312","utf-8",$arr[$nOffSet]);}}
echo "| ".$arr[$nOffSet]." | ";
}
}
echo "
";
}
}
?>
//首頁和上一頁的鏈接
if( $nNumRows>1 == $page>1)
{
$prevPage=$page-1;
echo "
首頁 ";
echo "
上一頁 ";
}
//下一頁和末頁的鏈接
if( $page>=1 == $page<$MaxPage)
{
$nextPage= $page+1;
echo "
下一頁 ";
echo "
末頁 ";
}
?>
//echo "下載excel結果";
?>
}
?>