public function actionViewSoalQuiz($id)
{
$hasil = Quizsoal::model()->findAllByAttributes(array('id_quiz' => $id));
$soalkuis = new Quizsoal('search');
$soalkuis->id_quiz = $id;
$kosong = 0;
if ($_POST['Submit_jawaban']) {
if (count($_POST['jawaban']) < 1) {
echo "Anda belum menjawab soal satupun ";
} else {
$Jawaban = "";
$nomor = 1;
//var_dump($_POST['NomorSoal']);
// echo "*";
for ($i = 1; $i <= $_POST['NomorSoal']; $i++) {
if ($_POST['jawaban']["{$i}"] == NULL) {
$Jawaban .= "#";
$kosong += 1;
} else {
$Jawaban .= $_POST['jawaban']["{$i}"];
}
}
//echo $Jawaban;
$encode = Soal::model()->getJawaban($id);
//echo "<br>";
$count = 0;
$wrong = 0;
for ($i = 0; $i < $_POST['NomorSoal']; $i++) {
// echo $_POST['jawaban'][$i];
//echo $encode[$i]["jawaban"];
// echo "*";
if ($_POST['jawaban'][$i + 1] == $encode[$i]["jawaban"]) {
//secho "<br>", $_POST['jawaban']["$i"]," dan ",$encode[$i]["jawaban"];
$count += 1;
} else {
$wrong += 1;
}
}
//var_dump($encode);
}
}
//echo "<br>Anda benar : ",$count," dari ",$_POST['NomorSoal'], " soal";
$nilai = 100 / $_POST['NomorSoal'] * $count;
// echo "<br>",$nilai;
$name = Yii::app()->user->name;
$koneksi_server = mysqli_connect('localhost', 'root', '', 'toefl');
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_query($koneksi_server, "INSERT INTO t_grade(username,jawaban,grade)\n VALUES ('{$name}', '{$Jawaban}','{$nilai}')");
mysqli_close($koneksi_server);
//}
if (!isset($_POST['Submit_jawaban'])) {
$this->render('ViewSoalQuiz', array('model' => $soalkuis, 'hasil' => $hasil));
} else {
$this->render('HasilQuiz', array('wew' => $nilai, 'wow' => $kosong, 'waw' => $wrong, 'wuw' => $count));
}
}
