Advertisement
fanjava

Data Nilai Mahasiswa

May 23rd, 2012
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.70 KB | None | 0 0
  1. <?php
  2.     //koneksi
  3.     mysql_connect('localhost','root','');
  4.     mysql_select_db('nurulilm_raports');
  5.    
  6.     //tampilkan data dengan full join
  7.     $query = "SELECT * FROM mapel as M LEFT OUTER JOIN nilai as N ON N.id_mapel=M.id_mapel WHERE N.id_siswa='1'";
  8.     $sql = mysql_query($query);
  9.    
  10.     echo "
  11.         <table border='1' cellpadding='5'>
  12.             <tr>
  13.                 <th>Mata Pelajaran</th>
  14.                 <th>Tugas</th>
  15.                 <th>Uts</th>
  16.                 <th>Uas</th>
  17.                 <th>Hasil</th>
  18.             </tr>
  19.     ";
  20.    
  21.     while($data = mysql_fetch_array($sql)){
  22.         echo "
  23.             <tr>
  24.                 <td>$data[nama_mapel]</td>
  25.                 <td>$data[n_tugas]</td>
  26.                 <td>$data[uts]</td>
  27.                 <td>$data[uas]</td>
  28.                 <td>$data[n_hasil]</td>
  29.             </tr>
  30.         ";
  31.     }
  32.     echo mysql_error();
  33.     echo "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement