SHOW:
|
|
- or go back to the newest paste.
1 | <body bgcolor="#99CC33"> | |
2 | <?php | |
3 | include "config/koneksi.php"; | |
4 | include "config/library.php"; | |
5 | echo '<pre>';var_dump($_POST);echo '</pre>'; | |
6 | if(isset($_POST['submit'])){ | |
7 | $active=1; | |
8 | $pilihan=$_POST["pilihan"]; | |
9 | $id_soal=$_POST["id"]; | |
10 | $jumlah=$_POST['jumlah']; | |
11 | ||
12 | $score=0; | |
13 | $benar=0; | |
14 | $salah=0; | |
15 | $kosong=0; | |
16 | ||
17 | for ($i=0;$i<$jumlah;$i++){ | |
18 | //id nomor soal | |
19 | $nomor=$id_soal[$i]; | |
20 | echo "<br/>no: $nomor; jawaban:{$pilihan[$nomor]}"; | |
21 | //jika user tidak memilih jawaban | |
22 | if (empty($pilihan[$nomor])){ | |
23 | $kosong++; | |
24 | echo "<br/>Pilihan kosong"; | |
25 | }else{ | |
26 | //jawaban dari user | |
27 | $jawaban=$pilihan[$nomor]; | |
28 | $sql="select * from tbl_soal where id_soal='$nomor' and knc_jawaban='$jawaban'"; | |
29 | //cocokan jawaban user dengan jawaban di database | |
30 | $query=mysql_query($sql); | |
31 | echo "<br/>sql={$sql}"; | |
32 | $cek=mysql_num_rows($query); | |
33 | echo " |cek=".$cek; | |
34 | if($cek){ | |
35 | //jika jawaban cocok (benar) | |
36 | $benar++; | |
37 | }else{ | |
38 | //jika salah | |
39 | $salah++; | |
40 | } | |
41 | ||
42 | } | |
43 | /*RUMUS | |
44 | Jika anda ingin mendapatkan Nilai 100, berapapun jumlah soal yang ditampilkan | |
45 | hasil= 100 / jumlah soal * jawaban yang benar | |
46 | */ | |
47 | ||
48 | $result=mysql_query("select * from tbl_soal WHERE aktif='Y'"); | |
49 | $jumlah_soal=mysql_num_rows($result); | |
50 | echo "<br/>jumlah soal={$jumlah_soal}"; | |
51 | $score = 100/$jumlah_soal*$benar; | |
52 | $hasil = number_format($score,1); | |
53 | echo "<br/>hasil =$hasil"; | |
54 | } | |
55 | } | |
56 | /*submit botton manual*/ | |
57 | ||
58 | if(isset($_POST['submit1'])){ | |
59 | $active=1; | |
60 | $pilihan=$_POST["pilihan"]; | |
61 | $id_soal=$_POST["id"]; | |
62 | $jumlah=$_POST['jumlah']; | |
63 | echo "<h3>MANUAL</h3>"; | |
64 | $score=0; | |
65 | $benar=0; | |
66 | $salah=0; | |
67 | $kosong=0; | |
68 | ||
69 | for ($i=0;$i<$jumlah;$i++){ | |
70 | //id nomor soal | |
71 | $nomor=$id_soal[$i]; | |
72 | echo "<br/>no:$nomor"; | |
73 | //jika user tidak memilih jawaban | |
74 | if (empty($pilihan[$nomor])){ | |
75 | $kosong++; | |
76 | echo "<br/>tidak ada pilihan"; | |
77 | }else{ | |
78 | //jawaban dari user | |
79 | $jawaban=$pilihan[$nomor]; | |
80 | echo "<br/>jawaban: $jawaban"; | |
81 | //cocokan jawaban user dengan jawaban di database | |
82 | $sql="select * from tbl_soal where id_soal='$nomor' and knc_jawaban='$jawaban'"; | |
83 | $query=mysql_query($sql); | |
84 | echo "<br/>sql=$sql"; | |
85 | $cek=mysql_num_rows($query); | |
86 | echo " cek=$cek"; | |
87 | if($cek){ | |
88 | //jika jawaban cocok (benar) | |
89 | $benar++; | |
90 | }else{ | |
91 | //jika salah | |
92 | $salah++; | |
93 | } | |
94 | ||
95 | } | |
96 | /*RUMUS | |
97 | Jika anda ingin mendapatkan Nilai 100, berapapun jumlah soal yang ditampilkan | |
98 | hasil= 100 / jumlah soal * jawaban yang benar | |
99 | */ | |
100 | ||
101 | $result=mysql_query("select * from tbl_soal WHERE aktif='Y'"); | |
102 | $jumlah_soal=mysql_num_rows($result); | |
103 | echo "<br/>jumlah soal={$jumlah_soal}"; | |
104 | $score = 100/$jumlah_soal*$benar; | |
105 | $hasil = number_format($score,1); | |
106 | echo "<br/>hasil: $hasil"; | |
107 | } | |
108 | } | |
109 | ||
110 | if(!isset($active)){ die('tidak ada proses terjadi<pre>'.print_r($_REQUEST,1)); } | |
111 | ||
112 | //Lakukan Pengecekan Data dalam Database | |
113 | $cek=mysql_num_rows(mysql_query("SELECT id_user FROM tbl_nilai WHERE id_user='$_SESSION[iduser]'")); | |
114 | if ($cek < 1) { | |
115 | //Pemberian kondisi lulus/ tidak lulus | |
116 | $qry2=mysql_query("SELECT nilai_min FROM tbl_pengaturan_ujian"); | |
117 | $q2=mysql_fetch_array($qry2); | |
118 | $ceknilai= $q2['nilai_min']; | |
119 | if ($hasil >= $ceknilai) { | |
120 | //Lakukan Penyimpanan Kedalam Database | |
121 | $iduser= ucwords($_SESSION['iduser']); | |
122 | mysql_query("INSERT INTO tbl_nilai (id_user,benar,salah,kosong,score,tanggal,keterangan) Values ('$iduser','$benar','$salah','$kosong','$hasil','$tgl_sekarang','Lulus')"); | |
123 | }else { | |
124 | //Lakukan Penyimpanan Kedalam Database | |
125 | $iduser= ucwords($_SESSION['iduser']); | |
126 | mysql_query("INSERT INTO tbl_nilai (id_user,benar,salah,kosong,score,tanggal,keterangan) Values ('$iduser','$benar','$salah','$kosong','$hasil','$tgl_sekarang','Tidak Lulus')"); | |
127 | } | |
128 | } | |
129 | ||
130 | //Menampilkan Hasil Ujian Kompetensi | |
131 | $username= ucwords($_SESSION['username']); | |
132 | echo "<h3 style='border:0';>Selamat <u>$username</u> Sudah Selesai Dalam Mengerjakan Tes</h3>"; | |
133 | echo "<br><br><br><div align='center'> | |
134 | <table><tr><th colspan=3>Hasil Tes Anda</th></tr> | |
135 | <tr><td><b>Nilai anda </td><td>: $hasil</b></td>"; | |
136 | $qry=mysql_query("SELECT nilai_min FROM tbl_pengaturan_ujian"); | |
137 | $q=mysql_fetch_array($qry); | |
138 | $cek= $q['nilai_min']; | |
139 | if ($hasil >= $cek) { | |
140 | echo "<td rowspan='4'><h1>Lulus</h1></td></tr>"; | |
141 | }else { | |
142 | echo "<td rowspan='4'><h1>Tidak Lulus</h1></td></tr>"; | |
143 | } | |
144 | echo " | |
145 | <tr><td>Jumlah Jawaban Benar</td><td> : $benar </td></tr> | |
146 | <tr><td>Jumlah Jawaban Salah</td><td> : $salah</td></tr> | |
147 | <tr><td>Jumlah Jawaban Kosong</td><td>: $kosong</td></tr> | |
148 | </table></div>"; | |
149 | ?> | |
150 | ||
151 | </body> |