简易员工信息管理系统php 1.0版本

//设计数据库 create database usersDb; 管理员表: admin create table admin( id int primary key, password varchar(64) not null, name varchar(32) not null ); 用户表 create table users( id int primary key auto_increment, name varchar(64) not null, grade tinyint,/*1表示 1级工*/ email varchar(64) not null, saray float ); insert into users(name,grade,email,saray)values('shunping1',1,'xiaohong1@yahoo.com',2000); insert into users(name,grade,email,saray)values('shunping2',2,'xiaohong2@yahoo.com',3000); insert into users(name,grade,email,saray)values('shunping3',3,'xiaohong3@yahoo.com',4000); insert into users(name,grade,email,saray)values('shunping4',4,'xiaohong4@yahoo.com',5000); insert into users(name,grade,email,saray)values('shunping5',5,'xiaohong5@yahoo.com',6000); insert into users(name,grade,email,saray)values('shunping6',6,'xiaohong6@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping7',7,'xiaohong7@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping8',8,'xiaohong8@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping9',9,'xiaohong9@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping10',10,'xiaohong10@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping11',11,'xiaohong11@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping12',12,'xiaohong12@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping13',13,'xiaohong13@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping14',14,'xiaohong14@yahoo.com',7000); insert into users(name,grade,email,saray)values('shunping15',15,'xiaohong15@yahoo.com',7000); insert into admin values(1000,md5('admin'),'管理员'); 错误处理： Warning: Cannot modify header information - headers already sent by (output started at C:\AppServ\www\erpManager\loginProcess.php:2) in C:\AppServ\www\erpManager\loginProcess.php on line 31 打开 windows目录找到php.ini 查找到output_buffering = Off改为On即可 然后重新启动 php服务器 //重复插入数据 insert into users(name,grade,email,saray) select name,grade,email,saray from users;