<?php
class simpleCMS{
    public $host="localhost";
    public $username="root";
    public $password="";
    public $db = 'testDB';


    public function connectDB() {
        $link = mysql_connect($this->host, $this->username, $this->password); //подключаемся к серверу MySQL
        if (!$link) {
            die('Ошибка соединения: ' . mysql_error());
        }
        mysql_select_db($this->db) or die("Не могу найти БД. " . mysql_error()); //подсоеденяем БД
            $this->buildDB();//вызываем метод внутри другого
        return $link;
    }

    public function buildDB() {
        $sql = "CREATE TABLE IF NOT EXISTS `messages` (
                `mid` int(11) NOT NULL,
                `title` varchar(150) DEFAULT NULL,
                `bodytext` text,
                `created` varchar(100) DEFAULT NULL,
                 PRIMARY KEY (`mid`)
               ) ENGINE=InnoDB DEFAULT CHARSET=utf8";
          $result =  mysql_query($sql);
          echo $result;
    }

    public function write($p) {
        $sql = 'INSERT INTO Messages(title, body, created) VALUES("' . $p["title"] . '", "' . $p["bodytext"] . '", ' . time() .')';
        return mysql_query($sql);
    }

    public function display_public() {
        $content = '';

        $sql = 'SELECT * FROM Messages';
        $result = mysql_query($sql);

        while($row = mysql_fetch_array($result)) {
            echo '<div class="post">';
            echo '<span class="time">#' . $row['mid'] . 'от' .date('d-m-Y', $row['created']) . '</span><h2>' . $row['title'] . '</h2>';
            echo '<p>' . $row['bodytext']. '</p>';
            echo '</div>';
        }
        $content .= '<p><a href="/index.php?admin=1" > Добавить сообщение</a>>/p>';
        return $content;
    }



}
$obj = new simpleCMS;
$db_connection = $obj->connectDB();
mysql_close($db_connection);
$item = array("title" => "заголовок", "bodytext" => "текст");
echo $obj->write($item);
?>