Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set("display_errors", 1);
- class dbConnect {
- private $host = "localhost";
- private $db = "mybd";
- private $user = "root";
- public $pdo;
- private $pass = "root";
- private $charset = "utf8";
- public $tableName;
- private $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- ];
- protected function __construct() {
- $dsn = "mysql:host=$this->host;dbname=$this->db;charset=$this->charset";
- $this->pdo = new PDO($dsn, $this->user, $this->pass, $this->opt);
- }
- public function getAll() {
- $stmt = $this->pdo->prepare("SELECT * FROM $this->tableName");
- $stmt->execute()->fetchAll();
- return $data;
- }
- public function getRow() {
- $$stmt = $this->pdo->prepare("SELECT * FROM $this->tableName WHERE id = ?")
- $oneRow = $stmt->execute([$id])->fetchAll();
- return $oneRow;
- }
- }
- }
- class Users extends dbConnect {
- public $id;
- public function __construct() {
- $this->tableName = "users";
- parent::__construct();
- }
- }
- function dump($variable) {
- echo '<pre>';
- var_dump($variable);
- echo '</pre>';
- }
- $user1 = new Users();
- $user1->getAll();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement