· 5 years ago · Apr 01, 2020, 12:24 PM
1<?php
2include ('connectDataBase.php');
3 // działajacy formularz
4$link = mysqli_connect($server, $user, $password ,'dbLOI2') or die ("Fout met verbinding");
5 mysqli_select_db($link,'dbLOI2');
6 $query = 'CREATE TABLE IF NOT EXISTS gastenboek2 (
7 id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
8 imie VARCHAR(50) NOT NULL,
9 text VARCHAR(450) NOT NULL,
10 sport VARCHAR(30) NOT NULL,
11 beofenaar BOOLEAN ,
12 datum TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
13 )';
14$result = mysqli_query($link, $query);
15
16
17 $thisfile = "051R4_fc.php";
18 $noform_var = 0;
19 $msg = '';
20 $name = $as_name = $boodschap = $as_boodschap = $sport = $as_sport = $datum = "";
21 $reg_form =<<< EOG
22 <form method="post" action="$thisfile">
23 imie:<br />
24 <input name="imie" type="text" value="" 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 $name = mysqli_real_escape_string($link, $_POST['imie']);
61 $as_name = trim($name);
62 $boodschap = mysqli_real_escape_string($link, $_POST['text']);
63 $as_boodschap = trim($boodschap);
64 $sport = mysqli_real_escape_string($link, $_POST['sport']);
65 $as_sport = trim($sport);
66 $datum = strtotime("now");
67 $query = "INSERT INTO gastenboek2 (id,imie,text,sport,datum)
68 VALUES (NULL,'$as_name','$as_boodschap','$as_sport',NOW())";
69 $result = mysqli_query($link, $query);
70
71 if(mysqli_affected_rows($link) == 1){
72 $msg = '<p>Twoj wpis został dodany</p>';
73 $noform_var = 1;
74 }else{
75 error_log(mysqli_error($link));
76 $msg = '<P>Cos poszło nie tak</P>';
77 }
78 }
79}
80
81
82
83?>
84 <!DOCTYPE html>
85<html lang=nl>
86<head>
87 <meta charset=utf-8>
88 <title>Księga Gosci formularz</title>
89</head>
90
91 <body>
92 <H1>Ksiega Gosci</H1>
93<?php echo $reg_form; ?>
94 </body>
95 </html>