Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ____index. php:
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title></title>
- </head>
- <body>
- <form action="" method="get">
- <input type="number" name="id">
- <input type="submit" value="SELECT" name="s">
- </form>
- <?php
- include 'Clovek.php';
- include 'spravceObjektu.php';
- if (isset($_GET["s"])){
- $obj = new spravceObjektu();
- } if ($_GET["id"] == "") {
- $obj->objekty();
- } else {
- $obj->objekt($_GET["id"]);
- }
- ?>
- </body>
- </html>
- ____Clovek.php:
- <?php
- class Clovek {
- public $id;
- public $jmeno;
- public $prijmeni;
- public $datum;
- }
- ____MyPDO.php:
- <?php
- class MyPDO {
- public function connect() {
- $dsn = "mysql:host=localhost;dbname=clovek;charset=utf8";
- $user = 'root';
- $pass = '';
- try {
- $connect = new PDO($dsn, $user, $pass);
- return $connect;
- } catch (\PDOException $e) {
- throw new \PDOException($e->getMessage(), (int)$e->getCode());
- }
- }
- }
- ____spravceObjektu.php:
- <?php
- include 'MyPDO.php';
- class spravceObjektu extends MyPDO {
- public function objekty() {
- $pdo = $this->connect()->prepare("SELECT Jmeno, Prijmeni, Datum FROM clovek");
- $pdo->execute();
- while ($row = $pdo->fetch()){
- echo $row["Jmeno"] . " | ";
- echo $row["Prijmeni"] . " | ";
- echo $row["Datum"] . "<p></p>";
- }
- }
- public function objekt($id){
- $pdo = $this->connect()->prepare("SELECT Jmeno, Prijmeni, Datum FROM clovek WHERE id = ?");
- $pdo->bindParam(1, $id);
- $pdo->execute();
- while ($row = $pdo->fetch()){
- echo $row["Jmeno"] . " | ";
- echo $row["Prijmeni"] . " | ";
- echo $row["Datum"] . "<p></p>";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement