php留言板代码大全_php留言板代码

时间：2016-07-11 来源：留言阅读：

/*
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"];
?>

小贤PHP分页程序

新闻列表添加新闻

$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 "

page_replace(1)."" title="首页" >首页 ";

  }else{

   return "    首页 ";

  }
}

private function myde_prev() //上一页
{
  if($this -> myde_page != 1){

   return "

page_replace($this->myde_page-1) ."" title="上一页" >上一页 ";

  }else{

   return "    上一页 ";

  }
}

private function myde_next() //下一页
{
  if($this -> myde_page != $this -> myde_page_count){

    return "

page_replace($this->myde_page+1) ."" title="下一页" >下一页 ";

  }else{

   return "    下一页 ";

  }
}

private function myde_last() //尾页
{
  if($this -> myde_page != $this -> myde_page_count){

    return "

page_replace($this -> myde_page_count)."" title="尾页" >尾页 ";

  }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 .= "

".$page_for_i." ";

   }

   else{

    $str .= "

page_replace($page_for_i)."" title="第".$page_for_i."页">";

    $str .= $page_for_i . " ";

   }
        }
  $str .= $this -> myde_next();

  $str .= $this -> myde_last();

  $str .= "

myde_page.""";

  $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();//显示
*/
?>

php留言板代码大全_php留言板代码

http://m.bbyears.com/zhufuduanxin/25249.html

推荐访问:php留言板开发 php代码加密 php登录页面完整代码

上一篇：[163网易免费邮箱]仿网易163新闻评论盖楼效果代码

下一篇：[phpstudy]php txt留言板（还分页功能）