Taeluf.com

Cook.php

<?php

namespace Tlf;

class Cook {

    static protected $create = 
        <<<MYSQL
            DROP TABLE IF EXISTS cook;
            CREATE TABLE cook
                (id INT AUTO_INCREMENT PRIMARY KEY,
                    name VARCHAR(256),
                    firstYearOfCooking INT
                )
            ;
        MYSQL
    ;


    static protected $queries = [
        'getPotions' => 
        <<<MYSQL
            SELECT * FROM recipe WHERE name LIKE '%Potion%'
        MYSQL,
    ];


    public function __construct($row){
        foreach ($row as $key=>$value){
            $this->$key = $value;
        }
    }



    static public function getSql($name){
        return static::$queries[$name];
    }

    static public function createTable(){
        return static::$create;
    }
}