Guest User

Untitled

a guest
Dec 3rd, 2017
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.63 KB | None | 0 0
  1. return DB::select('*')->from('users')->where("id",'=',$id);
  2.  
  3. <?php
  4. class Db {
  5. private static $db;
  6. private static $host = 'localhost';
  7. private static $dbname = 'test';
  8. private static $charset = 'utf8';
  9. private static $username = 'root';
  10. private static $password = '';
  11.  
  12. private $select;
  13. private $from;
  14. private $id;
  15.  
  16. static function connect() {
  17. if(empty(self::$db)) {
  18. self::$db = new PDO("mysql:host=".self::$host.";dbname=".self::$dbname.";charset=".self::$charset,
  19. self::$username, self::$password);
  20. }
  21.  
  22. return self::$db;
  23. }
  24.  
  25.  
  26. public function select($mark) {
  27. $this->select = 'SELECT ' . $mark;
  28. return $this;
  29. }
  30.  
  31. public function from($table) {
  32. $this->from = ' FROM ' . $table;
  33. return $this;
  34. }
  35.  
  36. public function where($id) {
  37. $this->where = ' WHERE id = ' . $id;
  38. return $this;
  39. }
  40.  
  41. }
  42.  
  43. class User extends Db {
  44. public function __toString() {
  45. return $this->viewUser();
  46. }
  47.  
  48. public function viewUser() {
  49. return Db::select('*')->from('users')->where('1');
  50. }
  51. }
  52.  
  53. $user = new User;
  54. echo $user->viewUser();
  55.  
  56. print_r((array)$user->viewUser());
  57.  
  58. и получился какой-то бред
  59.  
  60. Array ( [Dbselect] => SELECT * [Dbfrom] => FROM users [Dbid] => [where] => WHERE id = 1 )
  61.  
  62. $user = new User;
  63. $str = '';
  64. foreach((array)$user->viewUser() as $key) {
  65. $str = $str . $key;
  66. }
  67. echo $str;
Add Comment
Please, Sign In to add comment