Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- class dbFunctions {
- private $userSelect = "userSelect";
- private $passSelect = "XXXXX";
- private $userDelete = "userDelete";
- private $passDelete = "XXXXX";
- protected function connectSelect() {
- $dsn = $this->dsn();
- $this->pdo = new PDO($dsn, $this->userSelect, $this->passSelect, $this->options);
- return $this->pdo;
- }
- protected function connectDelete() {
- $dsn = $this->dsn();
- $this->pdo = new PDO($dsn, $this->userDelete, $this->passDelete, $this->options);
- return $this->pdo;
- }
- public function selectCount($query, $values = []) {
- $result = $this->connectSelect()->prepare($query);
- $result->execute($values);
- $exec = $result->fetch();
- $count = (int)$exec['total'];
- return $count;
- }
- }
- class dbFunctions {
- private $userSelect = "userSelect";
- private $passSelect = "XXXXX";
- private $userDelete = "userDelete";
- private $passDelete = "XXXXX";
- private $selectInstance = null;
- private $deleteInstance = null;
- protected function connectSelect() {
- if ($this->selectInstance === null) {
- $dsn = $this->dsn();
- $this->selectInstance = new PDO($dsn, $this->userSelect, $this->passSelect, $this->options);
- }
- return $this->selectInstance;
- }
- protected function connectDelete() {
- if ($this->deleteInstance === null) {
- $dsn = $this->dsn();
- $this->deleteInstance = new PDO($dsn, $this->userDelete, $this->passDelete, $this->options);
- }
- return $this->deleteInstance;
- }
- public function selectCount($query, $values = []) {
- $result = $this->connectSelect()->prepare($query);
- $result->execute($values);
- $exec = $result->fetch();
- $count = (int)$exec['total'];
- return $count;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement