Advertisement
Guest User

12345

a guest
Sep 2nd, 2014
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.02 KB | None | 0 0
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: 1
  5.  * Date: 01.09.14
  6.  * Time: 22:49
  7.  */
  8. abstract class AbstractModel
  9. {
  10.     static protected $table;
  11.  
  12.     static protected function getDbh() {
  13.         $dsn = 'mysql:dbname = articles:host = localhost';
  14.         $res = new Pdo($dsn, 'root', '');
  15.         if (false !== $res) {
  16.            echo 'БД подключена';
  17.         }
  18.         else {
  19.             echo 'Ошибка соединения с БД';
  20.         }
  21.         return $res;
  22.     }
  23.  
  24.     static public function findAll() {
  25.  
  26.         $sql = "SELECT * FROM :table";
  27.         $sth = self::getDbh()->prepare($sql);
  28.        //var_dump($sth); die;
  29.         $sth -> execute(array(':table' => static::$table));
  30.         var_dump($sth->fetchAll());
  31.        die;
  32.         //return $sth->fetchAll();
  33.     }
  34. }
  35.  
  36.  
  37.  
  38.  
  39.  
  40. <?php
  41. /**
  42.  * Created by PhpStorm.
  43.  * User: 1
  44.  * Date: 02.09.14
  45.  * Time: 9:21
  46.  */
  47. class Article extends AbstractModel
  48. {
  49.     static protected $table = 'text';
  50.  
  51.     //$news = Article::findAll();
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement