图书管理程序（一）_php基础

本级程序所用的数据表结构：
# --------------------------------------------------------
#
# 数据表的结构 'author'
#

CREATE TABLE author (
   author_id int(6) DEFAULT '0' NOT NULL auto_increment,
   first_name varchar(20) binary NOT NULL,
   last_name varchar(20) NOT NULL,
   address varchar(100) binary NOT NULL,
   zipcode varchar(10) NOT NULL,
   telephone varchar(10) NOT NULL,
   email varchar(50) NOT NULL,
   comment varchar(255) NOT NULL,
   PRIMARY KEY (author_id),
   KEY first_name (first_name),
   KEY last_name (last_name),
   KEY address (address),
   KEY zipcode (zipcode),
   KEY email (email)
);

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

CREATE TABLE books (
   books_id int(6) DEFAULT '0' NOT NULL auto_increment,
   books_name varchar(100) binary NOT NULL,
   publisher_id varchar(6) NOT NULL,
   date_pub datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   type varchar(6) NOT NULL,
   pages varchar(4) NOT NULL,
   price float(6,2) DEFAULT '0.00' NOT NULL,
   comment varchar(255) binary NOT NULL,
   ISBN varchar(25) NOT NULL,
   PRIMARY KEY (books_id),
   KEY name (books_name),
   KEY publisher (publisher_id),
   KEY date_pub (date_pub),
   KEY price (price),
   KEY pages (pages),
   KEY type (type),
   KEY ISBN (ISBN)
);
# --------------------------------------------------------
#
# 数据表的结构 'books_author'
#

CREATE TABLE books_author (
   id int(6) DEFAULT '0' NOT NULL auto_increment,
   books_id varchar(6) NOT NULL,
   author_id varchar(6) NOT NULL,
   author_type varchar(6) NOT NULL,
   PRIMARY KEY (id)
);

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

CREATE TABLE publisher (
   publisher_id int(6) DEFAULT '0' NOT NULL auto_increment,
   publisher_name varchar(100) binary NOT NULL,
   address varchar(100) NOT NULL,
   zipcode varchar(10) NOT NULL,
   telephone varchar(10) NOT NULL,
   telefax varchar(10) NOT NULL,
   email varchar(50) NOT NULL,
   PRIMARY KEY (publisher_id),
   KEY name (publisher_name),
   KEY address (address),
   KEY email (email)
);

点创DOidea网上书店

一套专业的网上书店程序，可以作为新华书店及大中型书店网上销售的首选，满足在线支付及汇款确认机制。功能简介：图书分类、查询、排行、最新、特价、关注排行、销售排行，新闻系统、汇款确认机制、求购书籍、在线咨询、热门图书定义、全站广告后台管理、后台采用WEBEDIT编辑器、集成"支付宝"在线支付等...v3.5版特殊功能说明（前台）:1.自带5种风格主题。2.友好的页面提示（对网站全部

下载