站点结构
代码:
站点
┗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文件 --------
复制代码 代码如下:
class mycon{
private $myhost;
private $myuser;
private $mypwd;
function mycon($host="localhost",$user="root",$pwd=""){
$this->myhost = $host;
$this->myuser = $user;
$this->mypwd = $pwd;
}
function connect(){
return mysql_connect($this->myhost,$this->myuser,$this->mypwd);
}
}
class templet{
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{
$an = count($tags);
for($i=0;$i $tags[$i] = "|{".$tags[$i]."}|";
}
return preg_replace($tags,$vals,$this->source_file);
}
}
}
?>
----------------index.htm文件-------------------
复制代码 代码如下:
姓名 | 性别 | 年龄 | |
共有{总条数}条记录,显示{每页条数}条/页 | {分页} |
------------------list.htm文件-------------------
复制代码 代码如下:
-------------------content.htm文件-----------------------
复制代码 代码如下:
姓名 | {姓名} |
性别 | {性别} |
年龄 | {年龄} |
{email} |
----------------index.php文件--------------------------
复制代码 代码如下:
include("includes/class.inc");
$tmpl =new templet;
$mycon =new mycon;
$con = $mycon->connect();
mysql_select_db("test",$con);
$lim = 20; //每页显示行数
$p = ($_GET[p]) ? $_GET[p] : 1; //当前页号
/***** 生成列表开始 *****/
$lists = "";
$tmpl->get_file("templet/list.htm");
$tags = array("成员ID","姓名","性别","年龄","email"); //应与表字段同顺序
$rs = mysql_query("select * from test order by id desc limit ".($p-1)*$lim.",$lim");
while($row=mysql_fetch_row($rs)){
$lists .= $tmpl->parse($tags,$row);
}
/***** 生成列表完成, 分页开始 *****/
$tmpl->get_file("templet/index.htm");
$rn = @mysql_result(mysql_query("select count(id) from test"),0); //总记录数
$ps = ceil($rn/$lim); //总页数
$pagination = "首页 ";
if($p>1) $pagination .= "";
else $pagination .= "";
$pagination .= "上一页 ";
if($p";
else $pagination .= "";
$pagination .= "下一页 尾页 ";
/***** 分页完成, 生成页面开始 *****/
$tags = array("所有列表","总条数","每页条数","分页");
$vals = array($lists,$rn,$lim,$pagination);
echo $tmpl->parse($tags,$vals);
?>
---------------- content.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);
?>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

Atom editor mac version download
The most popular open source editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

Zend Studio 13.0.1
Powerful PHP integrated development environment

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software