5cpH20zX

1$name = $_POST["name"];
2$email = $_POST["email"];
3$nachricht = $_POST["nachricht"];
4
5$res = mysql_connect("localhost", "xxxxxxx", "xxxxxx")
6           or die(mysql_error());
7mysql_select_db("db1232110-gbook", $res)
8           or die(mysql_error());
9
10$query = "CREATE TABLE IF NOT EXISTS `test` ( "
11 . "id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, "
12 . "name VARCHAR(50), "
13 . "email VARCHAR(50), "
14 . "nachricht VARCHAR(50) "
15 . ")";
16$result = mysql_query($query, $res)
17           or die(mysql_error());
18
19$query = "INSERT INTO test (name, email, nachricht)
20VALUES ('".$name."','".$email."','".$nachricht."')";
21$result = mysql_query($query, $res)
22           or die(mysql_error());
23
24
25__________________________________________________________
26ersetzen durch:
27
28
29
30
31$res = mysql_connect("localhost", "xxxxxxx",  "xxxxxx")
32           or die(mysql_error());
33mysql_select_db("db1232110-gbook", $res)
34           or die(mysql_error());
35
36if(isset($_POST['submit']))
37{
38$name = $_POST["name"];
39$email = $_POST["email"];
40$nachricht = $_POST["nachricht"];
41
42$query = "INSERT INTO test (name, email, nachricht)
43VALUES ('".$name."','".$email."','".$nachricht."')";
44$result = mysql_query($query, $res)
45           or die(mysql_error());
46}