Untitled

 avatar
unknown
php
2 years ago
1.6 kB
2
Indexable
<?php
    class Book {
        private $id;
        private $title;
        private $author;
        private $year;
        
        public function __construct($id, $title, $author, $year) {
            $this->id = $id;
            $this->$title = $title;
            $this->author = $author;
            $this->year = $year;
        }
        
        public function __toString() {
            return $this->id ." " .$this->title ." " .$this->author ." " .$this->year ."<br>";
        }
    }
    
    class Db {
        const host = "localhost";
        const user = "root";
        const pass = "";
        const db_name= "book";
        private $dbh;
        
        
        public function __construct() {
            $this->dbh = new mysqli(self::host, self::user, self::pass, self::db_name);
            
            if (mysqli_connect_errno()) {
                die("Connection to database failed!");
            }
        }
        
        public function __destruct() {
            $this->dbh->close();
        }
        
        public function getAllBooks() {
            try {
                $query = "SELECT * FROM knjiga";
                $res = $this->dbh->query($query);
                
                $books = [];
                while ($row = $res->fetch_array()) {
                    $book = new Book($row[0], $row[1], $row[2], $row[3]);
                    $books[] = $book;
                }
                return $books;
                
            } catch (Exception $ex) {
                die($ex->getMessage());
            }
        }
    }
?>
Editor is loading...