Advertisement
Guest User

Untitled

a guest
Jun 26th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.71 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost';
  3. $dbuser = 'root';
  4. $dbpass = '';
  5. $koneksi = mysql_connect($dbhost, $dbuser, $dbpass);
  6. if(! $koneksi )
  7. {
  8. die('Gagal Koneksi: ' . mysql_error());
  9. }
  10. $sql = 'SELECT nama, username, ttl, email, bayar FROM pencari_kerja';
  11.  
  12. mysql_select_db('loker');
  13. $ambildata = mysql_query( $sql, $koneksi);
  14. if(! $ambildata )
  15. {
  16. die('Gagal ambil data: ' . mysql_error());
  17. }
  18. ?>
  19. <!DOCTYPE html>
  20. <head>
  21. <meta charset="UTF-8">
  22. <title>Belajar PHP MySQL</title>
  23. <style>
  24. h3{
  25. text-align:center; }
  26. table {
  27. border-collapse:collapse;
  28. border-spacing:0;
  29. font-family:Arial, sans-serif;
  30. font-size:16px;
  31. padding-left:300px;
  32. margin:auto; }
  33. table th {
  34. font-weight:bold;
  35. padding:10px;
  36. color:#fff;
  37. background-color:#2A72BA;
  38. border-top:1px black solid;
  39. border-bottom:1px black solid;}
  40. table td {
  41. padding:10px;
  42. border-top:1px black solid;
  43. border-bottom:1px black solid;
  44. text-align:center; }
  45. tr:nth-child(even) {
  46. background-color: #DFEBF8; }
  47. </style>
  48. </head>
  49. <body>
  50. <table>
  51. <tr>
  52. <th>Nama</th>
  53. <th>Username</th>
  54. <th>TTL</th>
  55. <th>Email</th>
  56. <th>Bayar</th>
  57. <th>Acc</th>
  58.  
  59.  
  60. </tr>
  61. <?php
  62. while($row = mysql_fetch_array($ambildata, MYSQL_ASSOC))
  63. {
  64. echo "<tr>";
  65. echo "<td>".$row['nama']."</td>";
  66. echo "<td>".$row['username']."</td>";
  67. echo "<td>".$row['ttl']."</td>";
  68. echo "<td>".$row['email']."</td>";
  69. echo "<td>".$row['bayar']."</td>";
  70. echo "<td><input type='checkbox' name='vehicle' value='Bike'>I have a bike</td>";
  71. echo "</tr>"; }
  72.  
  73.  
  74.  
  75.  
  76.  
  77. mysql_close($koneksi);
  78. ?>
  79.  
  80. </table>
  81. </body>
  82. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement