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 | ||
| 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 | - | $query=mysql_query("select * from tbl_soal where id_soal='$nomor' and knc_jawaban='$jawaban'");
|
| 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 | - | $query=mysql_query("select * from tbl_soal where id_soal='$nomor' and knc_jawaban='$jawaban'");
|
| 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> |
