Halooo saya ada problem nehh....Kenapa Script PHP yang saya buat gax
bisa melakukan "insert" ke dalam tabel database yahhh ? mohon bantuannya
, Row nya seh nambah , tapi datanya kagak ada ! Berikut log nyah...
MySQL :
=======
[EMAIL PROTECTED] agung]$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use bktamu
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from bukutamu
-> ;
+-------+-------+----------+
| nama | email | komentar |
+-------+-------+----------+
| | | |
| | | |
+-------+-------+----------+
2 rows in set (0.00 sec)
mysql> exit
Bye
[EMAIL PROTECTED] agung]$
Script HTML + PHP :
===================
Script 1 : mysql_bukutamu_form.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN
"http://www.w3.org/TR/html4/loose.dtd"";>
<html>
<head>
<title>Buku Tamu untuk Database mySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="GENERATOR" content="Quanta Plus">
</head>
<body>
<h1>Buku Tamu Untuk mySQL Database</h1>
<table>
<form action="mysql_bukutamu_add_form.php" method="POST">
<tr>
<td>Nama : <input type="text" name="nama" size=35 maxlength=50></td>
</tr>
<tr>
<td>Email : <input type="text" name="email" size=35 maxlength=50></td>
</tr>
<tr>
<td>Komentar : <textarea name="komentar" rows="5"
cols="30"></textarea></td>
</tr>
<tr>
<td><input type="submit" value="Simpan"></td>
</tr>
</form>
</table>
</body>
</html>
Script 2 : mysql_bukutamu_add_form.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN
"http://www.w3.org/TR/html4/loose.dtd"";>
<html>
<head>
<title>Demo Simpan Buku Tamu MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="GENERATOR" content="Quanta Plus">
</head>
<body>
<h1>Demo Simpan Buku Tamu MySQL</h1>
<?
$conn=mysql_connect("localhost","root","");
if ($conn) {
mysql_select_db("bktamu");
echo "<br>";
echo "Nama : $nama";
echo "<br>";
echo "Email : $email";
echo "<br>";
echo "Komentar : $komentar";
echo "<br>";
$sqlstr="insert into bukutamu (nama,email,komentar) values('$nama',
'$email', '$komentar')";
$hasil=mysql_query($sqlstr,$conn);
echo "Simpan buku tamu berhasil dilakukan !";
mysql_close($conn);
} else {
echo "<br>";
echo "<font color='red'>";
echo "<b>Server not connected !</b>";
echo "</font>";
}
?>
</body>
</html>
Log Terakhir :: setelah di submit ::
Demo Simpan Buku Tamu MySQL
Nama :
Email :
Komentar :
Simpan buku tamu berhasil dilakukan !
--
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip, FAQ, dan info milis di http://linux.or.id/milis.php
Tidak bisa posting? Baca:
http://linux.or.id/wiki/index.php?pagename=ProblemMilisDanSolusi
http://linux.or.id/wiki/index.php?pagename=TataTertibMilis
