Untitled

<!DOCTYPE html>
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
		<title>Hello</title>
	</head>
	<body>
<?php
    class Database{

        // specify your own database credentials
        private $host = "localhost";
        private $db_name = "db_pwebpp";
        private $username = "root";
        private $password = "";
        public $conn;

        // get the database connection
        public function getConnection(){

            $this->conn = null;

            try{
                $this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
            }catch(PDOException $exception){
                echo "Connection error: " . $exception->getMessage();
            }

            return $this->conn;
        }
        public function createTable()
        {
            if ( $this->conn = null)
            {
                try{
                    $this->conn = new PDO("mysql:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
                }catch(PDOException $exception){
                    echo "Connection error: " . $exception->getMessage();
                }
            }
            $sql = "CREATE TABLE books(
                isbn INT(10) NOT NULL,
                name VARCHAR(32) DEFAULT NULL,
                published (10) DEFAULT NULL,
                genre VARCHAR(32) DEFAULT NULL,
                author VARCHAR(32) DEFAULT NULL,
                PRIMARY KEY (isbn)
            ) ENGINE=INNODB DEFAULT CHARSET=utf8";
             $stmt = $this->conn->prepare($sql);
             if($stmt->execute()){
                echo "books table created successfully";
            }else{
                die('Could not create table: ' . mysql_error());
            }
        }
    }
    class BookControler{
        private $conn;
        private $tableName = "books";
        public function __construct($db){
            $this->conn = $db;
        }
        public function create($pIsbn, $pName, $pPublished, $pGenre, $pAuthor)
        {
            $query = "INSERT INTO
                    " . $this->table_name . "
                SET
                    isbn=:isbn, name=:name, published=:published, genre=:genre, author=:author";

            $stmt = $this->conn->prepare($query);
            $stmt->bindParam(":isbn", $pIsbn);
            $stmt->bindParam(":name", $pName);
            $stmt->bindParam(":published", $pPublished);
            $stmt->bindParam(":genre", $pGenre);
            $stmt->bindParam(":author", $pAuthor);
            if($stmt->execute()){
                return true;
            }else{
                return false;
            }
        }
        public function getBooksByGenre()
        {
            $Genre = $_GET['searchGenre'];
            $query = "SELECT
                    *
                FROM
                    " . $this->table_name . "
                WHERE
                    genre = ?".$Genre;

            $stmt = $this->conn->prepare( $query );
            $stmt->execute();

            return $stmt;
        }
        public function update($pIsbn, $pNewName){

            $query = "UPDATE
                        " . $this->table_name . "
                    SET
                        name = :name
                    WHERE
                        isbn = :isbn";

            $stmt = $this->conn->prepare($query);
            $stmt->bindParam(':name', $pNewName);
            $stmt->bindParam(':isbn', $pIsbn);
            if($stmt->execute()){
                return true;
            }
            return false;
        }

        public function getBooksOrdered()
        {
            $query = "SELECT
                    *
                FROM
                    " . $this->table_name . "
                ORDER BY
                    author ASC";

            $stmt = $this->conn->prepare( $query );
            $stmt->execute();

            return $stmt;
        }

    }

    $database = new Database();
    $database->createTable();
?>

    <table>
    <tr>
    <td>ISBN</td>
    <td><input type='text' name='isbn'  /></td>
    </tr>

    <tr>
    <td>Name</td>
    <td><input type='text' name='name' /></td>
    </tr>

    <tr>
    <td>Published</td>
    <td><input name='published'></input></td>
    </tr>

    <tr>
    <td>Genre</td>
    <td><input name='genre'></input></td>
    </tr>

    <tr>
    <td>Author</td>
    <td><input name='author'></input></td>
    </tr>

    <tr>
    <td></td>
    <td><button type="submit">Create</button></td>
    </tr>
    <tr>
    <td> get by genre</td>
    </tr>
    <tr>
    <td><input type='text' name='searchGenre' /></td>
    <td><a href='getBooksByGenre' > GO </a></td>
    </tr>
    <tr>
    <td><input type='text' name='updateBook' /></td>
    <td><a href='updateBooks' > update </a></td>
    </tr>

    tr>
    <td></td>
    <td><a href='getAllbooks' > Get all sorted </a></td>
    </tr>

    </table>

    </body>
</html>