php学生选课系统登陆代码,PHP基于B/S模式下的学生选课管理系统、源码分享

/*Navicat MySQL Data Transfer

Source Server : localhost_3306

Source Server Version : 50160

Source Host : localhost:3306

Source Database : phpxsxkglxt06

Target Server Type : MYSQL

Target Server Version : 50160

File Encoding : 65001

Date: 2018-05-14 14:39:11*/

SET FOREIGN_KEY_CHECKS=0;--------------------------------Table structure for `allusers`------------------------------

DROP TABLE IF EXISTS`allusers`;CREATE TABLE`allusers` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`username`VARCHAR(50) DEFAULT NULL,

`pwd`VARCHAR(50) DEFAULT NULL,

`cx`VARCHAR(50) DEFAULT ‘普通管理员‘,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;--------------------------------Records of allusers------------------------------

INSERT INTO `allusers` VALUES (‘2‘, ‘hsg‘, ‘hsg‘, ‘管理员‘, ‘2018-05-13 21:51:02‘);--------------------------------Table structure for `jiaoshixinxi`------------------------------

DROP TABLE IF EXISTS`jiaoshixinxi`;CREATE TABLE`jiaoshixinxi` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`gonghao`VARCHAR(50) DEFAULT NULL,

`xingming`VARCHAR(50) DEFAULT NULL,

`mima`VARCHAR(50) DEFAULT NULL,

`chushengnianyue`VARCHAR(50) DEFAULT NULL,

`shenfenzheng`VARCHAR(300) DEFAULT NULL,

`xingbie`VARCHAR(50) DEFAULT NULL,

`zhicheng`VARCHAR(50) DEFAULT NULL,

`zhaopian`VARCHAR(50) DEFAULT NULL,

`zhujiaokecheng`VARCHAR(50) DEFAULT NULL,

`dianhua`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(500) DEFAULT NULL,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;--------------------------------Records of jiaoshixinxi------------------------------

INSERT INTO `jiaoshixinxi` VALUES (‘8‘, ‘101‘, ‘陈小东‘, ‘101‘, ‘1973-03-24 20:32:07‘, ‘566316522189695666‘, ‘男‘, ‘教授‘, ‘uploadfile/1490358749eeml.jpg‘, ‘C语言‘, ‘86316662‘, ‘fdaf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `jiaoshixinxi` VALUES (‘9‘, ‘102‘, ‘许小敏‘, ‘102‘, ‘1983-03-24 20:32:42‘, ‘584984829665561‘, ‘男‘, ‘实习教授‘, ‘uploadfile/1490358778ja5u.jpg‘, ‘PHP‘, ‘13869566326‘, ‘fdfdaf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `jiaoshixinxi` VALUES (‘10‘, ‘103‘, ‘刘小华‘, ‘103‘, ‘1970-03-24 20:48:27‘, ‘854959295262626215‘, ‘男‘, ‘副教授‘, ‘uploadfile/1490359730e60n.jpg‘, ‘数据结构‘, ‘82166565‘, ‘fdff‘, ‘2018-05-13 21:51:02‘);INSERT INTO `jiaoshixinxi` VALUES (‘11‘, ‘104‘, ‘104‘, ‘104‘, ‘2018-05-14 01:22:51‘, ‘345454534543533333‘, ‘男‘, ‘请问‘, ‘uploadfile/1526232194sc3z.jpg‘, ‘PS‘, ‘65756756‘, ‘qweqweqe‘, ‘2018-05-14 01:23:21‘);--------------------------------Table structure for `kechengxinxi`------------------------------

DROP TABLE IF EXISTS`kechengxinxi`;CREATE TABLE`kechengxinxi` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`kechengbianhao`VARCHAR(50) DEFAULT NULL,

`kechengmingcheng`VARCHAR(300) DEFAULT NULL,

`xuefen`VARCHAR(50) DEFAULT NULL,

`xueshi`VARCHAR(50) DEFAULT NULL,

`kexuanrenshu`VARCHAR(50) DEFAULT NULL,

`renkejiaoshi`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(500) DEFAULT NULL,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

`skdd`VARCHAR(255) DEFAULT NULL,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;--------------------------------Records of kechengxinxi------------------------------

INSERT INTO `kechengxinxi` VALUES (‘5‘, ‘001‘, ‘标准C++基础‘, ‘100‘, ‘50‘, ‘60‘, ‘101‘, ‘fdafd‘, ‘2018-05-13 21:51:02‘, ‘1号楼301教室‘);INSERT INTO `kechengxinxi` VALUES (‘6‘, ‘002‘, ‘数据库基础‘, ‘100‘, ‘60‘, ‘50‘, ‘103‘, ‘fdafdf‘, ‘2018-05-13 21:51:02‘, ‘2号楼201室‘);INSERT INTO `kechengxinxi` VALUES (‘7‘, ‘131231‘, ‘234234‘, ‘100‘, ‘45‘, ‘50‘, ‘104‘, ‘45435345‘, ‘2018-05-14 01:24:38‘, ‘5435345‘);--------------------------------Table structure for `xuankejilu`------------------------------

DROP TABLE IF EXISTS`xuankejilu`;CREATE TABLE`xuankejilu` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`kechengbianhao`VARCHAR(50) DEFAULT NULL,

`kechengmingcheng`VARCHAR(300) DEFAULT NULL,

`xuefen`VARCHAR(50) DEFAULT NULL,

`xueshi`VARCHAR(50) DEFAULT NULL,

`renkejiaoshi`VARCHAR(50) DEFAULT NULL,

`xuankeren`VARCHAR(50) DEFAULT NULL,

`chengji`VARCHAR(50) DEFAULT NULL,

`pingyu`VARCHAR(500) DEFAULT NULL,

`beizhu`VARCHAR(500) DEFAULT NULL,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;--------------------------------Records of xuankejilu------------------------------

INSERT INTO `xuankejilu` VALUES (‘5‘, ‘001‘, ‘标准C++基础‘, ‘100‘, ‘50‘, ‘101‘, ‘001‘, ‘90‘, ‘fdfdf‘, ‘fdfdfa‘, ‘2018-05-13 21:51:02‘);INSERT INTO `xuankejilu` VALUES (‘6‘, ‘002‘, ‘数据库基础‘, ‘100‘, ‘60‘, ‘103‘, ‘003‘, ‘80‘, ‘fdfdf‘, ‘fdafdf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `xuankejilu` VALUES (‘7‘, ‘131231‘, ‘234234‘, ‘100‘, ‘45‘, ‘104‘, ‘123‘, ‘80‘, ‘ertertertert‘, ‘234234‘, ‘2018-05-14 01:25:01‘);--------------------------------Table structure for `xueshengxinxi`------------------------------

DROP TABLE IF EXISTS`xueshengxinxi`;CREATE TABLE`xueshengxinxi` (

`id`INT(11) NOT NULLAUTO_INCREMENT,

`xuehao`VARCHAR(50) DEFAULT NULL,

`mima`VARCHAR(50) DEFAULT NULL,

`xingming`VARCHAR(50) DEFAULT NULL,

`xingbie`VARCHAR(50) DEFAULT NULL,

`banji`VARCHAR(50) DEFAULT NULL,

`zhuanye`VARCHAR(50) DEFAULT NULL,

`xueyuan`VARCHAR(50) DEFAULT NULL,

`minzu`VARCHAR(50) DEFAULT NULL,

`jiguan`VARCHAR(50) DEFAULT NULL,

`chushengriqi`VARCHAR(50) DEFAULT NULL,

`ruxuenianfen`VARCHAR(50) DEFAULT NULL,

`zhaopian`VARCHAR(50) DEFAULT NULL,

`beizhu`VARCHAR(500) DEFAULT NULL,

`addtime`TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,PRIMARY KEY(`id`)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;--------------------------------Records of xueshengxinxi------------------------------

INSERT INTO `xueshengxinxi` VALUES (‘2‘, ‘001‘, ‘001‘, ‘吴明翰‘, ‘男‘, ‘16届计算机1班‘, ‘计算机编程‘, ‘信息学院‘, ‘汉‘, ‘浙江‘, ‘1995-03-24‘, ‘2018-05-13‘, ‘uploadfile/1490358843a175.jpg‘, ‘fafdf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `xueshengxinxi` VALUES (‘3‘, ‘002‘, ‘002‘, ‘林晓琴‘, ‘女‘, ‘16届计算机1班‘, ‘计算机编程‘, ‘信息学院‘, ‘汉‘, ‘苗江‘, ‘1995-03-01‘, ‘2018-05-13\r\n2016-07-01\r\n2017-02-01\r\n‘, ‘uploadfile/1490358866cfj9.jpg‘, ‘fafdf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `xueshengxinxi` VALUES (‘4‘, ‘003‘, ‘003‘, ‘林立行‘, ‘男‘, ‘17届化学2班‘, ‘化学‘, ‘化工学院‘, ‘满族‘, ‘北京‘, ‘1995-03-24‘, ‘2018-05-13‘, ‘uploadfile/14903598271bt6.jpg‘, ‘fafdf‘, ‘2018-05-13 21:51:02‘);INSERT INTO `xueshengxinxi` VALUES (‘7‘, ‘123‘, ‘123‘, ‘123‘, ‘男‘, ‘1班‘, ‘计算机‘, ‘理工‘, ‘123‘, ‘123213‘, ‘2018-05-14‘, ‘2018-05-14‘, ‘uploadfile/1526232229csjw.jpg‘, ‘234234234‘, ‘2018-05-14 01:23:51‘);