Jumat, 27 September 2013

PHP Indonesia - Facebook: gan, kira2 ne kenapa yea gk mau ditampilkan nilai ...

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/ 
Want free Kindle ebooks?

Sign up to receive the best freebie Kindle ebook deals in your email every day.
From our sponsors
gan, kira2 ne kenapa yea gk mau ditampilkan nilai ...
Sep 27th 2013, 13:50, by Ridha Rira

Ridha Rira 1:50pm Sep 27
gan, kira2 ne kenapa yea gk mau ditampilkan nilai dan matakuliahnya ...

<div id="content">
<?php
$query = mysql_query("select m.nm_mk, p.nama_prodi from prodi p, matkul m where p.kd_prodi=m.kd_prodi and p.kd_prodi");
$data = mysql_fetch_array($query);
?>
<h2>Laporan Penilaian</h2>
<form id="form1" name="form1" method="post" action="">
<p>&nbsp;</p>
<table border="0" cellpadding="0" cellspacing="0" id="id-form">
<tr>
<th valign="top"><div align="left"><span class="style15">Prodi</span></div></th>
<td><div align="left"><span class="style15"> :</span></div></td>
<td><input name="kd_prodi" type="text" id="kd_prodi" disabled="disable" value="<?php echo $data['nama_prodi']; ?>" /></td>
<td></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<th><div align="left"><span class="style15">Matakuliah</span></div></th>
<td><div align="left"><span class="style15"> :</span></div></td>
<td><select name="kd_mk" size="1" id="kd_mk"">
<option value="0" selected="selected">-- Pilih Matakuliah --</option>
<?php $pelajaran=mysql_query("select nm_mk from matkul order by nm_mk asc");
while($row2=mysql_fetch_array($pelajaran)){
?>
<option value="<?php echo $row2['kd_mk'];?>"><?php echo $row2['nm_mk'];?></option>
<?php
}
?>
</select></td>
<td></td>
</tr>
<tr>
<th><div align="left"><span class="style15">Semester</span></div></th>
<td><div align="left"><span class="style15">:</span></div></td>
<td><label>
<input name="semester" type="text" id="semester" />
</label>
</form></td>
<td></td>
</tr>
<tr>
<th><div align="left"><span class="style15">Kelas</span></div></th>
<td><div align="left"><span class="style15">:</span></div></td>
<td><select name="kelas" size="1" id="kelas">
<option value="" selected="selected">-- Pilih Kelas--</option>
<option value="A">A</option>
<option value="B">B</option>
</select></td>
<td></td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<th>&nbsp;</th>
<td valign="top">&nbsp;</td>
<td valign="top"><strong>
</strong>
<input type="submit" name="submit" value="Submit" class="form-submit" />
</form>
<td></td>
</tr>
</table>
<p>&nbsp;</p>
<div id="content-table-inner2">
<table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000" id="product-table2">
<tr>
<th width="39" class="table-header-repeat line-left minwidth-1"><a href="">No</a></th>
<th width="49" class="table-header-repeat line-left minwidth-1"><a href="">NIM</a></th>
<th width="44" class="table-header-repeat line-left minwidth-1"><a href="">Nama Mahasiswa</a> </th>
<th width="44" class="table-header-repeat line-left minwidth-1"><a href="">Kode</a></th>
<th width="116" class="table-header-repeat line-left minwidth-1"><a href="">Nama MataKuliah</a></th>
<th width="44" class="table-header-repeat line-left minwidth-1"><a href="">Prodi</a></th>
<th width="80" class="table-header-repeat line-left minwidth-1"><a href="">Semester</a></th>
<th width="82" class="table-header-repeat line-left minwidth-1"><a href="">Kelas</a></th>
<th width="62" class="table-header-repeat line-left minwidth-1"><a href="">Nilai</a></th>
</tr>
<?php
if(isset($_POST['submit'])){
$kd_mk = $_POST['kd_mk'];
$semester = $_POST['semester'];
$kelas = $_POST['kelas'];
$view=mysql_query("SELECT m.nim, m.nama, m.kelas, p.nama_prodi,k.kd_mk, k.nm_mk, k.semester, n.huruf_mutu
from transkip_nilai n, mhs m, matkul k, prodi p where p.kd_prodi=n.kd_prodi and p.kd_prodi=k.kd_prodi and p.kd_prodi=m.kd_prodi and k.kd_mk=n.kd_mk and m.nim=n.nim and k.kd_mk ='".$kd_mk."'and k.semester ='".$semester."' and m.kelas ='".$kelas."'");
$i=1; while($row=mysql_fetch_array($view)){
?>
<tr>
<td><?php echo $i++;?></td>
<td><?php echo $row['nim'];?></td>
<td><?php echo $row['nama'];?></td>
<td><?php echo $row['kd_mk'];?></td>
<td><?php echo $row['nm_mk'];?></td>
<td><?php echo $row['nama_prodi'];?></td>
<td><?php echo $row['semester'];?></td>
<td><?php echo $row['kelas'];?></td>
<td><?php echo $row['huruf_mutu'];?></td>
</tr>
<?php
}}
?>
</table>
</div>
<div class="clear"></div>
</div>
<p>&nbsp;</p>
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr valign="top">
<td><!-- start related-activities --> </td>
</tr>
<tr>
<td></td>
</tr>
</table>
<p>&nbsp;</p>
</div>

Sandi Racy 1:54pm Sep 27
:o

Ridha Rira 1:55pm Sep 27
kasih sran donk ...

Abid Rakhmansyah 1:55pm Sep 27
codenya kepanjangan males bacanya wkwk

Soesanto Adja 1:55pm Sep 27
nganu. itu nggak bisa baca <spasi> deh keknya yang nama tabel prodi p, matkul m,

Ridha Rira 1:59pm Sep 27
Soesanto Adja spasi itu ...

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