· 8 years ago · Jan 11, 2018, 10:50 PM
1<!DOCTYPE html>
2<body>
3<?php
4include 'pokaz_kod.php';
5
6 try {
7 $db = new PDO('mysql:host=mysql.cba.pl; dbname=mickeys; encoding=utf8','sromekm','Qwerty123');
8 echo 'Połączono z bazą danych <br><br>';
9 } catch (PDOException $e)
10 {
11 echo 'Nie można połączyć z bazą danych <br>';
12 }
13
14 if(isset($_POST['stworz']))
15 {
16 $sql = "CREATE TABLE IF NOT EXISTS tabela(Id INT(6) AUTO_INCREMENT PRIMARY KEY,Imie VARCHAR(20) NOT NULL,Nazwisko VARCHAR(20) NOT NULL);";
17
18 $db->exec($sql);
19 $st = $db->prepare("INSERT INTO tabela(imie, nazwisko) VALUES(?,?)");
20 $st->execute(array("Tomasz","Witowski"));
21 $st->execute(array("Andrzej","Duda"));
22 }
23
24 if(isset($_POST['ut']))
25 {
26 $sql = "DROP TABLE tabela;";
27 $db->exec($sql);
28 }
29
30 if(isset($_POST['usun']))
31 {
32 $i = "'".$_POST["id"]."'";
33 $sql = "DELETE FROM tabela WHERE Id = $i;";
34 $db->exec($sql);
35 }
36
37 if((isset($_POST['dodaj'])) && ($db->query("SELECT 1 FROM tabela LIMIT 1;")))
38 {
39 $st = $db->prepare("INSERT INTO tabela(imie, nazwisko) VALUES(?,?)");
40 $st->execute(array($_POST["imie"],$_POST["nazwisko"]));
41 }
42 elseif(isset($_POST['dodaj']))
43 {
44 echo "Tabela nie jest utworzona.";
45 }
46
47 echo "<form method = 'post'>Dodaj 2 rekordy do tabeli. <input type = 'submit' name='stworz' value='StwĂłrz'></form><br>";
48
49 echo "<form method='post'><input type ='text' name = 'imie' placeholder = 'Imie'><input type='text' name='nazwisko' placeholder = 'Nazwisko'><input type='submit' name='dodaj' value='Dodaj'></form>";
50
51 echo "<form method ='post'><input type = 'text' name = 'Id' placeholder = 'id'><input type= 'submit' name = 'usun' value = 'Usun rekord'></form></br>";
52
53 echo "Usuń tabele.<form method = 'post'><input type='submit' name='ut' value = 'Usuń'></form>";
54
55 $query = $db->prepare('SELECT * FROM mickeys.tabela');
56
57 $query->execute();
58
59 $res = $query->fetchAll();
60
61 echo "<table border>";
62
63 echo "<tr><th>Id</th><th>Imie</th><th>Nazwisko</th></tr>";
64
65 foreach($res as $r)
66 {
67 echo "<tr><td>".$r["Id"]."</td><td>".$r["Imie"]."</td><td>".$r["Nazwisko"]."</td></tr>";
68 }
69
70 echo "</table>";
71
72 ?>
73</body>