Show sourcecode
The following files exists in this folder. Click to view.
bacon-egg-pizza.php
cquiz.php
create-account.php
create-account111.php
create-quiz.php
create-quiz2.php
createaccount.php
delete-quiz.php
drop-rps-tables.php
legacy-code-rps.php
legacy-index.php
login.php
logincheck.php
newpassword-verify.php
newpassword.php
potential-code.txt
quiz-db-init.php
quizhub.php
quizhub2.php
results.php
rpsaccount-ajax-user-search.php
rpsaccount.php
rpsbetting-ajax-match-finder.php
rpsbetting.php
rpsbettingleaderboard.php
rpschangepassword.php
rpschangepassword.txt
rpsgame-ajax.php
rpsgame.php
rpsgameresults.php
rpshostnewgame.php
rpshub.php
rpsleaderboard.php
rpslib.php
rpslogin.php
rpsmaininclude.php
rpsproject/
rpsusersearch.php
table-init.php
verification.php
create-quiz.php
348 lines UTF-8 Windows (CRLF)
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348
<?php require('logincheck.php');
if($_SESSION['isadmin']!=1){
header("Location:quizhub.php");
die;
}
if (isset($_POST['quizname'])){
foreach($_POST as $x){
if($x==""){
echo "invalid input, try again";
break;
}
}
$cqname = $_POST['quizname'];
$_SESSION['cqname'] = $cqname;
$sql = "INSERT INTO qlist (qlname) VALUES (?)";
$stmt = $dbconn->prepare($sql);
$data = [$cqname];
$stmt->execute($data);
$sql = "SELECT * FROM qlist WHERE qlname='$cqname'";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute();
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$quizID = $res['listid'];
GLOBAL $quizID;
$_SESSION['cqid'] = $quizID;
}
$questions = ["q1","q2","q3","q4","q5"];
$answers = ["a1","a2","a3"];
foreach($questions as $q){
$tempQ = $_POST[$q];
$sql = "INSERT INTO qquestions (qlkey, qqname) VALUES ('$quizID',?)";
$stmt = $dbconn->prepare($sql);
$data = [$tempQ];
$stmt->execute($data);
$sql = "SELECT * FROM qquestions WHERE qqname ='$tempQ'";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute();
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$questionID = $res['questionid'];
}
$answerList = [];
foreach($answers as $a){
array_push($answerList,$_POST[$q.$a]);
}
$tempcans = $q."c";
$qAns = $_POST[$tempcans];
array_push($answerList,$qAns);
$sql = "INSERT INTO qanswers (qqkey, ans1, ans2, ans3, correct) VALUES ('$questionID',?,?,?,?)";
$stmt = $dbconn->prepare($sql);
$stmt->execute($answerList);
}
/*
echo $quizID;
print_r($_POST);
if (isset($_POST['questionName'])){
$newq = $_POST['questionName'];
$qamount = $_POST['qamount'];
print_r($_POST);
$quizID = $_SESSION['cqid'];
$sql = "INSERT INTO qquestions (qlkey, qqname) VALUES (?,?)";
$stmt = $dbconn->prepare($sql);
$data = [$quizID, $newq];
$stmt->execute($data);
echo $newq;
$sql = "SELECT * FROM qquestions WHERE qqname ='$newq'";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute();
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$questionID = $res['questionID'];
echo $questionID;
}
echo '<form action="" method="POST">';
$qcount = 0;
print_r($_POST);
while ($qcount<=$qamount){
echo '<input type="text" name="'.$qcount.'"><input type="number" min="0" max="1" name="isCorrect'.$qcount.'">';
}
echo '<input type="submit"></form>';
if (isset($_POST[$qcount])){
$newa = $_POST[$qcount];
$iscorrect = $_POST['qamount'];
}
}
*/
}
?>
<!--
<html>
<h1>Skapa ett quiz!</h1>
<form action="" method="POST">
<table>
<tr>
<td>
namn
</td>
<td>
<input type="text" name="quizname">
</td>
</tr>
<tr><td><input type="submit">
</table>
</form>
<form action="" method="POST">
<input type="text" name="questionName"><input type="number" min="1" name="qamount">
<input type="submit">
</form>
-->
<?php /*
echo $quizID;
if (isset($_POST['questionName'])){
$newq = $_POST['questionName'];
$qamount = $_POST['qamount'];
$sql = "INSERT INTO qquestions (qlkey, qqname) VALUES ('$quizID',?)";
$stmt = $dbconn->prepare($sql);
$data = [$newq];
$stmt->execute($data);
$sql = "SELECT * FROM qquestions WHERE qqname ='$newq'";
$stmt = $dbconn -> prepare($sql);
$stmt -> execute();
while($res = $stmt->fetch(PDO::FETCH_ASSOC)){
$questionID = $res['akey'];
}
echo '<form action="" method="POST">';
$qcount = 0;
while ($qcount<=$qamount){
echo '<input type="text" name="'.$qcount.'"><input type="number" min="0" max="1" name="isCorrect'.$qcount.'">';
}
echo '<input type="submit"></form>';
if (isset($_POST[$qcount])){
$newa = $_POST[$qcount];
$iscorrect = $_POST['qamount'];
}
}
*/
?>
<h1>skapa quiz</h1>
<form action="" method="POST">
<table>
<tr>
<td>
namn
</td>
<td>
<input type="text" name="quizname">
</td>
</tr>
<tr>
<td>
fråga 1
</td>
<td>
<input type="text" name="q1">
</td>
</tr>
<tr>
<td>
svar 1
</td>
<td>
<input type="text" name="q1a1">
</td>
</tr>
<tr>
<td>
svar 2
</td>
<td>
<input type="text" name="q1a2">
</td>
</tr>
<tr>
<td>
svar 3
</td>
<td>
<input type="text" name="q1a3">
</td>
</tr>
<tr><td>korrekt svar</td>
<td><input type="text" name="q1c"></td></tr>
<tr>
<td>
fråga 2
</td>
<td>
<input type="text" name="q2">
</td>
</tr>
<tr>
<td>
svar 1
</td>
<td>
<input type="text" name="q2a1">
</td>
</tr>
<tr>
<td>
svar 2
</td>
<td>
<input type="text" name="q2a2">
</td>
</tr>
<tr>
<td>
svar 3
</td>
<td>
<input type="text" name="q2a3">
</td>
</tr>
<tr><td>korrekt svar</td>
<td><input type="text" name="q2c"></td></tr>
<tr>
<td>
fråga 3
</td>
<td>
<input type="text" name="q3">
</td>
</tr>
<tr>
<td>
svar 1
</td>
<td>
<input type="text" name="q3a1">
</td>
</tr>
<tr>
<td>
svar 2
</td>
<td>
<input type="text" name="q3a2">
</td>
</tr>
<tr>
<td>
svar 3
</td>
<td>
<input type="text" name="q3a3">
</td>
</tr>
<tr>
<tr><td>korrekt svar</td>
<td><input type="text" name="q3c"></td></tr>
<td>
fråga 4
</td>
<td>
<input type="text" name="q4">
</td>
</tr>
<tr>
<td>
svar 1
</td>
<td>
<input type="text" name="q4a1">
</td>
</tr>
<tr>
<td>
svar 2
</td>
<td>
<input type="text" name="q4a2">
</td>
</tr>
<tr>
<td>
svar 3
</td>
<td>
<input type="text" name="q4a3">
</td>
</tr>
<tr><td>korrekt svar</td>
<td><input type="text" name="q4c"></td></tr>
<tr>
<td>
fråga 5
</td>
<td>
<input type="text" name="q5">
</td>
</tr>
<tr>
<td>
svar 1
</td>
<td>
<input type="text" name="q5a1">
</td>
</tr>
<tr>
<td>
svar 2
</td>
<td>
<input type="text" name="q5a2">
</td>
</tr>
<tr>
<td>
svar 3
</td>
<td>
<input type="text" name="q5a3">
</td>
</tr>
<tr><td>korrekt svar</td>
<td><input type="text" name="q5c"></td></tr>
</table>
<button type="submit">skapa</button>
</form>
</html>