Advertisement
GWibisono

isenk mysql

May 8th, 2012
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. <?php
  2. $c=mysql_connect('localhost', 'root', '')or die (mysql_errno());
  3. $d=mysql_select_db('psb')or die('Nama Database salah');
  4.  
  5. $query = "SELECT * FROM siswa";
  6. $result = mysql_query($query)or die(mysql_error()."<br>$query");
  7.  
  8. //menampilkan field nama
  9. echo"<div id=tengah>";
  10. $no = 1;
  11.  
  12. while ($row = mysql_fetch_array($result))
  13. {
  14.  
  15.     echo"<div class=no>No.<div class=no>".$row['no_daftar']."</div></div>";
  16.  
  17.     echo"<div class=nama>Nama Pendaftar<div class=nama>".$row['nm_calon']."</div></div>";
  18.  
  19.     echo"<div class=alamat>Alamat<div class=alamat>".$row['alamat']."</div></div>";
  20.  
  21.     echo"<div class=kec>Kecamatan<div class=kec>".$row['nm_kec']."</div></div>";
  22.  
  23.     echo"<div class=tempat>Tempat Lahir<div class=tempat>".$row['tmp_lahir']."</div></div>";
  24.  
  25.     echo"<div class=daftar5>Tanggal lahir<div class=nama>".$row['tgl_lahir']."</div></div>";
  26.     $no++;
  27.  
  28. }
  29. echo"</div>";
  30.  
  31. mysql_free_result($result);
  32. mysql_close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement