· 8 years ago · Aug 26, 2018, 10:46 PM
1<html>
2
3<form action="gbook.php" method="post">
4Name: <input type="text" name="name" value=""><br />
5EMail: <input type="text" name="email" value=""><br />
6Text: <textarea name="text" cols="20 rows="6">
7</textarea><br />
8<input type="submit" value="Eintragen!">
9</form>
10
11</html>
12
13<?php
14
15$name = $_POST["name"];
16$email = $_POST["email"];
17$nachricht = $_POST["nachricht"];
18
19$res = mysql_connect("localhost", "user1232110", "Gay57it89O");
20 # or die(mysql_error());
21mysql_select_db("gbook", $res);
22 # or die(mysql_error());
23
24$query = "CREATE TABLE IF NOT EXISTS `test` ( "
25 . "id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, "
26 . "name VARCHAR(50), "
27 . "email VARCHAR(50), "
28 . "nachricht VARCHAR(50) "
29 . ")";
30$result = mysql_query($query, $res);
31 # or die(mysql_error());
32
33$query = "INSERT INTO test (name, email, nachricht)
34VALUES ('".$name."','".$email."','".$nachricht."')";
35$result = mysql_query($query, $res);
36 # or die(mysql_error());
37
38while ($row = mysql_fetch_array( $result )) {
39print "<div style=\"margin:0px;padding:10px\">";
40print "Name: " .htmlentities($row["name"]). "<br />";
41print "EMail: " .htmlentities($row["email"]). "<br />";
42print "<span style=\"background:#ccc;color:#fff;\">"
43.htmlentities($row["nachricht"]). "</span><br />";
44print "</div>";
45 }
46?>