Rabu, 28 Agustus 2013

PHP Indonesia - Facebook: [ASK] misal : nilai esai dan pilihan ganda diakum...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Marketing Mobile Apps

This online course focuses on marketing efforts that will increase your app's exposure and establish a mobile app marketing plan. Enroll today for $99.
From our sponsors
[ASK] misal : nilai esai dan pilihan ganda diakum...
Aug 28th 2013, 12:31, by Albet Sagan S

Albet Sagan S 12:31pm Aug 28
[ASK]

misal :
nilai esai dan pilihan ganda diakumulasikan... ex:esai dapet nilai 70 pilihan ganda dapet nilai 80 umpama esai bobotnya 70%,pilihan ganda 30%, berarti kalau diakumulasikan esai 70 x 30% = 21, pilihan ganda 80 x 70%= 54..jadi nilai akhir hasil akumulasi 21+54= 75.

ada yang bisa implementasinya dalam PHP? tolong bantu saya..

Ruli Armando 12:34pm Aug 28
itu sudah tau rumusnya, seharusnya bisa bikin sendiri...

Albet Sagan S 12:35pm Aug 28
Ruli Armando : saya buruk mas dalam algoritmanya di implementasikan ke PHP.. tolong bantuanya..

Rizky Darmawan 12:37pm Aug 28
$nganu = (avg_esai * 70) / 100;
$ngene = (avg_pg * 30) / 100;
$total = $nganu + $ngene;

Albet Sagan S 12:44pm Aug 28
contohya kayak nanti tampilanya

Albet Sagan S 12:44pm Aug 28
Rizky Darmawan : oke bentar tak coba e

Albet Sagan S 12:52pm Aug 28
databasenya kayak gini mas:

Rizky Darmawan 12:55pm Aug 28
cara narik dari db sudah bisa?
kalo sudah, nilai dapet dari mana kalo yg diketahui itu benar/salah/tidak_dikerjakan saja? Apa masing2 dari soal itu point nya 1?
db itu utk PG atau essay? atau jadi satu?

Albet Sagan S 12:57pm Aug 28
ini kan ada pilihan ganda dan isi

Albet Sagan S 12:59pm Aug 28
ini srip untuk exsekusi nilainya saya dapat dari googling

//jika ada pilihan ganda dan ada esay
if (!empty($pilganda) AND !empty($esay)){

//jika ada inputan soal pilganda
if(!empty($_POST['soal_pilganda'])){
$benar = 0;
$salah = 0;
foreach($_POST['soal_pilganda'] as $key => $value){
$cek = mysql_query("SELECT * FROM quiz_pilganda WHERE id_quiz=$key");
while($c = mysql_fetch_array($cek)){
$jawaban = $c['kunci'];
}
if($value==$jawaban){
$benar++;
}else{
$salah++;
}
}

$jumlah = $_POST['jumlahsoalpilganda'];
$tidakjawab = $jumlah - $benar - $salah;
$persen = $benar / $jumlah;
$hasil = $persen * 100;

mysql_query("INSERT INTO nilai (id_tq, id_siswa, benar, salah, tidak_dikerjakan,persentase)
VALUES ('$_POST[id_topik]','$_SESSION[idsiswa]','$benar','$salah','$tidakjawab','$hasil')");

}
elseif (empty($_POST['soal_pilganda'])){
$jumlah = $_POST['jumlahsoalpilganda'];
mysql_query("INSERT INTO nilai (id_tq, id_siswa, benar, salah, tidak_dikerjakan,persentase)
VALUES ('$_POST[id_topik]','$_SESSION[idsiswa]','0','0','$jumlah','0')");
}

//jika ada inputan soal esay
if(!empty($_POST['soal_esay'])){
foreach($_POST['soal_esay'] as $key2 => $value){
$jawaban = $value;
$cek = mysql_query("SELECT * FROM quiz_esay WHERE id_quiz=$key2");
while($data = mysql_fetch_array($cek)){
mysql_query("INSERT INTO jawaban(id_tq,id_quiz,id_siswa,jawaban)
VALUES('$_POST[id_topik]','$data[id_quiz]','$_SESSION[idsiswa]','$jawaban')");

}

}

}
elseif (empty($_POST['soal_esay'])){
mysql_query("INSERT INTO jawaban(id_tq,id_quiz,id_siswa,jawaban)
VALUES('$_POST[id_topik]','$data[id_quiz]','$_SESSION[idsiswa]','')");
}
header ('location:home');
}

//jika soal hanya esay
if (empty($pilganda) AND !empty($esay)){
//jika ada inputan soal esay
if(!empty($_POST['soal_esay'])){
foreach($_POST['soal_esay'] as $key2 => $value){
$jawaban = $value;
$cek = mysql_query("SELECT * FROM quiz_esay WHERE id_quiz=$key2");
while($data = mysql_fetch_array($cek)){
mysql_query("INSERT INTO jawaban(id_tq,id_quiz,id_siswa,jawaban)
VALUES('$_POST[id_topik]','$data[id_quiz]','$_SESSION[idsiswa]','$jawaban')");

}

}

}
elseif (empty($_POST['soal_esay'])){
mysql_query("INSERT INTO jawaban(id_tq,id_quiz,id_siswa,jawaban)
VALUES('$_POST[id_topik]','$data[id_quiz]','$_SESSION[idsiswa]','')");
}
header ('location:home');
}

//jika soal hanya pilihan ganda
if (!empty($pilganda) AND empty($esay)){
//jika ada inputan soal pilganda
if(!empty($_POST['soal_pilganda'])){
$benar = 0;
$salah = 0;
foreach($_POST['soal_pilganda'] as $key => $value){
$cek = mysql_query("SELECT * FROM quiz_pilganda WHERE id_quiz=$key");
while($c = mysql_fetch_array($cek)){
$jawaban = $c['kunci'];
}
if($value==$jawaban){
$benar++;
}else{
$salah++;
}
}

$jumlah = $_POST['jumlahsoalpilganda'];
$tidakjawab = $jumlah - $benar - $salah;
$persen = $benar / $jumlah;
$hasil = $persen * 100;

mysql_query("INSERT INTO nilai (id_tq, id_siswa, benar, salah, tidak_dikerjakan,persentase)
VALUES ('$_POST[id_topik]','$_SESSION[idsiswa]','$benar','$salah','$tidakjawab','$hasil')");

}
elseif (empty($_POST['soal_pilganda'])){
$jumlah = $_POST['jumlahsoalpilganda'];
mysql_query("INSERT INTO nilai (id_tq, id_siswa, benar, salah, tidak_dikerjakan,persentase)
VALUES ('$_POST[id_topik]','$_SESSION[idsiswa]','0','0','$jumlah','0')");
}
header ('location:home');
}

Albet Sagan S 1:00pm Aug 28
saya ingin masukkan nilainya totalnya sripnya disini :

Albet Sagan S 1:01pm Aug 28
sript tabelnya kayak gini :

case "nilaisiswa":
if ($_SESSION[leveluser]=='siswa'){
$quiz_pilganda = mysql_query("SELECT * FROM quiz_pilganda WHERE id_tq = '$_GET[id_topik]'");
$quiz_esay = mysql_query("SELECT * FROM quiz_esay WHERE id_tq = '$_GET[id_topik]'");
$c_pilganda = mysql_num_rows($quiz_pilganda);
$c_esay = mysql_num_rows($quiz_esay);

if (!empty($c_pilganda) AND !empty($c_esay)){
$pilganda = mysql_query("SELECT * FROM nilai WHERE id_tq = '$_GET[id_topik]' AND id_siswa = '$_SESSION[idsiswa]'");
$cek_pilganda = mysql_num_rows($pilganda);
$esay = mysql_query("SELECT * FROM nilai_soal_esay WHERE id_tq = '$_GET[id_topik]' AND id_siswa = '$_SESSION[idsiswa]'");
$cek_esay = mysql_num_rows($esay);

if (!empty($cek_pilganda) AND !empty($cek_esay)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
$n_esay = mysql_fetch_array($esay);
echo "<tr><td>Tugas Pilihan Ganda</td><td>$n_pilganda[persentase]</td></tr>
<tr><td>Tugas Essay</td><td>$n_esay[nilai]</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}
elseif (empty($cek_pilganda) AND !empty($cek_esay)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
$n_esay = mysql_fetch_array($esay);
echo "<tr><td>Tugas Pilihan Ganda</td><td>Anda belum mengerjakan</td></tr>
<tr><td>Tugas Essay</td><td>$n_esay[nilai]</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}
elseif (!empty($cek_pilganda) AND empty($cek_esay)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
$n_esay = mysql_fetch_array($esay);
echo "<tr><td>Tugas Pilihan Ganda</td><td>$n_pilganda[persentase]</td></tr>
<tr><td>Tugas Essay</td><td>Belum di koreksi</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}
elseif (empty($cek_pilganda) AND empty($cek_esay)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
$n_esay = mysql_fetch_array($esay);
echo "<tr><td>Tugas Pilihan Ganda</td><td>Anda Belum mengerjakan</td></tr>
<tr><td>Tugas Essay</td><td>Anda Belum mengerjakan</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}

}
elseif (empty($c_pilganda) AND !empty($c_esay)){
$esay = mysql_query("SELECT * FROM nilai_soal_esay WHERE id_tq = '$_GET[id_topik]' AND id_siswa = '$_SESSION[idsiswa]'");
$cek_esay = mysql_num_rows($esay);
//jika nilai tidak kosong
if (!empty($cek_esay)){

echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_esay = mysql_fetch_array($esay);
echo "<tr><td>Tugas Essay</td><td>$n_esay[nilai]</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";

}
elseif (empty($cek_esay)) {
$kerjakan = mysql_query("SELECT * FROM siswa_sudah_mengerjakan WHERE id_tq='$_GET[id_topik]' AND id_siswa = '$_SESSION[idsiswa]'");
$c_kerjakan = mysql_num_rows($kerjakan);
if (!empty($c_kerjakan)){
$cek_kerjakan = mysql_fetch_array($kerjakan);
if ($cek_kerjakan['dikoreksi']=='B'){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
echo "<tr><td>Tugas Essay</td><td>Belum Dikoreksi</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";

}
elseif (empty($c_kerjakan)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
echo "<tr><td>Tugas Essay</td><td>Anda belum mengerjakan</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";

}
}
}

}
elseif (!empty($c_pilganda) AND empty($c_esay)){
$pilganda = mysql_query("SELECT * FROM nilai WHERE id_tq = '$_GET[id_topik]' AND id_siswa = '$_SESSION[idsiswa]'");
$cek_pilganda = mysql_num_rows($pilganda);
if (!empty($cek_pilganda)){
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
echo "<tr><td>Tugas Pilihan Ganda</td><td>$n_pilganda[persentase]</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}
else {
echo"<br><b class='judul'>Nilai Anda</b><br><p class='garisbawah'></p>
<table>
<tr><th>Deskripsi Tugas/Quiz </th><th>Nilai</th></tr>";
$n_pilganda = mysql_fetch_array($pilganda);
echo "<tr><td>Tugas Pilihan Ganda</td><td>Anda Belum mengerjakan</td></tr>
</table>
<p class='garisbawah'></p><input type=button class='tombol' value='Kembali' onclick=self.history.back()>";
}
}
elseif (!empty($c_pilganda) AND !empty($c_esay)){
echo "<script>window.alert('Belum ada Nilai di tugas/quiz ini.');
window.location=(href='?module=nilai')</script>";
}
}
break;

Albet Sagan S 1:02pm Aug 28
itu berarti databasenya di tambah juga ya?

Albet Sagan S 1:16pm Aug 28
Rizky Darmawan : bagaimana mas?

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar