PHP ?? ??? ???? ?????? ??
?????? ??
? ?????? ???? ?? ??? ??? ?? ? ???, ??? ??, ???? ?? ?????. ? ??? ???? ??? ???? ??? ????? ? ?? ???? ???? ???. table
??? ??? user?? ?? ??? ?????.
?? ?? | ?? ?? | ?? ?? | ?? ?? |
| id | int | 30 | ??, ?? ?, ?? ?? |
| ??? ?? | varchar | 30 | username |
| password | varchar | 40 | password |
post ??? Tiezi?? ?? ??? ?????.
| ?? ?? | ?? ?? | ?? ?? | ?? ?? |
| id | int | 30 | ??, ?? ?, ?? ?? |
| userId | int | 30 | ??? ???? ??? ID |
| fId | int | 30 | ? ???? ??? ????? |
| title | varchar | 50 | ??? ?? |
| content | text | ??? ??? | |
| timestamp | varchar | 30 | ??? ?? ?? |
| num | int | 20 | ??? ??? |
?????? ??
?? ???? ??? mysql? ?????(????? ?? ???? ?? ?? ??????? ???? ??? ?? ??? "PHP ?? ??? ?? ????"? ?????. " ?? 2.2)
??????? ????? ??? ? ?? ??????? ???? ?? ?? ?? ?????. Enter ?? ??? ??? ?? ??? ????? ???? ?????
??????? ???? ?? ???? ??? ????.
DROP DATABASE IF EXISTS tieba;
CREATE DATABASE tieba DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE tieba;
CREATE TABLE IF NOT EXISTS `user` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`password` varchar(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
INSERT INTO `user` (`username`, `password`) VALUES
('admin', '21232f297a57a5a743894a0e4a801fc3');
CREATE TABLE IF NOT EXISTS `tiezi` (
`id` int(30) NOT NULL AUTO_INCREMENT,
`userId` int(30) NOT NULL,
`fId` int(30) NOT NULL,
`title` varchar(50) NOT NULL,
`content` text NOT NULL,
`timestamp` varchar(30) NOT NULL,
`num` int(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ; 
