Advertisement
Guest User

Untitled

a guest
May 3rd, 2019
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.82 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3.     <head>
  4.         <meta charset="UTF-8">
  5.         <title>Ne petku ne, ja jsem v tom nevinne :(</title>
  6.     </head>
  7.     <body>
  8.         <?php
  9.         require_once 'trida.php';
  10.         $trida = new trida($nazev, $typ, $pocetZaku);
  11.         $skoly = $trida->selectAll();
  12.         foreach ($skoly as $skola) {
  13.             echo "<p>Nazev skoly: " . $skola['nazev'] . "<a href='detail.php?id=" . $skola['id'] . "'>Detail</a> <a href=upraveni.php?id=" . $skola['id'] . ">Upraveni</a></p>";
  14.         }
  15.         ?>
  16.     </body>
  17. </html>
  18.  
  19. ---------------- TŘÍDA
  20.  
  21. <?php
  22.  
  23. class trida {
  24.  
  25.     public $nazev;
  26.     public $typ;
  27.     public $pocetZaku;
  28.  
  29.     function __construct($nazev, $typ, $pocetZaku) {
  30.         $this->nazev = $nazev;
  31.         $this->typ = $typ;
  32.         $this->pocetZaku = $pocetZaku;
  33.     }
  34.  
  35.     function selectAll() {
  36.         $ukazVse = $this->connect()->prepare("SELECT * FROM `skola`");
  37.         $ukazVse->execute();
  38.         return $ukazVse->fetchAll(PDO::FETCH_ASSOC);
  39.     }
  40.  
  41.     function selectOne($id) {
  42.         $ukazJeden = $this->connect()->prepare("SELECT * FROM `skola` WHERE `id`=" . $_GET['id'] . "");
  43.         $ukazJeden->execute();
  44.         return $ukazJeden->fetchAll(PDO::FETCH_ASSOC);
  45.     }
  46.  
  47.     function uprava($id) {
  48.         $vloz = $this->connect()->prepare("UPDATE `skola` SET `nazev` = ?, `typ` = ?, `pocetZaku` = ? WHERE `id`= " . $_GET['id'] . "");
  49.         $vloz->bindParam(1, $this->nazev);
  50.         $vloz->bindParam(2, $this->typ);
  51.         $vloz->bindParam(3, $this->pocetZaku);
  52.         $vloz->execute();
  53.     }
  54.  
  55.     function connect() {
  56.         $dsn = "mysql:dbname=skola;host=localhost";
  57.         $user = "root";
  58.         $password = "";
  59.  
  60.         $conn = new PDO($dsn, $user, $password);
  61.         return $conn;
  62.     }
  63.  
  64. }
  65.  
  66. ----------------- ÚPRAVA
  67.  
  68. <html>
  69.     <head>
  70.         <meta charset="UTF-8">
  71.         <title>Ne petku ne, ja jsem v tom nevinne :(</title>
  72.     </head>
  73.     <body>
  74.         <form method="post">
  75.             <input type="text" name="nazev" placeholder="nazev"><p>
  76.                 <input type="radio" name="typ" id="z" value="z">Zakladni skola
  77.                 <input type="radio" name="typ" id="s" value="s">Stredni skola
  78.             <input type="radio" name="typ" id="v" value="v">Vysoka skola<p>
  79.             <input type="number" name="pocetZaku" placeholder="pocet zaku"><p>
  80.                 <input type="submit" name="submit">
  81.         </form>
  82.  
  83.         <?php
  84.         require_once 'trida.php';
  85.         if (isset($_POST['submit'])) {
  86.             $id = $_GET['id'];
  87.            
  88.             $nazev = $_POST['nazev'];
  89.             $typ = $_POST['typ'];
  90.             $pocetZaku = $_POST['pocetZaku'];
  91.            
  92.             $trida = new trida($nazev, $typ, $pocetZaku);
  93.             $trida->uprava($id);
  94.         }
  95.         ?>
  96.     </body>
  97. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement