网页的编写用PHP最方便。用php做了最简单的用户登录、创建的程序。
一、 MySQL的设计
MySQL设计了两个表:members和sex。两张表的创建语句分别是:
create table members (id int(4) NOT NULL auto_increment,
username varchar(65) NOT NULL default '',
password varchar(65) NOT NULL default '',
PRIMARY KEY (id));
后有增加了几个字段:
alter table members add firstname varchar(65);
alter table members add lastname varchar(65);
alter table members add email varchar(65);
alter table members add age varchar(65);
alter table members add sex_idint;
alter table members modify sex_idint(4);
alter table members modify ageint(4);
第二张表的创建语句:
create table sex (sex_id int primary key not null, sex varchar(20));
两张表的结构如下:
mysql>desc members;+-----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+----------------+
| id | int(4) | NO | PRI | NULL | auto_increment |
| username | varchar(65) | NO | | | |
| password | varchar(65) | NO | | | |
| firstname | varchar(65) | YES | | NULL | |
| lastname | varchar(6