PHP ??? ???? ?? ??? ??? ??????? ???? ??? ???? ???? ????. ?? ?? ????? ????? ???? ??? ??? ???? ??? ?? ??? ???? ?? ?? ? ?? ??? ???? ?????.

?? ?? ?????? ??? ?? ?? ??????? ??? ?????

???? ?? ??????? ??? ?? phpmyadmin? ?? ? ?? ???????

?? SQL ?? ???? ??? ?? ????. ?? .

?? ?? ???? ???? ???. ??? ? ?? ???? ???? ?? ????.

CREATE TABLE IF NOT EXISTS `admin` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username ` varchar(15) NOT NULL,

`password` varchar(15) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

INSERT INTO ` admin` (`id`, `username`, `password`) VALUES

(1, 'admin', '540548356');

info ???:

CREATE TABLE IF NOT EXISTS `info` (

` id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(15) CHARACTER SET utf8 DEFAULT NULL,

`username` varchar(15) DEFAULT NULL,

`qq` varchar(15) DEFAULT NULL ,

`Email` varchar(15) DEFAULT NULL,

`address` varchar(15) CHARACTER SET utf8 DEFAULT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=5 7 ;

? ?? ??:

CREATE TABLE IF NOT EXISTS `newbook` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`bookname` varchar(32) NOT NULL,

`images` varchar(50) NOT NULL,

`??` varchar(100) NOT NULL,

`author` varchar(11) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=4 ;

??? ???:

CREATE TABLE IF NOT EXISTS `page` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(15) NOT NULL,

`images` varchar(100) NOT NULL,

`content` varchar(100) NOT NULL,

?? ?(`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=156 ;

??? ???:

CREATE TABLE IF NOT EXISTS `user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(32) NOT NULL,

`password` varchar(32) NOT NULL,

`qq` varchar(32) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM ?? CHARSET=utf8 AUTO_INCREMENT=11 ;

??? ? ? ??? ???? ?? ??? ??? ???????