/*
sql数据库教程结构
-- phpMyAdmin SQL Dump
-- version 2.11.6
--
-- 主机: localhost
-- 生成日期: 2009 年 11 月 08 日 08:22
-- 服务器版本: 5.0.51
-- PHP 版本: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 ;
--
-- 数据库: `myde520`
--
-- --------------------------------------------------------
--
-- 表的结构 `news`
--
CREATE TABLE `news` (
`id` int(10) NOT NULL auto_increment,
`title` varchar(250) character set gbk default NULL,
`content` text character set gbk,
`date` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=9 ;
--
-- 导出表中的数据 `news`
--
INSERT INTO `news` (`id`, `title`, `content`, `date`) VALUES
(1, "看博文网址公布", "看博文网址http://www.111cn.net", "2009-11-08"),
(2, "寻宝客网址公布", "寻宝客的网址是http://www.111cn.net,希望大家常来看看", "2009-11-08"),
(3, "小贤家园网址公布", "小贤家园http://www.111cn.net", "2009-11-08"),
(4, "桂林特产网址公布", "桂林特产网址htttp://www.111cn.net", "2009-11-08"),
(5, "阳朔仙境宾馆网址公布", "阳朔仙境宾馆网址http://www.111cn.net", "2009-11-08"),
(6, "养生堂网址公布", "养生堂网址http://www.111cn.net", "2009-11-08"),
(7, "寻宝客上线25天", "寻宝客上线25天,百度和谷歌都收录过1000篇! http://www.111cn.net", "2009-11-08");
*/
//html代码
?>
include "page.Class.php";
$page = $_GET["page"];
?>
新闻列表 添加新闻
$mysql教程 = new mysql_Class("localhost","root","");
$mysql -> select_db("myde520");
switch($_GET["action"]){
case "add":
?>
break;
case "act_add":
$sql = "INSERT INTO `news` (`title`,`content`,`date`) VALUES("".$_POST["title"];
$sql .= "","".$_POST["content"]."","".$_POST["date"]."")";
$mysql -> query($sql);
msg("添加成功!","?action=");
break;
case "edit":
$sql = "select * from `news` where id=".$_GET["id"];
$query = $mysql -> query($sql);
$row = $mysql -> fetch_array($query);
if($row){
?>
}else{
msg("要修改的记录不存在!","?action=");
}
break;
case "act_edit":
$sql = "select id from `news` where id=".$_POST["id"];
$query = $mysql -> query($sql);
$row = $mysql -> fetch_array($query);
if($row){
$sql = "update `news` set `title`="".$_POST["title"].""";
$sql .= ",`content`="".$_POST["content"]."",`date`="".$_POST["date"]."" where `id`=".$_POST["id"];
$mysql -> query($sql);
msg("修改成功!","?action=");
}
break;
case "del":
$sql = "select * from `news` where `id`=".$_GET["id"];
$query = $mysql -> query($sql);
$row = $mysql -> fetch_array($query);
if($row){
$mysql -> query("delete from `news` where `id`=".$_GET["id"]);
msg("删除成功!","?action=");
}else{
msg("记录不存在!","?action=");
}
break;
case "":
$count = $mysql -> num_rows($mysql -> query("select id from `news`"));
$pages = new PageClass($count,1,$_GET["page"],"index.php?page={page}");//分别为(记录总数,每页显示多少条记录,当前面,显示方式)
//特别说明:如果是伪静态分页或者纯静态分页,那么显示方式需要改,比如改成index-{page}.html
$sql = "select * from `news` order by ";
$sql .= "id Desc limit ".$pages -> page_limit.",".$pages -> myde_size;
$result = $mysql -> query($sql);
?>
新闻标题
时间
操作
while($row = $mysql -> fetch_array($result)){
?>
">
">修改 ">删除
}
?>
echo $pages -> myde_write();
break;
}
?>
function msg($msg,$url)
{
echo "<script type="text/javascript教程">alert("$msg");window.location.href="$url";</script>";
}
/**
*-------------------------数据库操作类-----------------------------*
*/
class mySql_Class
{
function __construct($host, $user, $pass)
{
@mysql_connect($host,$user,$pass) or die("数据库连接失败!");
mysql_query("SET NAMES "gbk"");
}
function select_db($db)//连接表
{
return @mysql_select_db($db);
}
function query($sql)//执行SQL语句
{
return @mysql_query($sql);
}
function fetch_array($fetch_array)
{
return @mysql_fetch_array($fetch_array, MYSQL_ASSOC);
}
function num_rows($sql)
{
return @mysql_num_rows($sql);
}
}
?>
page.Class.php
/**
*-------------------------翻页类----------------------*
*/
class PageClass
{
private $myde_count; //总记录数
var $myde_size; //每页记录数
private $myde_page; //当前页
private $myde_page_count; //总页数
private $page_url; //页面url
private $page_i; //起始页
private $page_ub; //结束页
var $page_limit;
function __construct($myde_count=0, $myde_size=1, $myde_page=1,$page_url)//构造函数
{
$this -> myde_count = $this -> numeric($myde_count);
$this -> myde_size = $this -> numeric($myde_size);
$this -> myde_page = $this -> numeric($myde_page);
$this -> page_limit = ($this -> myde_page * $this -> myde_size) - $this -> myde_size;
$this -> page_url = $page_url;
if($this -> myde_page < 1) $this -> myde_page =1;
if($this -> myde_count < 0) $this -> myde_page =0;
$this -> myde_page_count = ceil($this -> myde_count/$this -> myde_size);
if($this -> myde_page_count < 1) $this -> myde_page_count = 1;
if($this -> myde_page > $this -> myde_page_count) $this -> myde_page = $this -> myde_page_count;
$this -> page_i = $this -> myde_page - 2;
$this -> page_ub = $this -> myde_page + 2;
if($this -> page_i < 1){
$this -> page_ub = $this -> page_ub + (1 - $this -> page_i);
$this -> page_i = 1;
}
if($this -> page_ub > $this -> myde_page_count){
$this -> page_i = $this -> page_i - ($this -> page_ub - $this -> myde_page_count);
$this -> page_ub = $this -> myde_page_count;
if($this -> page_i < 1) $this -> page_i = 1;
}
}
private function numeric($id) //判断是否为数字
{
if (strlen($id)){
if (!ereg("^[0-9]+$",$id)){
$id = 1;
}else{
$id = substr($id,0,11);
}
}else{
$id = 1;
}
return $id;
}
private function page_replace($page) //地址替换
{
return str_replace("{page}", $page, $this -> page_url);
}
private function myde_home() //首页
{
if($this -> myde_page != 1){
return "
}else{
return " 首页 ";
}
}
private function myde_prev() //上一页
{
if($this -> myde_page != 1){
return "
}else{
return " 上一页 ";
}
}
private function myde_next() //下一页
{
if($this -> myde_page != $this -> myde_page_count){
return "
}else{
return " 下一页 ";
}
}
private function myde_last() //尾页
{
if($this -> myde_page != $this -> myde_page_count){
return "
}else{
return " 尾页 ";
}
}
function myde_write($id="page") //输出
{
$str = " ";
$str .= " 总记录:".$this -> myde_count." ";
$str .= " ".$this -> myde_page."/".$this -> myde_page_count." ";
$str .= $this -> myde_home();
$str .= $this -> myde_prev();
for($page_for_i = $this -> page_i;$page_for_i <= $this -> page_ub; $page_for_i++){
if($this -> myde_page == $page_for_i){
$str .= "
}
else{
$str .= "
$str .= $page_for_i . " ";
}
}
$str .= $this -> myde_next();
$str .= $this -> myde_last();
$str .= "
$str .= " onkeydown="javascript: if(event.keyCode==13){ location="";
$str .= $this -> page_replace(""+this.value+"")."";return false;}"";
$str .= " title="输入您想要到达的页码" /> ";
$str .= " ";
return $str;
}
}
/*-------------------------实例--------------------------------*
$page = new PageClass(1000,5,$_GET["page"],"?page={page}");//用于动态
$page = new PageClass(1000,5,$_GET["page"],"list-{page}.html");//用于静态或者伪静态
$page -> myde_write();//显示
*/
?>
http://m.bbyears.com/zhufuduanxin/25249.html
推荐访问:php留言板开发 php代码加密 php登录页面完整代码