Advertisement
Guest User

Untitled

a guest
Apr 5th, 2019
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <!DOCTYPE html>
  2. <?php
  3. require_once 'neco.php';
  4. if (isset($_POST["submit"])) {
  5.     $nazev = $_POST["nazev"];
  6.     $cislo = $_POST["cislo"];
  7.  
  8.     $neco = new neco($nazev, $cislo);
  9.     $neco->insertNeco();
  10. }
  11. if (isset($_POST["ukazVsechny"])) {
  12.     $nazev = $_POST["nazev"];
  13.     $cislo = $_POST["cislo"];
  14.     $neco = new neco($nazev, $cislo);
  15.  
  16.     $people = $neco->selectAll();
  17.     foreach ($people as $clovek) {
  18.         echo "<p>Nazyvam se " . $clovek['nazev'] . " a mam cislo " . $clovek['cislo'] . "</p>";
  19.     }
  20. }
  21. ?>
  22. <html>
  23.     <head>
  24.         <meta charset="UTF-8">
  25.         <title>neco</title>
  26.     </head>
  27.     <body>
  28.         <form method="post">
  29.             Nazev<input type="text" name="nazev"><br>
  30.             Cislo<input type="number" name="cislo"><br>
  31.             <input type="submit" value="submit" name="submit">
  32.             <input type="submit" value="Ukaz vsechny" name="ukazVsechny">
  33.         </form>
  34.     </body>
  35. </html>
  36.  
  37. --------------------
  38.  
  39. <?php
  40.  
  41. class neco {
  42.  
  43.     public $nazev;
  44.     public $cislo;
  45.  
  46.     function __construct($nazev, $cislo) {
  47.         $this->nazev = $nazev;
  48.         $this->cislo = $cislo;
  49.     }
  50.  
  51.     function insertNeco() {
  52.         $vloz = $this->connect()->prepare("INSERT INTO `neco` (`nazev`, `cislo`) VALUES (?, ?)");
  53.         $vloz->bindParam(1, $this->nazev);
  54.         $vloz->bindParam(2, $this->cislo);
  55.         $vloz->execute();
  56.     }
  57.  
  58.     function selectAll() {
  59.         $ukazVsechny = $this->connect()->prepare("SELECT * FROM `neco` ORDER BY `nazev`");
  60.         $ukazVsechny->execute();
  61.         return $ukazVsechny->fetchAll(PDO::FETCH_ASSOC);
  62.     }
  63.  
  64.     function connect() {
  65.         $dsn = "mysql:dbname=neco;host=localhost";
  66.         $user = "root";
  67.         $password = "";
  68.  
  69.         $conn = new PDO($dsn, $user, $password);
  70.  
  71.         return $conn;
  72.     }
  73.  
  74. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement