Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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);
- ?>
Add Comment
Please, Sign In to add comment