日期:2014-05-17 浏览次数:20633 次
1. 站点结构
?
?
站点
┗includes
? ?┗class.inc
┣templates
? ?┗index.htm
? ?┣list.htm
? ?┗content.htm
┣index.php
┗content.php
?
2. 库结构
?
?
--
-- Database: `test`
--
-- --------------------
--
-- Table structure for table `test`
--
CREATE TABLE `test` (
`id` smallint(3) NOT NULL auto_increment,
`name` varchar(10) NOT NULL default '',
`sex` enum('male','female') NOT NULL default 'male',
`age` smallint(2) NOT NULL default '0',
`email` varchar(20) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `test`
--
INSERT INTO `test` VALUES (1, 'freshlove', 'male', 28, 'freshlove@gmail.com');
INSERT INTO `test` VALUES (2, 'dinahani', 'female', 29, 'dinahani@gmail.com');
INSERT INTO `test` VALUES (3, 'sam', 'male', 1, 'sam@gmail.com');
INSERT INTO `test` VALUES (4, 'girl', 'female', 0, 'girl@gmail.com');
?
?
3. ?代码
?
--------------- class.inc文件 --------
?
?
<?php
class db{
private $host;
private $user;
private $pwd;
function __construct($host='localhost',$user='root',$pwd='root'){
$this->host = $host;
$this->user = $user;
$this->pwd = $pwd;
}
function connect(){
return mysql_connect($this->host,$this->user,$this->pwd);
}
}
class template{
private $source_file;
function get_file($filename){
$this->source_file = file_get_contents($filename);
}
function parse($tags,$vals){
if(!is_array($tags)) return preg_replace('|{'.$tags.'}|',$vals,$this->source_file);
else{
foreach($tags as $row) $keys[] = '|{'.$row.'}|';
return preg_replace($keys,$vals,$this->source_file);
}
}
}
?>
?
?
?----------------index.htm文件-------------------
?
?
?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Home Page</title>
</head>
<body style="font-size:12px">
<table width="100%" cellpadding="0" cellspacing="1" bgcolor="#000000">
<caption>Members List</caption>
<tr bgcolor="#ffffff">
<th>Name</th>
<th>Sex</th>
<th>Age</th>
<th>Email</th>
</tr>
{all_lists}
<tr bgcolor="#ffffff">
<td colspan=2>Total: {total_numbers}, Display {per_numbers}/page</td>
<td colspan=2 align=right>{page}</td>
</tr>
<table>
<body>
<html>
?
?
------------------list.htm文件-------------------
?
?
?
<tr bgcolor="#ffffff" align="center">
<td><a href="content.php?id={mid}">{name}</a></td>
<td>{sex}</td>
<td>{age}</td>
<td>{email}</td>
</tr>
?
?
-------------------content.htm文件-----------------------
?
?
?
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Home Page</title>
</head>
<body style="font-size:12px">
<table width="100%" cellpadding="0" cellspacing="1" bgcolor="#000000">
<caption>Memb