| 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> </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> </th> <td valign="top"> </td> <td valign="top"><strong> </strong> <input type="submit" name="submit" value="Submit" class="form-submit" /> </form> <td></td> </tr> </table> <p> </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> </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> </p> </div> |
Tidak ada komentar:
Posting Komentar