Guestbook
Contoh script PHP yang paling sederhana yaitu (guestbook) 🙂
Form buku tamu
1. Nama pengisi
2. Email
3. Situs Web
4. Komentar
| id | integer | auto increment | Primary Key |
| nama | varchar(30) | ||
| varchar(30) | |||
| website | varchar(30) | ||
| tanggal | date | ||
| komentar | text |
Field tanggal digunakan untuk menyimpan informasi tanggal kapan komentar tersebut dikirim (tanggal ini secara otomatis membaca tanggal ketika komentar buku tamu disubmit)
Formguestbook.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 |
<html> <head><title>Guestbook</title></head> <body> <table> <form action="guestbook.php" method="post"> <tr> <td>Nama</td> <td>:</td> <td><input type="text" name="nama" /></td> </tr> <tr> <td>Email</td> <td>:</td> <td><input type="text" name="email" /></td> </tr> <tr> <td>Website</td> <td>:</td> <td><input type="text" name="website" /></td> </tr> <tr> <td>Komentar</td> <td>:</td> <td><textarea name="komentar"></textarea></td> </tr> <tr> <td><input type="submit" name="submit" value="Submit" /></td> </tr> </form> </table> </body> </html> |
Guestbook.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<?php mysql_connect('localhost', 'root', ''); mysql_select_db('guestbook'); $nama = $_POST['nama']; $email = $_POST['email']; $website = $_POST['website']; $tanggal = date("Y-m-d"); $komentar = $_POST['komentar']; $query = "INSERT INTO guestbook (nama, email, website, tanggal, komentar) VALUES ('$nama', '$email', '$website', '$tanggal', '$komentar')"; $result = mysql_query($query); if ($result) { echo "Data Masuk"; } else { echo "Data tidak Masuk"; } mysql_close(); ?> <html> <head></title>Guestbook</title></head> <body> <table> <tr> <th>Nomor</th> <th>Nama</th> <th>Email</th> <th>Website</th> <th>Tanggal</th> <th>Komentar</th> </tr> <?php mysql_connect('localhost', 'root', ''); mysql_select_db('guestbook'); $query = "SELECT * FROM guestbook"; $result = mysql_query($query); while ($data = mysql_fetch_array($result)) { echo "<tr> <td>".$data['id']."</td> <td>".$data['nama']."</td> <td>".$data['email']."</td> <td>".$data['website']."</td> <td>".$data['tanggal']."</td> <td>".$data['komentar']."</td>"; } mysql_close(); ?> </table> </body> </html> |