站点结构
代码:
站点
┗includes
┗class.inc
┣templet
┗index.htm
┣list.htm
┗content.htm
┣index.php
┗content.php
库结构
代码:
-- 数据库: `test`
-- 表的结构 `test`
CREATE TABLE `test` (
`id` smallint(3) NOT NULL auto_increment,
`name` varchar(10) NOT NULL default '',
`sex` enum('男','女') NOT NULL default '男',
`age` smallint(2) NOT NULL default '0',
`email` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--------------- class.inc文件 --------
[url=content.php?id={成员ID}]</TR>
-------------------content.htm文件-----------------------
<HTML>
<HEAD>
<TITLE>成员信息</TITLE>
</HEAD>
<BODY style="font-size:12px">
<TABLE WIDTH="100%" CELLPADDING="0" CELLSPACING="1" bgcolor=#000000 style="font-size:12px">
<caption>成员信息</caption>
<TR bgcolor="#ffffff">
<TD width=60>姓名</TD><TD>{姓名}</TD></TR>
<TR bgcolor="#ffffff">
<TD>性别</TD><TD>{性别}</TD></TR>
<TR bgcolor="#ffffff">
<TD>年龄</TD><TD>{年龄}</TD></TR>
<TR bgcolor="#ffffff">
<TD>email</TD><TD>{email}</TD></TR>
</TABLE>
</BODY>
----------------index.php文件--------------------------
[url=?p=1] if($p>1) $pagination .= "<a href='?p=".($p-1)."'>";
else $pagination .= "<font color='#777777'>";
$pagination .= "上一页</font></a> ";
if($p<$ps) $pagination .= "<a href='?p=".($p+1)."'>";
else $pagination .= "<font color='#777777'>";
$pagination .= "下一页</font></a> <a href='?p={$ps}'>尾页</a> ";
/***** 分页完成, 生成页面开始 *****/
$tags = array("所有列表","总条数","每页条数","分页");
$vals = array($lists,$rn,$lim,$pagination);
echo $tmpl->parse($tags,$vals);
?>
---------------- content.php文件 ---------------
<?php
include("includes/class.inc");
$tmpl =new templet;
$mycon =new mycon;
$con = $mycon->connect();
mysql_select_db("test",$con);
$tmpl->get_file("templet/content.htm");
$rs = mysql_query("select * from test where id=$_GET[id]");
$row=@mysql_fetch_row($rs);
unset($row[0]); //去掉表中读出的多余字段,对齐替换项,或在SELECT语句中列表字段
$tags = array("姓名","性别","年龄","email");
echo $tmpl->parse($tags,$row);
?>