时间:2021-07-01 10:21:17 帮助过:32人阅读
代码如下:
<?php
include_once "include.php";
/*
** 用途:用户系统数据抽象
** 作者:岳信明
** 时间:2005-8-30 10:05
*/
class User {
var $id = 0;
var $Name = "";
var $Password = "";
var $db = "";
var $tpl = "";
/*
** 函数功能:构造函数,指定类使用的数据库连接
** 参数说明:$tpl,显示模板处事句柄;$userdb,数据库连接
** 返 回 值:无
** 作 者:岳信明
** 创建时间:2005-8-30 10:37
*/
function User($vtpl = "", $userdb = "") {
if ($vtpl == "") {
global $tpl; // 外部定义数据库连接
$this->tpl =& $tpl;
} else {
$this->tpl = $vtpl;
}
if ($userdb == "") {
global $db; // 外部定义数据库连接
$this->db =& $db;
} else {
$this->db = $userdb;
}
}
/*
** 函数功能:将数据存入数据库
** 参数说明:无参数
** 返 回 值:true/false,成功/失败
** 作 者:岳信明
** 创建时间:2005-8-30 10:24
*/
function savetodb() {
if ($this->Name == "") {
return false;
}
if ($this->id) {
$strSQL = sprintf("UPDATE user SET Name='%s', Password='%s' "
. "WHERE id='%s'",
$this->Name,
$this->Password,
$this->id
);
} else {
$strSQL = sprintf("INSERT user (Name, Password) "
. "VALUES ('%s', '%s')",
$this->Name,
$this->Password
);
}
if ($this->db->query($strSQL)) {
return true;
} else {
return false;
}
}
/*
** 函数功能:从数据库中获取记录
** 参数说明:$id,记录编号
** 返 回 值:true/false,成功/失败
** 作 者:岳信明
** 创建时间:2005-8-30 10:32
*/
function getfromdb($id = 0) {
if ($id) {
$strSQL = sprintf("SELECT * FROM user WHERE id='%s'", $id);
} else if ($this->id) {
$strSQL = sprintf("SELECT * FROM user WHERE id='%s'",
$this->id
);
} else if ($this->Name != "") {
$strSQL = sprintf("SELECT * FROM user WHERE Name='%s'",
$this->Name
);
} else {
return false;
}
$this->db->query($strSQL);
if ($this->db->next_record()) {
$this->id = $this->db->f("id");
$this->Name = $this->db->f("Name");
$this->Password = $this->db->f("Password");
return true;
} else {
return false;
}
}
/*
** 函数功能:从数据库中删除记录
** 参数说明:$id,记录编号
** 返 回 值:true/false,成功/失败
** 作 者:岳信明
** 创建时间:2005-8-30 10:47
*/
function delete($id = 0) {
if (is_array($id)) { // 同时删除多条记录
foreach($id as $i) {
$strSQL = sprintf("DELETE FROM user WHERE id='%s'", $i);
$this->db->query($strSQL);
}
return true;
} else if ($id) {
$strSQL = sprintf("DELETE FROM user WHERE id='%s'", $id);
} else if ($this->id) {
$strSQL = sprintf("DELETE FROM user WHERE id='%s'", $this->id);
} else {
return false;
}
$this->db->query($strSQL);
return true;
}
/*
** 函数功能:显示登陆界面
** 参数说明:$placeholder,显示位置
** 返 回 值:无
** 作 者:岳信明
** 创建时间:2005-8-30 11:00
*/
function showLogin($placeholder) {
$this->tpl->addBlockfile($placeholder, "user_showLogin",
"tpl.user_showLogin.html"
);
$this->tpl->setCurrentBlock("user_showLogin");
$this->tpl->setVariable(array("user_Logintitle" => "用户登陆",
"strUsername" => "用户名",
"strPassword" => "密 码"
)
);
$this->tpl->parseCurrentBlock("user_showLogin");
}
/*
** 函数功能:处理登陆信息
** 参数说明:$placeholder,显示位置
** 返 回 值:true/false,成功/失败
** 作 者:岳信明
** 创建时间:2005-8-30 11:12
*/
function getLogin($placeholder = "") {
if (isset($_POST["login"])) {
if ($_POST["username"] == "") {
if ($placeholder != "") {
$this->tpl->setVarable($placeholder, "用户名不能为空!");
}
return false;
}
$this->Name = $_POST["username"];
$this->getfromdb();
if ($this->Password() == $_POST["password"]) {
return true;
}
} else {
if ($placeholder != "") {
$this->tpl->setVarable($placeholder, "登陆失败!");
}
return false;
}
}
/*
** 函数功能:显示注册界面
** 参数说明:$placeholder,显示位置
** 返 回 值:无
** 作 者:岳信明
** 创建时间:2005-8-30 13:33
*/
function showRegister($placeholder) {
$this->tpl->addBlockfile($placeholder, "user_showRegister",
"tpl.user_showRegister.html"
);
$this->setCurrentBlock("user_shoRegister");
// 在这里完成处理模板的代码
...
$this->parseCurrentBlock("user_shoRegister");
}
/*
** 函数功能:处理注册信息
** 参数说明:$placeholder,显示位置
** 返 回 值:true/false,注册成功/注册失败
** 作 者:岳信明
** 创建时间:2005-8-30 15:49
*/
function getRegister($placeholder = "") {
if (isset($_POST["register")) {
if ($_POST["username"] == "") { // 用户名合法性检查,可改成其它检查方式
if ($placeholder != "") { // 错误提示
$this->tpl->setVariable($placeholder, "用户名不合法!");
}
return false;
}
if ($_POST["password"] != $_POST["repassword"]) { // 密码合法性检查
if ($placeholder != "") { // 错误提示
$this->tpl->setVariable($placeholder, "两次输入密码不一致!");
}
return false;
}
$strSQL = sprintf("SELECT COUNT(*) FROM user "
. "WHERE Name='%s'",
$this->Name
);
$this->db->query($strSQL);
$this->db->next_record();
if ($this->db->f("COUNT(*)") > 0) {
return false;
} else {
$strSQL = sprintf("INSERT INTO user (Name, Password) "
. "VALUES('%s', '%s')",
$this->Name,
$this->Password
);
$this->db->query($strSQL);
return true;
}
} else {
return false;
}
}
} // 类User定义结束
/*
** 用途:用户系统数据列表抽象
** 作者:岳信明
** 时间:2005-8-30 17:21
*/
class UserList {
var $page = 0;
var $pages = 0;
var $pagesize = 9;
var $recordsum = 0;
var $Users = array();
var $c;
var $db = "";
var $tpl = "";
/*
** 函数功能:构造函数,新建一个类时对一些变量进行初始化
** 参数说明:无参数
** 返 回 值:无
** 作 者:岳信明
** 创建时间:2005-8-30 15:49
*/
function UserList($page = 1, $pagesize = 10,
$c, $vtpl = "", $vdb = "") {
$this->page = $page;
$this->pagesize = $pagesize;
$this->condition = $condition;
if ($vdb != "") {
$this->db = $vdb;
} else {
global $db;
$this->db = $db;
}
if ($vtpl != "") {
$this->tpl = $vtpl;
} else {
$this->tpl = $tpl;
}
$strSQL = sprintf("SELECT COUNT(*) FROM user WHERE '%s'",
$this->condition
);
$this->db->query($strSQL);
$this->db->next_record();
$this->recordsum = $this->db->f("COUNT(*)");
$this->pages = ceil($this->recordsum / $this->pagesize);
$strSQL = sprintf("SELECT * FROM user WHERE '%s' LIMIT '%s', '%s'",
$this->condition,
$this->page * $this->pagesize,
$this->pagesize + 1
);
$this->db->query($strSQL);
for ($i = 0; $this->db->next_record(); $i ++) {
$this->Users[$i] = new User($this->tpl, $this->db);
$this->Users[$i]->id = $this->db->f("id");
$this->Users[$i]->Name = $this->db->f("Name");
$this->Users[$i]->Password = $this->db->f("Password");
}
}
/*
** 函数功能:显示列表
** 参数说明:$placeholder,显示位置
** 返 回 值:无
** 作 者:岳信明
** 创建时间:2005-8-31 9:16
*/
function showUserList($placeholder) {
$this->tpl->addBlockfile($placeholder, "showUserList", "tpl.showUserList.html");
$this->tpl->setCurrentBlock("showUserList");
//在这里添加相应的处理代码
$this->tpl->setVariable("strTitle", "用户列表");
$strTitles = array("用户名", "操作");
$RecordOperations = array("重设密码" => "operate=passwd&id=",
"删除" => "operate=delete&id="
);
// 显示表头
foreach ($strTitles as $title) {
$this->tpl->setCurrentBlock("showRecordsTitle");
$this->tpl->setVariable("strHead", $title);
$this->tpl->parseCurrentBlock("showRecordsTitle");
}
// 显示记录及相关操作
if (is_array($this->Users)) { // 有记录
foreach ($this->Users as $user) {
$this->tpl->setCurrentBlock("showRecords");
$this->tpl->setCurrentBlock("showCell");
$this->tpl->setVariable("strCell", $user);
$this->tpl->parseCurrentBlock("showCell");
$this->tpl->setCurrentBlock("showCell");
foreach ($RecordOperations as $operation => $linkOperation) {
$this->tpl->setCurrentBlock("showOperations");
$this->tpl->setVariable("strOperation", $operation);
$this->tpl->setVariable("strLink", $_SERVER["REQUEST_URI"] . $linkOperation . $user->id);
$this->tpl->parseCurrentBlock("showOperations");
}
$this->tpl->parseCurrentBlock("showCell");
$this->tpl->parseCurrentBlock("showRecords");
}
} else { // 无记录
$this->tpl->setCurrentBlock("showRecords");
$this->tpl->setCurrentBlock("showCell");
$this->tpl->setVariable("strCell", "无记录");
$this->tpl->parseCurrentBlock("showCell");
$this->tpl->setCurrentBlock("showCell");
$this->tpl->setVariable("strCell", " ");
$this->tpl->parseCurrentBlock("showCell");
$this->tpl->parseCurrentBlock("showRecords");
}
$this->tpl->setCurrentBlock("showPageInfo");
$this->tpl->setVariable(array("intColspan" => "2",
"intRecordSum" => $this->recordsum,
"intPage" => $this->page,
"intPages" => $this->pages
)
);
$this->tpl->parseCurrentBlock("showPageInfo");
$this->tpl->parseCurrentBlock("showUserList");
}
}
?>