You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
100 lines
2.7 KiB
100 lines
2.7 KiB
<?php
|
|
|
|
require_once('../BDD/SqliteDb.php');
|
|
$db = new SqliteDb('o');
|
|
|
|
|
|
$numQuestion = $_GET['numQuestion'];
|
|
$numTp = $_GET['numTp'];
|
|
$numQuestionPrec = $numQuestion-1;
|
|
$test = 999;
|
|
|
|
$Correct = 'Correct';
|
|
$function = 'functionCorrect';
|
|
|
|
|
|
if(isset($_GET['des'])){
|
|
$numQuestion += 1;
|
|
$numQuestionPrec = $numQuestion-1;
|
|
}
|
|
|
|
if($numQuestion!=1){
|
|
|
|
$typeQuery = $db->prepare('SELECT type FROM Type WHERE numQuestion = ? AND numTp= ?');
|
|
$typeQuery->bindParam(1, $numQuestion);
|
|
$typeQuery->bindParam(2, $numTp);
|
|
$resultType = $typeQuery->execute();
|
|
$typeRow = $resultType->fetchArray();
|
|
|
|
$typeQuery = $db->prepare('SELECT type FROM Type WHERE numQuestion = ? AND numTp= ?');
|
|
$typeQuery->bindParam(1, $numQuestionPrec);
|
|
$typeQuery->bindParam(2, $numTp);
|
|
$resultType = $typeQuery->execute();
|
|
$type2Row = $resultType->fetchArray();
|
|
|
|
|
|
//----------
|
|
|
|
if($typeRow['type'] == 'query'){
|
|
$table = 'Correct';
|
|
$type = 'query';
|
|
}
|
|
else{
|
|
$table = 'FunctionCorrect';
|
|
$type = 'functionCorrect';
|
|
}
|
|
|
|
|
|
$sqliteQuery = $db->prepare('UPDATE '.$table.' SET numQuestion=? WHERE numQuestion=? AND numTp=?');
|
|
$sqliteQuery->bindParam(1, $test);
|
|
$sqliteQuery->bindParam(2, $numQuestion);
|
|
$sqliteQuery->bindParam(3, $numTp);
|
|
$result = $sqliteQuery->execute();
|
|
|
|
//---------
|
|
if($type2Row['type'] == 'query'){
|
|
$table2 = 'Correct';
|
|
$type2 = 'query';
|
|
}
|
|
else{
|
|
$table2 = 'FunctionCorrect';
|
|
$type2 = 'functionCorrect';
|
|
}
|
|
|
|
$sqliteQuery = $db->prepare('UPDATE '.$table2.' SET numQuestion=? WHERE numQuestion=? AND numTp=?');
|
|
$sqliteQuery->bindParam(1, $numQuestion);
|
|
$sqliteQuery->bindParam(2, $numQuestionPrec);
|
|
$sqliteQuery->bindParam(3, $numTp);
|
|
$resulti = $sqliteQuery->execute();
|
|
|
|
$sqliteQuery = $db->prepare('UPDATE Type SET type=? WHERE numQuestion=? AND numTp=?');
|
|
$sqliteQuery->bindParam(1, $type2);
|
|
$sqliteQuery->bindParam(2, $numQuestion);
|
|
$sqliteQuery->bindParam(3, $numTp);
|
|
$resulti = $sqliteQuery->execute();
|
|
|
|
|
|
//---------
|
|
|
|
$sqliteQuery = $db->prepare('UPDATE '.$table.' SET numQuestion=? WHERE numQuestion=? AND numTp=?');
|
|
|
|
$sqliteQuery->bindParam(1, $numQuestionPrec);
|
|
$sqliteQuery->bindParam(2, $test);
|
|
$sqliteQuery->bindParam(3, $numTp);
|
|
$resultp = $sqliteQuery->execute();
|
|
|
|
$sqliteQuery = $db->prepare('UPDATE Type SET type=? WHERE numQuestion=? AND numTp=?');
|
|
$sqliteQuery->bindParam(1, $type);
|
|
$sqliteQuery->bindParam(2, $numQuestionPrec);
|
|
$sqliteQuery->bindParam(3, $numTp);
|
|
$resulti = $sqliteQuery->execute();
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
//header("Location: index.php");
|
|
|
|
|