· 5 years ago · Mar 27, 2020, 01:02 PM
1
2<?php
3include ('connectDataBase.php');
4
5$link = mysqli_connect($server, $user, $password ,'dbLOI2') or die ("Fout met verbinding");
6 mysqli_select_db($link,'dbLOI2');
7 $query = 'CREATE TABLE IF NOT EXISTS gastenboek (
8 id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
9 imie VARCHAR(50) NOT NULL,
10 text VARCHAR(450) NOT NULL,
11 sport VARCHAR(30) NOT NULL,
12 beofenaar BOOLEAN ,
13 datum TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
14 )';
15$result = mysqli_query($link, $query);
16
17
18 $thisfile = "051R4_new.php";
19 $noform_var = 0;
20 $name = $as_name = $boodschap = $as_boodschap = $datum = "";
21 $reg_form =<<< EOG
22 <form method="post" action="$thisfile">
23 imie:<br />
24 <input name="imie" type="text" value="$name" size=40 /><br />
25 Boodschap:<br />
26 <textarea name="text" cols=40 rows=3 value=""></textarea><br />
27 Sport:<br />
28 <select name="sport" value="">
29 <option value="tennis">tennis</option>
30 <option value="voetbal">voetbal</option>
31 <option value="running">running</option>
32 <option value="tafeltennis">tafeltennis</option>
33 <option value="squash">squash</option>
34 <option value="wielrennen">wielrennen</option>
35 <option value="boksen">boksen</option>
36</select></br>
37 Beofenaar:<br />
38 <input type="radio" name="beofenaar" value="">Ja
39<input type="radio" name="beofenaar" value="">Nee</br>
40 <input type="submit" value="Submit" name="submit"/>
41 </form>
42EOG;
43
44
45if(!isset($_POST['submit'])){
46 $msg = $reg_form;
47}
48elseif(isset($_POST['submit']) && $_POST['submit'] == 'Submit'){
49 if(!isset($_POST['imie']) || $_POST['imie'] == ''){
50 echo ('wpisz swoje imie.');
51 }elseif(!isset($_POST['text']) || $_POST['text'] == ''){
52 echo 'Wpisz swoja wiadomosc.';
53 }
54 elseif(!isset($_POST['sport']) || $_POST['sport'] == ''){
55 echo 'Zaznacz Twoj sport.';
56 }
57 else{
58 $link = mysqli_connect($server, $user, $password ,'dbLOI2')
59 or die('Could not connect: ' . mysqli_error());
60 mysqli_select_db($link,"dbLOI2");
61 $name = mysqli_real_escape_string($link, $_POST['imie']);
62 $as_name = trim($name);
63 $boodschap = mysqli_real_escape_string($link, $_POST['text']);
64 $as_boodschap = trim($boodschap);
65 $sport = mysqli_real_escape_string($link, $_POST['sport']);
66 $as_sport = trim($sport);
67 $datum = strtotime("now");
68 $query = "INSERT INTO gastenboek (id,imie,text,sport,datum)
69 VALUES ('$as_name','$as_boodschap')";
70 $result = mysqli_query($link, $query);
71
72 if(mysqli_affected_rows($link) == 1){
73 $msg = '<p>Twoj wpis został dodany</p>';
74 $noform_var = 1;
75 }else{
76 error_log(mysqli_error($link));
77 $msg = '<P>Cos poszło nie tak</P>';
78 }
79 $msg = $reg_form;
80 }
81}
82
83
84
85?>
86 <!DOCTYPE html>
87<html lang=nl>
88<head>
89 <meta charset=utf-8>
90 <title>Księga Gosci formularz</title>
91</head>
92
93 <body>
94 <H1>Ksiega Gosci</H1>
95<?php echo $reg_form; ?>
96 </body>
97 </html>