Tutorial Website Lengkap

Menampilkan database dalam website kita

DATABASE

CREATE TABLE IF NOT EXISTS `form` (

`nama` varchar(50) NOT NULL,

`email` varchar(50) NOT NULL,

`telepon` int(20) NOT NULL,

`alamat` varchar(20) NOT NULL,

`pesan` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `form` (`nama`, `email`, `telepon`, `alamat`, `pesan`) VALUES

('eka', 'example1@bla.com', 34456, 'Indonesia', 'Blognya bagus.'),

('atus', 'example2@bla.com', 3543631, 'Indonesia', 'Yaa blognya bagus.');

PHP (Tampil.php)

<?php

$host="localhost";
$user="root";
$pass="";
$database="form";

$conn=mysql_connect($host,$user,$pass) or die ("mysql tidak bisa connect cek, pastikan mysql dalam keadaan hidup".mysql_error());

$db=mysql_select_db($database,$conn) or die ("database tidak dapat di akses, pastikan database ada".mysql_error());

$hasil=mysql_query("SELECT * FROM form") or die ("gagal query".mysql_error());
if (mysql_num_rows ($hasil) >0){
echo "<table border=1 cellpadding=10>";
echo "<tr>";
echo "<td colspan=5>FORM</td>";
echo "</tr>";
while ($baris = mysql_fetch_assoc($hasil))
{
echo "<tr>";
echo "<td>$baris[nama]</td>";echo "<td>$baris[email]</td>";
echo "<td>$baris[telepon]</td>";
echo "<td>$baris[alamat]</td>";
echo "<td>$baris[pesan]</td>";

echo "</tr>";

}

echo "</table>";

}

else

{

echo "Data kosong pada tabel form";

mysql_close($conn);

exit();

}

mysql_free_result($hasil);

mysql_close($conn);