drimlen

teshal.php

Apr 30th, 2012
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. ini code halaman teshal.php yang dipanggil sama browser kak
  2.  
  3. <html>
  4. <head>
  5. <title>
  6. Teshal.php
  7. </title>
  8. </head>
  9. <body>
  10. <?php
  11. include ("connect.php");
  12. include ("halaman.php");
  13.  
  14. $per_halaman = 20;
  15. $halaman = new kelas_halaman($per_halaman);
  16.  
  17. $sql = "select * from karyawan";
  18. $hasil = mysql_query($sql, $id_mysql);
  19.  
  20. $jum_baris = mysql_num_rows($hasil);
  21. $halaman->tentukan_total_baris($jum_baris);
  22. $awal_record = $halaman->peroleh_awal_record();
  23.  
  24. $sql = "select * from karyawan " .
  25. "limit $awal_record, $per_halaman";
  26. $hasil = mysql_query($sql, $id_mysql);
  27.  
  28. $nomor = $awal_record;
  29.  
  30. print("<table align=\"center\" border=\"1\">");
  31. print("<tr bgcolor=\"#CC2900\">");
  32. print("<td align=\"center\">");
  33. print("<font color=\"#CCCCCC\" face=\"calibri\"> No </font></td>");
  34. print("<td align=\"center\">");
  35. print("<font color=\"#CCCCCC\" face=\"calibri\"> NIP </font></td>");
  36. print("<td align=\"center\">");
  37. print("<font color=\"#CCCCCC\" face=\"calibri\">Kode Departemen </font></td>");
  38. print("<td align=\"center\">");
  39. print("<font color=\"#CCCCCC\" face=\"calibri\">Nama </font></td>");
  40. print("<td align=\"center\">");
  41. print("<font color=\"#CCCCCC\" face=\"calibri\">Tanggal Lahir </font></td>");
  42. print("<td align=\"center\">");
  43. print("<font color=\"#CCCCCC\" face=\"calibri\">Jumlah Anak </font></td>");
  44. print("</tr>");
  45.  
  46. while ($baris = mysql_fetch_row($hasil))
  47. {
  48. $nomor ++;
  49.  
  50. if ($nomor % 2 == 0)
  51. $warna_belakang = "#FF4D4D";
  52. else
  53. $warna_belakang = "#FFA6A6";
  54.  
  55. $NIP = $baris[0];
  56. $Kode_Dep = $baris[1];
  57. $Nama = $baris[2];
  58. $Tanggal_Lahir = $baris[3];
  59. $Jumlah_Anak = $baris[4];
  60.  
  61. print("<tr bgcolor=\"$warna_belakang\">\n");
  62. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$nomor</td>\n");
  63. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$NIP</td>\n");
  64. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$Kode_Dep</td>\n");
  65. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$Nama</td>\n");
  66. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$Tanggal_Lahir</td>\n");
  67. print("<td align=\"center\"><font face=\"calibri\" color=\"#312F2F\">$Jumlah_Anak</td>\n");
  68. }
  69. print("</table>");
  70. mysql_close($id_mysql);
  71.  
  72. $halaman->tampilkan_link_halaman();
  73. ?>
  74. </body>
  75. </html>
Advertisement
Add Comment
Please, Sign In to add comment