Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Ne petku ne, ja jsem v tom nevinne :(</title>
- </head>
- <body>
- <?php
- require_once 'trida.php';
- $trida = new trida($nazev, $typ, $pocetZaku);
- $skoly = $trida->selectAll();
- foreach ($skoly as $skola) {
- 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>";
- }
- ?>
- </body>
- </html>
- ---------------- TŘÍDA
- <?php
- class trida {
- public $nazev;
- public $typ;
- public $pocetZaku;
- function __construct($nazev, $typ, $pocetZaku) {
- $this->nazev = $nazev;
- $this->typ = $typ;
- $this->pocetZaku = $pocetZaku;
- }
- function selectAll() {
- $ukazVse = $this->connect()->prepare("SELECT * FROM `skola`");
- $ukazVse->execute();
- return $ukazVse->fetchAll(PDO::FETCH_ASSOC);
- }
- function selectOne($id) {
- $ukazJeden = $this->connect()->prepare("SELECT * FROM `skola` WHERE `id`=" . $_GET['id'] . "");
- $ukazJeden->execute();
- return $ukazJeden->fetchAll(PDO::FETCH_ASSOC);
- }
- function uprava($id) {
- $vloz = $this->connect()->prepare("UPDATE `skola` SET `nazev` = ?, `typ` = ?, `pocetZaku` = ? WHERE `id`= " . $_GET['id'] . "");
- $vloz->bindParam(1, $this->nazev);
- $vloz->bindParam(2, $this->typ);
- $vloz->bindParam(3, $this->pocetZaku);
- $vloz->execute();
- }
- function connect() {
- $dsn = "mysql:dbname=skola;host=localhost";
- $user = "root";
- $password = "";
- $conn = new PDO($dsn, $user, $password);
- return $conn;
- }
- }
- ----------------- ÚPRAVA
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Ne petku ne, ja jsem v tom nevinne :(</title>
- </head>
- <body>
- <form method="post">
- <input type="text" name="nazev" placeholder="nazev"><p>
- <input type="radio" name="typ" id="z" value="z">Zakladni skola
- <input type="radio" name="typ" id="s" value="s">Stredni skola
- <input type="radio" name="typ" id="v" value="v">Vysoka skola<p>
- <input type="number" name="pocetZaku" placeholder="pocet zaku"><p>
- <input type="submit" name="submit">
- </form>
- <?php
- require_once 'trida.php';
- if (isset($_POST['submit'])) {
- $id = $_GET['id'];
- $nazev = $_POST['nazev'];
- $typ = $_POST['typ'];
- $pocetZaku = $_POST['pocetZaku'];
- $trida = new trida($nazev, $typ, $pocetZaku);
- $trida->uprava($id);
- }
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement