Rabu, 18 Februari 2009

m3mbu4t buku t4mu m3n99un4k4n script PHP & MY SQL

<html>
<head>
<title>Halaman Buku tamu</title>
</head>

<body>
Buku tamu - <a href="lihat.php">lihat isi buku tamu</a><br />
<br />
<hr>
Isilah buku tamu kami<br />
<br />
<br />
<form id="form1? name="form1? method="post" action="isi.php">
nama
<input type="text" name="nama" id="nama" />
<br />
<br />
pesan
<textarea name="pesan" id="pesan" cols="45? rows="5?></textarea>
<br />
<br />
<hr>
<input type="submit" name="Submit" id="Submit" value="Submit" />
</form>
</body>

</html>

ini gambarnya....


isi.php

<html>

<head>

<title>Input Data dari Form ke MySQL</title>

</head><body>

<?php$nama = $_POST['nama'];$pesan = $_POST['pesan'];$conn = mysql_connect("localhost","root","");

if (!$conn) {

echo "Could not connect to db";

exit(1);

}

$db = mysql_select_db("latihan",$conn);

$sqlText = "insert into bukutamu(nama, pesan,tanggal)

values('$nama','$pesan',NOW(''))";

mysql_query($sqlText);

?>

Buku tamu - <a href=lihat.php>lihat isi buku tamu

</a><br /></body>

</html>

ini gambarnya...


script buat lihat.php
<html>

<head>

<title>Daftar Data yang ada di MySQL</title>

</head>

<body bgcolor="#000000">

<a href=bukutamu.php>Isi Buku Tamu</a>

<br />

<font color="#FFFFFF" size="3">Isi buku tamu

<br />

<br /><

?php$conn = mysql_connect("localhost","root","");

if (!$conn){

echo "Could not connect to db";

exit(1);

}$db = mysql_select_db("latihan",$conn);

$sqlText = "select * from bukutamu";

$result = mysql_query($sqlText);

while($row=mysql_fetch_object($result)){

?>

<strong>Nama</strong>:

<?php echo $row->nama;?>

<br /><strong>Pesan

</strong>:

<?php echo $row->pesan;?><br /><br />

<?php } ?><marquee>
---

</marquee></font> <font color="#FFFFFF">

<marquee>

</marquee>

</font>

<marquee><font color="#FF0000" size="3">AYO KAMU BISA BIKIN PROGRAM PAKE PHPrunning text

</font>

----

</marquee>

</body>

</html>

fiuh akhirnya nyampai juga di gambar trakhir.....

Tidak ada komentar: