PHP: Membuat Guest Book Sederhana - Revision history

Onnowpurbo: /* Membuat tabel guestbook */

2019-06-30T23:32:12Z

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

Onnowpurbo: /* viewguestbook.php */

2019-06-30T23:25:08Z

viewguestbook.php

← Older revision		Revision as of 23:25, 30 June 2019
Line 107:		Line 107:
	$conn->close();		$conn->close();
	?>		?>



			==Pranala Menarik==

			* [[Arduino: RFID RC522]]

Onnowpurbo at 07:32, 9 May 2018

2018-05-09T07:32:54Z

@@ 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();
   ?>

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T07:28:34Z

Membuat tabel guestbook

← Older revision		Revision as of 07:28, 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==		==guestbook.php==

Onnowpurbo: /* guestbook.php */

2018-05-09T07:10:10Z

guestbook.php

← Older revision		Revision as of 07:10, 9 May 2018
Line 31:		Line 31:
	==guestbook.php==		==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 ~~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>		</form>
	</tr>		</body>
	</~~table~~>		</html>
	~~<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>~~


	==addguestbook.php==		==addguestbook.php==

Onnowpurbo: /* guestbook.php */

2018-05-09T06:21:59Z

guestbook.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();
			?>

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T06:15:34Z

Membuat tabel guestbook

← 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>

Onnowpurbo: /* Membuat tabel guestbook */

2018-05-09T06:11:14Z

Membuat tabel guestbook

← 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 ;

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==