Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1.  
  2. <?php
  3. $dbhost = 'localhost';
  4. $dbuser = 'root';
  5. $dbpass = '';
  6. $koneksi = mysql_connect($dbhost, $dbuser, $dbpass);
  7. if(! $koneksi )
  8. {
  9. die('Gagal Koneksi: ' . mysql_error());
  10. }
  11. if(isset($_GET['id'])) {
  12. $id = $_GET['id'];
  13.  
  14. $sql = "SELECT id_iklan, judul, pend, bid, wil, isi FROM lowongan WHERE id_iklan=$id"; // comment Zulficar -- yg ini diganti jadi "SELECT * FROM pencari_kerja WHERE bayar != '0'" (kalo yg dipilih semua fieldnya pake tanda bintang *). Ini artinya yg ditampilin di tabel cuma yg udah bayar
  15.  
  16. mysql_select_db('loker');
  17. $ambildata = mysql_query( $sql, $koneksi);
  18. if(! $ambildata )
  19. {
  20. die('Gagal ambil data: ' . mysql_error());
  21. } ?>
  22.  
  23.  
  24. <?php
  25. while($row = mysql_fetch_array($ambildata, MYSQL_ASSOC))
  26. {
  27.  
  28.  
  29. $judul= $row['judul'];
  30. $bid=$row['bid'];
  31. $pend=$row['pend'];
  32. $wil=$row['wil'];
  33. $isi=$row['isi'];
  34.  
  35.  
  36. }
  37. }
  38.  
  39. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement