ECTIVE_ITEM WHERE F_ID = $item";
$i = $this->select($sql);
if($i[0][0] == 1) //判断答案是否正确
return 1;
else
return 2;
}else{
$sql = "SELECT F_ID FROM EE_OBJECTIVE_ITEM WHERE F_ID_OBJECTIVE_INFO = $objid";
$sql .= " AND F_ITEM_IS_RIGHT = 1";
$i = $this->select($sql);
$arr = array();
foreach($i as $value) //重新组合正确答案数组
{
$arr[] = $value[F_ID];
}
if(count($arr) == count($item)) //判断选项是否和答案个数相同
{
foreach($item as $value) //循环判断选项是否正确
{
if(!in_array($value,$arr)) //判断选项是否正确
{
return 2;
}
}
return 1;
}else{
return 2;
}
}
}
/**
* 功能:提取所有客观题目信息
* 参数:$id题库ID
* 返回:数组
*/
public function GetObjListAll($id)
{
$sql = "SELECT * FROM EE_OBJECTIVE_INFO WHERE F_ID_DATABASE_INFO = $id";
$sql .= " ORDER BY F_OBJECTIVE_ORDER DESC";
return $this->select($sql);
}
/**
* 功能:提取所有主观题目信息
* 参数:$id题库ID
* 返回:数组
*/
public function GetSubListAll($id)
{
$sql = "SELECT * FROM EE_SUBJECTIVE_INFO WHERE F_ID_DATABASE_INFO = $id";
$sql .= " ORDER BY F_SUBJECTIVE_ORDER DESC";
return $this->select($sql);
}
/**
* 功能:提取题目的正确答案
* 参数:$id题目ID
* 返回:正确答案
*/
public function GetRight($id) {
$sql = "SELECT F_ID FROM EE_OBJECTIVE_ITEM WHERE F_ID = $id";
$r = $this->select($sql);
return $r[0][0];
}
}
?>