Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //koneksi
- mysql_connect('localhost','root','');
- mysql_select_db('nurulilm_raports');
- //tampilkan data dengan full join
- $query = "SELECT * FROM mapel as M LEFT OUTER JOIN nilai as N ON N.id_mapel=M.id_mapel WHERE N.id_siswa='1'";
- $sql = mysql_query($query);
- echo "
- <table border='1' cellpadding='5'>
- <tr>
- <th>Mata Pelajaran</th>
- <th>Tugas</th>
- <th>Uts</th>
- <th>Uas</th>
- <th>Hasil</th>
- </tr>
- ";
- while($data = mysql_fetch_array($sql)){
- echo "
- <tr>
- <td>$data[nama_mapel]</td>
- <td>$data[n_tugas]</td>
- <td>$data[uts]</td>
- <td>$data[uas]</td>
- <td>$data[n_hasil]</td>
- </tr>
- ";
- }
- echo mysql_error();
- echo "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement