PHP: Membuat Guest Book Sederhana - Revision history

Onnowpurbo: /* Membuat tabel guestbook */

2019-06-30T23:32:12Z

Membuat tabel guestbook

Onnowpurbo: /* viewguestbook.php */

2019-06-30T23:25:08Z

viewguestbook.php

Onnowpurbo at 07:32, 9 May 2018

2018-05-09T07:32:54Z

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T07:28:34Z

Membuat tabel guestbook

Onnowpurbo: /* guestbook.php */

2018-05-09T07:10:10Z

guestbook.php

Onnowpurbo: /* guestbook.php */

2018-05-09T06:21:59Z

guestbook.php

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T06:15:34Z

Membuat tabel guestbook

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T06:11:14Z

Membuat tabel guestbook

Onnowpurbo: Created page with "Sumber: http://www.phpeasystep.com/phptu/15.html http://www.phpeasystep.com/workshopview.php?id=16 Yang perlu dibuat * Table "guestbook" in database "test". * guestbook.ph..."

2018-05-09T06:01:11Z

Created page with "Sumber: http://www.phpeasystep.com/phptu/15.html http://www.phpeasystep.com/workshopview.php?id=16 Yang perlu dibuat * Table "guestbook" in database "test". * guestbook.ph..."

New page

Sumber:
http://www.phpeasystep.com/phptu/15.html
http://www.phpeasystep.com/workshopview.php?id=16

Yang perlu dibuat
* Table "guestbook" in database "test".
* guestbook.php.
* addguestbook. php.
* viewguestbook.php

==Membuat tabel guestbook==

← Older revision		Revision as of 23:32, 30 June 2019
Line 11:		Line 11:


−	==Membuat tabel guestbook==	+	==Membuat tabel guestbook (jangan lupa view source)==

	mysql -u root -p123456		mysql -u root -p123456

← Older revision		Revision as of 23:25, 30 June 2019
Line 107:		Line 107:
	$conn->close();		$conn->close();
	?>		?>
		+
		+
		+
		+	==Pranala Menarik==
		+
		+	* [[Arduino: RFID RC522]]

@@ Line 46: / Line 46: @@
   <?php
   $host="localhost"; // Host name
-  $username=""; // Mysql username
+  $username="root"; // Mysql username
-  $password=""; // Mysql password
+  $password="123456"; // Mysql password
   $db_name="test"; // Database name
   $tbl_name="guestbook"; // Table name
   // Connect to server and select database.
@@ Line 55: / Line 60: @@
   mysql_select_db("$db_name")or die("cannot select DB");
- $datetime=date("y-m-d h:i:s"); //date time
+  $sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name1', '$email1', '$comment1', '$datetime')";
   $result=mysql_query($sql);
@@ Line 74: / Line 77: @@
   mysql_close();
   ?>

@@ Line 27: / Line 27: @@
   PRIMARY KEY (`id`)
   ) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 ==guestbook.php==

@@ Line 31: / Line 31: @@
 ==guestbook.php==
+  <!DOCTYPE HTML>
- <table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
+  <html>
- <tr>
+  <body>
- <td><strong>Buku Tamu </strong></td>
+  <form action="addguestbook.php" method="post">
- </tr>
+  Nama: <input type="text" name="name"><br>
-  </table>
+  Email: <input type="text" name="email"><br>
-  <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
+  Komentar: <input type="text" name="comment"><br>
-  <tr>
+  <input type="submit">
   </form>
-  </tr>
+  </body>
-  </table>
+  </html>
 ==addguestbook.php==

← Older revision		Revision as of 06:21, 9 May 2018
Line 72:		Line 72:
	</tr>		</tr>
	</table>		</table>
		+
		+
		+	==addguestbook.php==
		+
		+	<?php
		+	$host="localhost"; // Host name
		+	$username=""; // Mysql username
		+	$password=""; // Mysql password
		+	$db_name="test"; // Database name
		+	$tbl_name="guestbook"; // Table name
		+
		+	// Connect to server and select database.
		+	mysql_connect("$host", "$username", "$password")or die("cannot connect server ");
		+	mysql_select_db("$db_name")or die("cannot select DB");
		+
		+	$datetime=date("y-m-d h:i:s"); //date time
		+
		+	$sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name', '$email', '$comment', '$datetime')";
		+	$result=mysql_query($sql);
		+
		+	//check if query successful
		+	if($result){
		+	echo "Successful";
		+	echo "<BR>";
		+
		+	// link to view guestbook page
		+	echo "<a href='viewguestbook.php'>View guestbook</a>";
		+	}
		+
		+	else {
		+	echo "ERROR";
		+	}
		+
		+	mysql_close();
		+	?>

← Older revision		Revision as of 06:15, 9 May 2018
Line 27:		Line 27:
	PRIMARY KEY (`id`)		PRIMARY KEY (`id`)
	) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;		) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
		+
		+
		+	==guestbook.php==
		+
		+
		+	<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
		+	<tr>
		+	<td><strong>Buku Tamu </strong></td>
		+	</tr>
		+	</table>
		+	<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
		+	<tr>
		+	<form id="form1" name="form1" method="post" action="addguestbook.php">
		+	<td>
		+	<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
		+	<tr>
		+	<td width="117">Nama</td>
		+	<td width="14">:</td>
		+	<td width="357"><input name="name" type="text" id="name" size="40" /></td>
		+	</tr>
		+	<tr>
		+	<td>Email</td>
		+	<td>:</td>
		+	<td><input name="email" type="text" id="email" size="40" /></td>
		+	</tr>
		+	<tr>
		+	<td valign="top">Komentar</td>
		+	<td valign="top">:</td>
		+	<td><textarea name="comment" cols="40" rows="3" id="comment"></textarea></td>
		+	</tr>
		+	<tr>
		+	<td> </td>
		+	<td> </td>
		+	<td><input type="submit" name="Submit" value="Submit" /> <input type="reset" name="Submit2" value="Reset" /></td>
		+	</tr>
		+	</table>
		+	</td>
		+	</form>
		+	</tr>
		+	</table>
		+	<table width="400" border="0" align="center" cellpadding="3" cellspacing="0">
		+	<tr>
		+	<td><strong><a href="viewguestbook.php">Lihat Buku Tamu</a> </strong></td>
		+	</tr>
		+	</table>

← Older revision		Revision as of 06:11, 9 May 2018
Line 12:		Line 12:

	==Membuat tabel guestbook==		==Membuat tabel guestbook==
		+
		+	mysql -u root -p123456
		+
		+	create database test;
		+	use test;
		+	grant ALL on root.* to test@localhost;
		+
		+	CREATE TABLE `guestbook` (
		+	`id` int(4) NOT NULL auto_increment,
		+	`name` varchar(65) NOT NULL default '',
		+	`email` varchar(65) NOT NULL default '',
		+	`comment` longtext NOT NULL,
		+	`datetime` varchar(65) NOT NULL default '',
		+	PRIMARY KEY (`id`)
		+	) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;