Difference between revisions of "PHP: Membuat Guest Book Sederhana"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) (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...") |
Onnowpurbo (talk | contribs) |
||
(7 intermediate revisions by the same user not shown) | |||
Line 11: | Line 11: | ||
− | ==Membuat tabel guestbook== | + | ==Membuat tabel guestbook (jangan lupa view source)== |
+ | |||
+ | 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 ; | ||
+ | |||
+ | ==guestbook.php== | ||
+ | |||
+ | <!DOCTYPE HTML> | ||
+ | <html> | ||
+ | <body> | ||
+ | <form action="addguestbook.php" method="post"> | ||
+ | Nama: <input type="text" name="name"><br> | ||
+ | Email: <input type="text" name="email"><br> | ||
+ | Komentar: <input type="text" name="comment"><br> | ||
+ | <input type="submit"> | ||
+ | </form> | ||
+ | </body> | ||
+ | </html> | ||
+ | |||
+ | ==addguestbook.php== | ||
+ | |||
+ | <?php | ||
+ | $host="localhost"; // Host name | ||
+ | $username="root"; // Mysql username | ||
+ | $password="123456"; // Mysql password | ||
+ | $db_name="test"; // Database name | ||
+ | $tbl_name="guestbook"; // Table name | ||
+ | |||
+ | $datetime=date("y-m-d h:i:s"); //date time | ||
+ | $name1=$_POST["name"]; | ||
+ | $email1=$_POST["email"]; | ||
+ | $comment1=$_POST["comment"]; | ||
+ | |||
+ | // 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"); | ||
+ | |||
+ | $sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name1', '$email1', '$comment1', '$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(); | ||
+ | ?> | ||
+ | |||
+ | ==viewguestbook.php== | ||
+ | |||
+ | <?php | ||
+ | $servername = "localhost"; | ||
+ | $username = "root"; | ||
+ | $password = "123456"; | ||
+ | $dbname = "test"; | ||
+ | |||
+ | // Create connection | ||
+ | $conn = new mysqli($servername, $username, $password, $dbname); | ||
+ | // Check connection | ||
+ | if ($conn->connect_error) { | ||
+ | die("Connection failed: " . $conn->connect_error); | ||
+ | } | ||
+ | |||
+ | $sql = "SELECT id, name, email, comment, datetime FROM guestbook"; | ||
+ | $result = $conn->query($sql); | ||
+ | |||
+ | if ($result->num_rows > 0) { | ||
+ | // output data of each row | ||
+ | while($row = $result->fetch_assoc()) { | ||
+ | echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["email"]. " " . $row["comment"]. " " . $row["datetime"]. "<br>"; | ||
+ | } | ||
+ | } else { | ||
+ | echo "0 results"; | ||
+ | } | ||
+ | $conn->close(); | ||
+ | ?> | ||
+ | |||
+ | |||
+ | |||
+ | ==Pranala Menarik== | ||
+ | |||
+ | * [[Arduino: RFID RC522]] |
Latest revision as of 06:32, 1 July 2019
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 (jangan lupa view source)
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 ;
guestbook.php
<!DOCTYPE HTML> <html> <body> <form action="addguestbook.php" method="post"> Nama: <input type="text" name="name">
Email: <input type="text" name="email">
Komentar: <input type="text" name="comment">
<input type="submit"> </form> </body> </html>
addguestbook.php
<?php $host="localhost"; // Host name $username="root"; // Mysql username $password="123456"; // Mysql password $db_name="test"; // Database name $tbl_name="guestbook"; // Table name $datetime=date("y-m-d h:i:s"); //date time $name1=$_POST["name"]; $email1=$_POST["email"]; $comment1=$_POST["comment"]; // 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"); $sql="INSERT INTO $tbl_name(name, email, comment, datetime)VALUES('$name1', '$email1', '$comment1', '$datetime')"; $result=mysql_query($sql); //check if query successful if($result){ echo "Successful"; echo "
"; // link to view guestbook page echo "<a href='viewguestbook.php'>View guestbook</a>"; } else { echo "ERROR"; } mysql_close(); ?>
viewguestbook.php
<?php $servername = "localhost"; $username = "root"; $password = "123456"; $dbname = "test"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, name, email, comment, datetime FROM guestbook"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["email"]. " " . $row["comment"]. " " . $row["datetime"]. "
"; } } else { echo "0 results"; } $conn->close(); ?>