BBS(php & mysql)完整版(八)

2016-01-29 14:35 7 1 收藏

BBS(php & mysql)完整版(八),BBS(php & mysql)完整版(八)

【 tulaoshi.com - PHP 】

  //完毕 wish you sucess!!

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主机: localhost:3306 数据库 : database
# --------------------------------------------------------
#
# 数据表的结构 'bbs_html'
#

CREATE TABLE bbs_html (
   id int(15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   date1 varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 int(15) DEFAULT '0' NOT NULL,
   r5 int(15) DEFAULT '0' NOT NULL,
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# 数据表的结构 'bbs_js'
#

CREATE TABLE bbs_js (
   id int(15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   date1 varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 int(15) DEFAULT '0' NOT NULL,
   r5 int(15) DEFAULT '0' NOT NULL,
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# 数据表的结构 'bbs_mysql'
#

CREATE TABLE bbs_mysql (
   id int(15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   date1 varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 int(15) DEFAULT '0' NOT NULL,
   r5 int(15) DEFAULT '0' NOT NULL,
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# 数据表的结构 'bbs_php'
#

CREATE TABLE bbs_php (
   id int(15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   date1 varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 int(15) DEFAULT '0' NOT NULL,
   r5 int(15) DEFAULT '0' NOT NULL,
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# 数据表的结构 'bbs_re'
#

CREATE TABLE bbs_re (
   id int(15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
   date1 varchar(30) NOT NULL
);


# --------------------------------------------------------
#
# 数据表的结构 'user'
#

CREATE TABLE user (
   id int(15) DEFAULT '0' NOT NULL,
  &nb

来源:http://www.tulaoshi.com/n/20160129/1493686.html

延伸阅读
标签: Web开发
//此页面为 top.php html head titleUntitled Document/title meta http-equiv="Content-Type" content="text/html; charset=gb2312" script language="JavaScript1.2" src="js/fw_menu.js"/script script language="JavaScript1.2" src="js/menu_comment.js"/script /he...
标签: PHP
  //此页面为look.php <? include "signup/mysql.inc"; $sql="select * from ".$table." where id='$id'"; $result=mysql_query($sql)or die(mysql_error()); $row=mysql_fetch_array($result); $number=++$row["number"]; $sql="update $table set number='$number' where id='...
标签: Web开发
//此页面为php3.php ? include "signup/mysql.inc"; switch($part){    case "1" :$table="bbs_php";break;    case "2" :$table="bbs_mysql";break;    case "3" :$table="bbs_html";break;    ca...
标签: PHP
  //此页面为 top.php <html <head <titleUntitled Document</title <meta http-equiv="Content-Type" content="text/html; charset=gb2312" <script language="JavaScript1.2" src="http://img.jcwcn.com/attachment/portal"http://www.jcwcn.com/Files/BeyondPic/jcwcj/2005-12...
标签: PHP
  //此页面为say.php <? include "signup/mysql.inc"; if($id1){        $sql="select * from $table where id='$id1'";    //显示回复题目        $result=mysql_query($sql)or die(mysql_error()); &...

经验教程

569

收藏

24
微博分享 QQ分享 QQ空间 手机页面 收藏网站 回到头部