Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class with_DB {
- public $host = 'localhost';
- public $username = 'root';
- public $password = "";
- public $db = 'testdb';
- public function connect_DB() {
- $link = mysql_connect($this->host, $this->username, $this->password);
- if(!link) {
- die( "Нет подключения к БД:". mysql_error());
- }
- mysql_select_db($this->db) or die(mysql_error());
- return $link;
- }
- public function write($p) { //функция записи сообщения
- $sql = 'INSERT INTO messages(title, body, created, contacts) VALUES("' . $p["title"] . '" , "' . $p["body"] . '", ' . time() .', "'.$p["contacts"].'")';
- return mysql_query($sql) or die(mysql_error());
- }
- public function display_public() { //функция вывода сообщений
- $content = '';
- $sql = 'SELECT mid, title, body FROM messages';
- $result = mysql_query($sql) or die(mysql_error());
- $pages = array ();
- while($row = mysql_fetch_assoc($result)) {
- $pages[$row['mid']]= array("title" => $row['title'], "body" => $row['body']);
- }
- $page_id = 1;
- if(isset($_GET['id'])) {
- $page_id = $_GET['id'];
- $test = 'SELECT mid, title, body FROM messages WHERE mid='.$page_id;
- mysql_query($test) or die(mysql_error());
- }
- if (!isset($pages[$page_id])) $page_id = 1;
- $page = $pages[$page_id];
- echo $page_id;
- $content .= '<html>
- <head>
- <title>'.$page['title'].'</title>
- </head>
- <body>
- <p><a href="?id=1">Первая</a></p><br>
- <p><a href="?id=2">Вторая</a></p><br>
- <p><a href="?id=3">Третья</a></p><br>
- <p><a href="?id=4">Четвертая</a></p><br>
- <p><a href="?id=5">Пятая</a></p><br>
- <p> '.$page['body'].'</p>
- </body>
- </html>';
- return $content;
- }
- }
- $obj = new with_DB;
- $db_connection = $obj->connect_DB();
- $item = array("title" => "заголовок", "body" => "текст", "contacts" => "номер");
- $obj->write($item);
- echo $obj->display_public();
- mysql_close($db_connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement