Halooo saya ada problem nehhKenapa 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
titleBuku Tamu untuk Database mySQL/title
meta http-equiv=Content-Type content=text/html; charset=UTF-8
meta name=GENERATOR content=Quanta Plus
/head
body
h1Buku Tamu Untuk mySQL Database/h1
table
form action=mysql_bukutamu_add_form.php method=POST
tr
tdNama : input type=text name=nama size=35 maxlength=50/td
/tr
tr
tdEmail : input type=text name=email size=35 maxlength=50/td
/tr
tr
tdKomentar : textarea name=komentar rows=5
cols=30/textarea/td
/tr
tr
tdinput 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
titleDemo Simpan Buku Tamu MySQL/title
meta http-equiv=Content-Type content=text/html; charset=UTF-8
meta name=GENERATOR content=Quanta Plus
/head
body
h1Demo 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 bServer 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