Advertisement
GWibisono

harusnya begini

Jan 5th, 2014
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.10 KB | None | 0 0
  1. <?php
  2.  
  3. include("/koneksi.php");
  4.  
  5. // membuat awal dan header tabel
  6. echo "<table style='border-collapse:collapse; ' border='1' bordercolor='#D18E78' width='100%'>";
  7. echo " <tr>
  8. <td style='background:#D39580; width:30px;' align='center'><b>Jurusan</b></td>
  9. <td style='background:#D39580;width:150px;' align='center'><b>Jumlah</b></td>
  10. </tr>";
  11.  
  12. // membaca semua data bidang
  13. /*
  14. $query = "SELECT * FROM tb_alumni";
  15. $hasil = mysql_query($query);
  16. */
  17. $query2 = "SELECT DISTINCT jurusan FROM tb_alumni";
  18. $hasil = mysql_query($query2);
  19.  
  20.  
  21. while ($data = mysql_fetch_array($hasil))
  22. {
  23.  
  24. // mencari data
  25. /*
  26. $query2 = "SELECT DISTINCT jurusan FROM tb_alumni";
  27. $hasil2 = mysql_query($query2);
  28. $data2 = mysql_fetch_array($hasil2);
  29. */
  30. $jurusan = $data['jurusan'];
  31.  
  32. // menghitung jumlah
  33. $query2 = "SELECT count(*) as jurusan FROM tb_alumni WHERE jurusan = '$jurusan' ";
  34. $hasil2 = mysql_query($query2);
  35. $data2 = mysql_fetch_array($hasil2);
  36. $jumlah = $data2['jurusan'];
  37.  
  38. echo "
  39. <tr>
  40. <td align='center'>$jurusan</td>
  41. <td align='center'>$jumlah</td>
  42. </tr>";
  43.  
  44. }
  45. // membuat akhir dari tabel
  46. echo "</table>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement