Script Memanggil DateBase :
<?php
$seruser = "root";
$serpass = "xxxxxxxxx";
$server = "localhost";
$database = "namadatabase";
$sambung = mysql_connect($server,$seruser,$serpass) or die ("koneksi ke server gagal !");
$data = mysql_select_db($database,$sambung) or die ("koneksi ke database gagal !");
?>
|
Script Memanggila Data Tabel :
<table>
<tr> <td>No</td>
<td>Kode</td><td>Name</td>
<td>Stock</td><td>Price</td><td>Total</td>
<td>Information</td>
</tr>
<?php
$n=1;
$bf=mysql_query("select * from t_barang");
while ($df=mysql_fetch_array($bf))
{ $ttl=($df[harga]*$df[jumlah]); ?>
<tr>
<td><?=$n?></td>
<td><?=$df[kdbarang] ?></td>
<td><?=$df[nama]?></td>
<td><?=$df[jumlah]?></td>
<td><? echo "". number_format($df[harga]) ."";?></td>
<td><? echo "". number_format($ttl) ."";?></td>
<td><?=$df[info]?></td>
</tr>
<?php $n++; } ?>
</table>
|
No comments:
Post a Comment