利用PHP與Smarty模板技術產生分頁靜態頁面的代碼

來源:互聯網
上載者:User
lear_all_cache();//清除所有緩衝

<?php
//smarty.php
//create html file use smarty template
//Rossy.cn@gmial.com
//2007-07-27 11:15

require_once("classes/Smarty.class.php"); //smarty檔案
require_once("config.php"); //設定檔
require_once("mysql_class.php"); //資料庫連接檔案

$smarty = new Smarty();
$smarty->template_dir = "templates";
$smarty->compile_dir  ="templates_c";
$smarty->left_delimiter = "<{";
$smarty->right_delimiter ="}>";

$page_count = "3"; //每一頁的記錄數
$Db = new Mysql;
$query = $Db->Query("Select * FROM Tablea orDER BYId DESC");
$tatol = $Db->FetchCount($query);
$pages = ceil($tatol / $page_count);
for ($j=1;$j<=$pages;$j++)
    $showpages.="<ahref=\"user_".$j.".htm\">".$j."</a>";

for ($i = 0;$i<$pages; $i++)
{   
    $start_page = $i *$page_count;   
    if($pages>1)
    {
       $indexpath  ="user_".($i+1).".htm";  //filename
       $showpagestr= "<ahref=\"user_1.htm\">第一頁</a>".$showpages." <ahref=\"user_".$pages.".htm\">最尾頁</a>";
    }
    else
    {
       $indexpath  = "user.htm"; //file name
       $showpagestr= "";
    }
   
    $sql = "Select * FROM TableaorDER BY ID DESC LIMIT $start_page,$page_count";
    $query =$Db->Query($sql) or die("Invalid Query");
   if(($Db->FetchCount($query))<1){
       $Admin ="數據庫沒有此數據";
    }else{
       while ($rs =$Db->FetchArray($query)) {
          $Admin[] =array('Id'=>$rs['Id'],'Name'=>$rs['Name'],'Nick'=>$rs['Username'],'Type'=>$rs['Type'],'Email'=>$rs['Email']);
       }
    }

   $smarty->assign(array('Site_Name'=>"系統",'AdminName'=>'ybfqlyq','AdminType'=>'Administrator','Type'=>'1'));
   $smarty->assign('Admin',$Admin);
   $smarty->assign('Page_Str',$showpagestr);
    $temp =$smarty->fetch('test.tpl', null, null, false);//模板檔案
    unset($Admin);
    $showpagestr = "";
   $fp=fopen($indexpath,'w');
    fwrite($fp,$temp) ordie('create failed');
}
$Db->Close();
echo "create htm file successfully";
?>

test.tpl檔案代碼:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01Transitional//EN""http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<!-- saved fromurl=(0046)http://localhost/overseatrade/keyword/User.php-->
<HTMLxmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE><{$SiteName}></TITLE>
<META http-equiv=Content-Type content="text/html;charset=utf-8"><LINK
href="templates/css.css" type=text/cssrel=stylesheet>
<META content="MSHTML 6.00.2900.2722"name=GENERATOR>
<style type="text/css">
<!--
.style1 {
    font-size: 18px;
    font-weight: bold;
}
-->
</style>
</HEAD>
<BODY>  
<TABLE cellSpacing=0 cellPadding=0 width="90%"border=0>
       <TBODY>
       <TR>
        <TD height="50" class=tipsstyle1><spanclass="style1">Example of create html file usesmarty template with php</span></TD>
       </TR>
       </TBODY></TABLE>
     <TABLE class=tablestyle="WORD-BREAK: break-all" borderColor=#000000
     cellSpacing=0 cellPadding=2 width="100%"align=center border=1>
       <TBODY>
       <TRclass="red1bg_head1">
        <TD class=linebg1 align=middle>編號</TD>
        <TD class=linebg1 align=middle>用戶名</TD>
        <TD class=linebg1 align=middle>姓名</TD>
        <TD class=linebg1align=middle>類別</TD>
        <TD class=linebg1align=middle>郵件地址</TD>
       </TR>
       <{sectionname=adminlist loop=$Admin}><TRclass="linebg<{$Bg_Type}>1">
        <TDalign=middle>  <{$Admin[adminlist].Id}></TD>
        <TDalign=middle>  <{$Admin[adminlist].Name}></TD>
        <TDalign=middle>  <{$Admin[adminlist].Nick}></TD>
        <TDalign=middle>  <{$Admin[adminlist].Type}></TD>
        <TD align=middle> <Aclass=B
         href="mailto:<{$Admin[adminlist].Email}>"><{$Admin[adminlist].Email}></A></TD>
     

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.