Advertisement
Guest User

Untitled

a guest
Jul 16th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. $host = 'localhost';
  2. $bdname = 'mvc_site';
  3. $user = 'root';
  4. $password = '';
  5. $db = new PDO("mysql:host=$host;dbname=$bdname", $user, $password);
  6.  
  7. $newsList = array();
  8.  
  9. $result = $bd->query('SELECT id, title, short_content '
  10. . 'FROM news '
  11. . 'ORDER BY date DESC '
  12. . 'LIMIT 10');
  13.  
  14. $i = 0;
  15. while ($row = $result->fetch()) {
  16. $newsList[$i]['id'] = $row['id'];
  17. $newsList[$i]['title'] = $row['title'];
  18. $newsList[$i]['date'] = $row['date'];
  19. $newsList[$i]['short_content'] = $row['short_content'];
  20. $i++;
  21. }
  22.  
  23. return $newsList;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement