Advertisement
Guest User

Untitled

a guest
Oct 3rd, 2016
137
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1. <?php
  2.  
  3. class News
  4. {
  5.     public static function getNewsItemById($id)
  6.     {
  7.         // Запрос к БД
  8.     }
  9.  
  10.     public static function getNewsList()
  11.     {
  12.         $host = 'tutorialsphp';
  13.         $dbname = 'tutorialsphp';
  14.         $user = 'root';
  15.         $password = '';
  16.         $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
  17.  
  18.         $newsList = array();
  19.  
  20.         $result = $db->query('SELECT id, title, date, short_content '
  21.             . 'FROM news '
  22.             . 'ORDER BY date DESC '
  23.             . 'LIMIT 10 ');
  24.  
  25.         $i = 0;
  26.         while($row = $result->fetch()) {
  27.             $newsList[$i]['id'] = $row['id'];
  28.             $newsList[$i]['title'] = $row['title'];
  29.             $newsList[$i]['date'] = $row['date'];
  30.             $newsList[$i]['short_content'] = $row['short_content'];
  31.             $i++;
  32.         }
  33.         return $newsList;
  34.     }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement