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>