需要用到两张表:paper和questions
CREATE TABLE `paper` (
`Id` int(11) NOT NULL auto_increment,
`UserId` int(10) NOT NULL,
`SingleChoice` varchar(150) default NULL,
`MultipleChoice` varchar(150) default NULL,
`TfChoice` varchar(150) default NULL,
`Score` float(53,0) NOT NULL,
`Answer` varchar(350) default NULL,
`CreateDate` datetime NOT NULL,
`Version` varchar(4) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `questions` (
`Id` int(11) NOT NULL auto_increment,
`IsApproved` varchar(1) NOT NULL,
`CreateDate` datetime NOT NULL,
`CreateUser` int(10) NOT NULL,
`Title` varchar(200) default NULL,
`Items` varchar(600) default NULL,
`Result` char(10) default NULL,
`EnterpristId` int(10) NOT NULL,
`CreateUserName` varchar(50) default NULL,
`Cate` int(10) NOT NULL,
`IsCommittee` varchar(1) NOT NULL,
`Version` varchar(4) default NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;
单选:A/B/C/D对应0、1、2、3
多选:A/B/C/D对应1、2、4、8 (多选每个选项的Value值准备使用2的几次方)然后求多个选项的和作为最后结果
判断:对、错对应1、0
public function paper(){
//权限判断
if($_SESSION[C('USER_AUTH_KEY')]['UserType']== 1 || $_SESSION[C('USER_AUTH_KEY')]['UserType']== 2){
}else{
exit('没有权限访问');
}
$times = M('Paper')->