Αρχικοποίηση εξέτασης 

1.

$n = 1; 

2.

$sql=""; 

3.

$union="";  

4.

while (isset($_SESSION['topic'][$n]) && $_SESSION['topic'][$n] != '') 

5.

 {         

6.

   

$sql .= $union ."(SELECT * FROM questions WHERE available = 1 AND topic_id= ".$_SESSION['topic'][$n]." AND 

 

difficulty IN (".$_SESSION['difficulties'].") AND RAND()<(SELECT ((".$_SESSION['res'][$n]."/COUNT(*))*10) FROM 

 

questions) ORDER BY RAND(".$_SESSION['seed'].") LIMIT ".$_SESSION['res'][$n].")"; 

7.

            $union=" UNION "; 

 

 

$n++; 

8.

} 

9.

$sql2 = $sql." ORDER BY RAND(".$_SESSION['seed'].")"; 

10.

//produce a list of the questions 

11.

$query02 = $dbconn->prepare($sql2); 

12.

$query02->execute(); 

13.

$rows02 = $query02->fetchAll(PDO::FETCH_ASSOC); 

 

 

                                          foreach 



$rows02                               $_SESSION['rem_questions']                                 id, 

$_SESSION['seed'] = rand(); 

 

$_SESSION['res'][$n] = 
round(($rows01['percentage'] / 100) * 
$rows['total_questions']); 

12