PHP ??? ?? ? ??? ???? ?????? ??
?????? ?? ??
? ??? ???????? ?? ??? ???? createtime(?? ??)? createip(?? ? IP), ????, ????? ?????. md5 ???? ??? ? ??????? ???? ?? ?? ??? ??? ????.
| id | username | userpwd | create time | createip | |
| int | varchar | varchar | int | int |
|
| 11 | 30 |
| 3211 | 11 | |
| ?? | ??? ?? | ???? | ?? ?? | IP ?? |
?? ???? ??? mysql? ?????
MySQL? ??? ? cmd? ?? mysql? ??? ? ????
?? ?? ??? ??? ?? ?? ??? ?????(window7? ?? ???????)
cmd? ???? OK
? ???? ??? ?????? ?????. ?? ???? ????? C ????? ????. D ????
(? MySQL? D ????? ???? ???? ?? ??? D:phpStudyMySQLbin???.)
??: ??? ???? ?????? ??? ??? ??? ??? ? ??? Ctrl+? ??? ? ????. V
???? cd D:phpStudyMySQLbin? ???? Enter? ???? MySQL ?? ??
mysql -hlocalhost -uroot -proot? ???? ??? ?????.
?? sql ?? ??? ? ????
??: ? ??? ? ?? ";"? ????
??????
??????? ???? ???? ?? ??????. ?? ???? ?? ????? ????? ?? ???. ??? mysql>? ??? ? Enter? ???? ??????? ????? ?????.
??? ?? ??? ???? ????? show tables? ?????.
??? ???? ??? ????? desc user? ?????.
??????? ???? ?? ???
DROP DATABASE IF EXISTS userdb;
CREATE DATABASE userdb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE userdb;
CREATE TABLE user(
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(30) DEFAULT NULL,
userpwd varchar(32) DEFAULT NULL,
createtime int(11) NOT NULL,
createip int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
insert into user(username,userpwd) values('admin','admin');?? ??: 1. ?????? userdb? ????? ???? ???? ?????.
2 userdb ??????? ???? ??? ??? utf8? ?????
3.
4. ????? ID ??, ??? ??, ????, ?? ? ??? IP ? 5?? ??? ????.
5. ???? ??? MyISAM?? ?????. ??? ???? utf8 ???.
6. ??? ?? ???? ????? ?? ?????
