Home » » Menampilkan Data

Menampilkan Data

Written By Unknown on Thursday, September 4, 2014 | 9:53 AM


 
Langsung aja... kita coba Koneksikan dulu dengan database di Mysql

 
<?php
   $konek =mysql_connect("localhost","root","");
   $db = mysql_select_db("kamus",$conn);
   $sql = "select * from buku order by kode";
   $tampil = mysql_query($sql,$konek);
?>

Untuk menampilkan data kita gunakan mysql_fetch_row 

<h1 align="center" >Data Buku</h1>
<br>
<table width="656" border="1" cellspacing="0" cellpadding="2">
   <tr>
      <td width="107">Kode</td>
      <td width="212">Judul</td>
      <td width="94">Jenis</td>
      <td width="128">Pengarang</td>
      <td width="83">Jumlah</td>
   </tr>
<?php
   while ($rsbuku = mysql_fetch_row($tampil)){
?>
   <tr>
      <td><?php echo $buku[0]; ?></td>
      <td><?php echo $buku[1]; ?></td>
      <td><?php echo $buku[2]; ?></td>
      <td><?php echo $buku[3]; ?></td>
      <td><?php echo $buku[4]; ?></td>
   </tr>
<?php } ?>
</table> 
 
selamat mencoba...  

0 komentar:

Post a Comment

Blogger Tips and TricksLatest Tips For BloggersBlogger Tricks