
Berikut adalah contoh kode sederhana bagaimana cara menampilkan data dari Database MySQL dengan PHP
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<table border="1" cellpadding="5" cellspacing="0">
<tr>
<th> No </th>
<th> Nama </th>
<th> Jenis Kel </th>
<th> Alamat </th>
<th> Telp </th>
<th> Action </th>
</tr>
<?php
include 'koneksi.php';
$select = "SELECT * FROM profil";
$query = mysql_query($select);
$no=0;
while ($data = mysql_fetch_array($query)) {
$id = $data['id']; // dr tabel
$nama = $data['nama'];
$jenis_kel = $data['jenis_kelamin'];
$alamat = $data['alamat'];
$telp = $data['no_telp'];
$no++;
echo "
<tr>
<td> $no </td>
<td> $nama </td>
<td> $jenis_kel </td>
<td> $alamat </td>
<td> $telp </td>
<td>
<a href='#'> Edit </a>
<a href='#'> Delete </a>
</td>
</tr>
";
}
?>
</table>
</body>
</html>