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());
- while($row = mysql_fetch_array($result) or die(mysql_error())) {
- $pages = array (
- $row->mid => array("title" => $row->title, "body" => $row->body)
- );
- $page_id = $row->mid;
- if(isset($_GET['id'])) {
- $page_id = $_GET['id'];
- }
- if (!isset($pages[$page_id])) $page_id = $row->mid;
- $page = $pages[$page_id];
- $content .= '<html>
- <head>
- <title>'.$page[title].'</title>
- </head>
- <body>
- <p><a href="?id=' . $page[mid] . '">Первая</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" => "номер");
- echo $obj->write($item);
- echo $obj->display_public();
- mysql_close($db_connection);
- ?>
Add Comment
Please, Sign In to add comment