主题:[讨论]麻烦高手帮看下后台管理为什么不能登陆!什么地方出错了!
数据库中的Admin表中结构是:
CREATE TABLE `Admin` (
`AdminID` int(11) NOT NULL auto_increment, `AdminName` varchar(32) default NULL, `AdminPwd` varchar(64) default NULL, `AdminType` smallint(6) default '0', `AddTime` varchar(20) default NULL, `LastLoginTime` varchar(50) default '暂无登录', `LastLoginIP` varchar(50) default '暂无登录',
`NewsNum` int(11) default '0', `LoginNum` int(11) default '0', `UserName` varchar(20) default NULL, `UserSex` char(2) default NULL, `UserBirthday` varchar(10) default NULL, `UserEmail` varchar(50) default NULL, `UserQQ` varchar(10) default NULL, `UserTel` varchar(50) default NULL, `UserAddress` varchar(80) default NULL, `UserZip` varchar(6) default NULL, `UserInfo` longtext, PRIMARY KEY (`AdminID`), KEY `AdminUID` (`AdminName`), KEY `LoginNum` (`LoginNum`), KEY `NewsNum` (`NewsNum`)) TYPE=MyISAM AUTO_INCREMENT=5 ;
内有数据1条是:INSERT INTO `Admin` (`AdminID`, `AdminName`, `AdminPwd`, `AdminType`, `AddTime`, `LastLoginTime`, `LastLoginIP`, `NewsNum`, `LoginNum`, `UserName`, `UserSex`, `UserBirthday`, `UserEmail`, `UserQQ`, `UserTel`, `UserAddress`, `UserZip`, `UserInfo`) VALUES (3, 'admin', 'CB939D9EA1198112BF8EDCD343ED2A1D', 3, '2006-3-20 15:36:02', '2006-3-21 10:38:10', '127.0.0.1', 0, 1, 'admin', '男', '1983-2-29', 'whan530@163.com', '', '', '', '', '');
CREATE TABLE `Admin` (
`AdminID` int(11) NOT NULL auto_increment, `AdminName` varchar(32) default NULL, `AdminPwd` varchar(64) default NULL, `AdminType` smallint(6) default '0', `AddTime` varchar(20) default NULL, `LastLoginTime` varchar(50) default '暂无登录', `LastLoginIP` varchar(50) default '暂无登录',
`NewsNum` int(11) default '0', `LoginNum` int(11) default '0', `UserName` varchar(20) default NULL, `UserSex` char(2) default NULL, `UserBirthday` varchar(10) default NULL, `UserEmail` varchar(50) default NULL, `UserQQ` varchar(10) default NULL, `UserTel` varchar(50) default NULL, `UserAddress` varchar(80) default NULL, `UserZip` varchar(6) default NULL, `UserInfo` longtext, PRIMARY KEY (`AdminID`), KEY `AdminUID` (`AdminName`), KEY `LoginNum` (`LoginNum`), KEY `NewsNum` (`NewsNum`)) TYPE=MyISAM AUTO_INCREMENT=5 ;
内有数据1条是:INSERT INTO `Admin` (`AdminID`, `AdminName`, `AdminPwd`, `AdminType`, `AddTime`, `LastLoginTime`, `LastLoginIP`, `NewsNum`, `LoginNum`, `UserName`, `UserSex`, `UserBirthday`, `UserEmail`, `UserQQ`, `UserTel`, `UserAddress`, `UserZip`, `UserInfo`) VALUES (3, 'admin', 'CB939D9EA1198112BF8EDCD343ED2A1D', 3, '2006-3-20 15:36:02', '2006-3-21 10:38:10', '127.0.0.1', 0, 1, 'admin', '男', '1983-2-29', 'whan530@163.com', '', '', '', '', '');