· 8 years ago · Jun 06, 2018, 09:08 AM
1<html>
2<head>
3 <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.0/css/bootstrap.min.css" integrity="sha384-9gVQ4dYFwwWSjIDZnLEWnxCjeSWFphJiwGPXr1jddIhOegiu1FwO5qRGvFXOdJZ4" crossorigin="anonymous">
4 <meta charset="UTF-8">
5
6<?php
7
8
9mysql_query("SET NAMES utf8");
10
11$TABULKA = 1;
12$existuje = 0;
13if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['jmeno']) && !empty($_POST['jmeno']) && isset($_POST['prijmeni']) && !empty($_POST['prijmeni']) && isset($_POST['email']) && !empty($_POST['email'])) {
14 $jmeno = $_POST['jmeno'];
15 $prijmeni = $_POST['prijmeni'];
16 $email = $_POST['email'];
17 $kontrola = 0;
18
19 echo "<table class=\"table\">
20 <tr>
21 <th>Jmeno</th>
22 <th>Prijmeni</th>
23 <th>Email</th>
24 <th>Zapis do logu / MySQL</th>
25 </tr>
26 <tr>";
27
28
29
30 if (preg_match("/^[a-zA-ZěšÄřžýáÃéúů]*/",$jmeno) && $jmeno[0] == strtoupper($jmeno[0]) ) {
31 echo " <td> <b style=\"color: green;\"> Spravne </b> </td>"; }
32 else { echo " <td> <b style=\"color: red;\"> Spatne </b></td> "; $kontrola = 1;}
33
34 if (preg_match("/^[a-zA-ZěšÄřžýáÃéúů]*/",$prijmeni) && $prijmeni[0] == strtoupper($prijmeni[0]) ) {
35 echo " <td> <b style=\"color: green;\"> Spravne </b> </td>"; }
36 else { echo " <td> <b style=\"color: red;\"> Spatne </b></td> "; $kontrola = 1;}
37
38 if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
39 echo " <td> <b style=\"color: green;\"> Spravne </b> </td>"; }
40 else { echo " <td> <b style=\"color: red;\"> Spatne </b></td> "; $kontrola = 1;}
41
42
43
44
45
46
47$date = date('m/d/Y h:i:s', time());
48
49
50
51 if ($kontrola == 0) {
52 $data = "ÄŒas: " . $date . " Jméno: " . $jmeno . " PÅ™ijmenÃ: " . $prijmeni . " Email: " . $email . "\n";
53 $file = fopen("uzivatele.txt","a");
54
55 fwrite($file,$data);
56 fwrite($file, "\n");
57 fclose($file);
58
59 echo "<td>Zapsano do logu</td></tr><tr> <td>".$jmeno."</td><td>".$prijmeni."</td><td>".$email."</td>";
60
61 $con1=mysqli_connect("localhost","root","root");
62 $databaze= "CREATE DATABASE IF NOT EXISTS firma";
63 mysqli_query($con1, $databaze);
64
65
66 $con=mysqli_connect("localhost","root","root","firma");
67 // Check connection
68 if (mysqli_connect_errno())
69 {
70 echo "Failed to connect to MySQL: " . mysqli_connect_error();
71 }
72
73 $test = "SELECT * FROM Uzivatele";
74 $result = mysqli_query($con, $test);
75
76if(empty($result)) {
77 $tabulka = "CREATE TABLE `firma`.`Uzivatele` (
78 `ID` INT NOT NULL AUTO_INCREMENT ,
79 `Jmeno` VARCHAR( 30 ) NOT NULL ,
80 `Prijmeni` VARCHAR( 30 ) NOT NULL ,
81 `Email` VARCHAR( 30 ) NOT NULL ,
82 PRIMARY KEY ( `ID` )
83 ) ENGINE = INNODB
84 ";
85 $vytvoreni = mysqli_query($con, $tabulka);
86 $TABULKA = 0;
87
88 if($vytvoreni){
89 }
90 else{
91 }
92}
93
94
95
96
97 $data = mysqli_query($con,"SELECT * FROM Uzivatele");
98 $row = mysqli_fetch_array($data);
99
100
101 if ($TABULKA == 1) {
102 while($row = mysqli_fetch_array($result))
103 {
104 if ($row['Email'] == $email){
105 $existuje = 1;
106 }
107 }
108 }
109
110 if ($existuje == 0) {
111
112
113
114 $query = "INSERT INTO `Uzivatele` (Jmeno, Prijmeni, Email) VALUES ('$jmeno', '$prijmeni', '$email')";
115 $result = mysqli_query($con, $query);
116
117
118 if($result){
119 echo "<td> <b style=\"color: green; font-size: 24px;\"> Zapsano uspesne do MySQL</b> </td>";
120 }
121 else{
122 echo "<td> <b style=\"color: red; font-size: 24px;\"> Nepodařilo se zaregistrovat, chyba pripojeni k MySQL </b> </td>";
123 }
124 }
125 else
126 {echo "<td> <b style=\"color: red; font-size: 24px;\"> Nepodarilo se zaregistrovat, email jiz je v systemu </b> </td>";}
127
128
129 }
130 else { echo "<td> <b style=\"color: red; font-size: 16px;\">TXT: Nezapsano, mas tam chybu! </b></td>";
131 echo "</tr><tr> <td>".$jmeno."</td><td>".$prijmeni."</td><td>".$email."</td><td> <b style=\"color: red; font-size: 16px;\">MySQL: Nezapsano, mas tam chybu! </b></td>";
132 }
133
134
135
136
137 echo " </tr> </table>";
138}
139
140else {echo "<h1> Nevypsal jsi nic! Podvodniku! </h1>";}
141
142?>
143
144
145
146</head>
147<body>
148<br>
149<center><button onclick="window.location.href='index.php'" class="btn btn-warning">Zpet</button></center>
150
151<br>
152<?php
153
154$con=mysql_connect("localhost","root","root", "firma")
155
156or die("Nelze vykonat definiÄnà dotaz: " . mysql_error());
157
158mysql_select_db("firma");
159
160
161
162
163$result = mysql_query("SELECT * FROM Uzivatele");
164if (!empty($result)) {
165
166echo "
167<div class='container'>
168<table border='1' class='table'>
169<tr>
170<th>ID</th>
171<th>Jmeno</th>
172<th>Prijmeni</th>
173<th>Email</th>
174</tr>";
175
176while($row = mysql_fetch_array($result))
177 {
178 echo "<tr>";
179 echo "<td>" . $row['ID'] . "</td>";
180 echo "<td>" . $row['Jmeno'] . "</td>";
181 echo "<td>" . $row['Prijmeni'] . "</td>";
182 echo "<td>" . $row['Email'] . "</td>";
183 echo "</tr>";
184 }
185echo "</table> </div>";
186}
187
188mysql_close($con);
189?>
190
191
192</body>
193</html>