Example #1
0
 public function connect()
 {
     Conn::get_connection();
     return $this->buildDB();
 }
Example #2
0
    private function buildDB()
    {
        $baza = Conn::$database;
        $sql = <<<MySQL_QUERY
CREATE TABLE IF NOT EXISTS {$baza}.{$this->table} (
Id\t\t\t     INT(11) AUTO_INCREMENT,
Title\t\t     VARCHAR(150) NOT NULL,
Content\t\t   TEXT,
AuthorID     INT(11),
Timestamp \t TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (Id)
)
MySQL_QUERY;
        return mysqli_query(Conn::get_connection(), $sql);
    }