| 1: | <?php
|
| 2: | namespace Opencart\System\Library\DB;
|
| 3: | |
| 4: | |
| 5: | |
| 6: | |
| 7: |
|
| 8: | class PDO {
|
| 9: | |
| 10: | |
| 11: |
|
| 12: | private ?\PDO $connection;
|
| 13: | |
| 14: | |
| 15: |
|
| 16: | private array $data = [];
|
| 17: | |
| 18: | |
| 19: |
|
| 20: | private int $affected;
|
| 21: |
|
| 22: | |
| 23: | |
| 24: | |
| 25: | |
| 26: | |
| 27: | |
| 28: | |
| 29: | |
| 30: |
|
| 31: | public function __construct(string $hostname, string $username, string $password, string $database, string $port = '') {
|
| 32: | if (!$port) {
|
| 33: | $port = '3306';
|
| 34: | }
|
| 35: |
|
| 36: | try {
|
| 37: | $pdo = new \PDO('mysql:host=' . $hostname . ';port=' . $port . ';dbname=' . $database . ';charset=utf8mb4', $username, $password, [\PDO::ATTR_PERSISTENT => false, \PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8mb4 COLLATE utf8mb4_general_ci']);
|
| 38: | } catch (\PDOException $e) {
|
| 39: | throw new \Exception('Error: Could not make a database link using ' . $username . '@' . $hostname . '!');
|
| 40: | }
|
| 41: |
|
| 42: | $this->connection = $pdo;
|
| 43: |
|
| 44: | $this->query("SET SESSION sql_mode = 'NO_ZERO_IN_DATE,NO_ENGINE_SUBSTITUTION'");
|
| 45: | $this->query("SET FOREIGN_KEY_CHECKS = 0");
|
| 46: |
|
| 47: |
|
| 48: | $this->query("SET `time_zone` = '" . $this->escape(date('P')) . "'");
|
| 49: | }
|
| 50: |
|
| 51: | |
| 52: | |
| 53: | |
| 54: | |
| 55: | |
| 56: | |
| 57: |
|
| 58: | public function query(string $sql) {
|
| 59: | $sql = preg_replace('/(?:\'\:)([a-z0-9]*.)(?:\')/', ':$1', $sql);
|
| 60: |
|
| 61: | $statement = $this->connection->prepare($sql);
|
| 62: |
|
| 63: | try {
|
| 64: | if ($statement && $statement->execute($this->data)) {
|
| 65: | $this->data = [];
|
| 66: |
|
| 67: | if ($statement->columnCount()) {
|
| 68: | $data = $statement->fetchAll(\PDO::FETCH_ASSOC);
|
| 69: | $statement->closeCursor();
|
| 70: |
|
| 71: | $result = new \stdClass();
|
| 72: | $result->row = $data[0] ?? [];
|
| 73: | $result->rows = $data;
|
| 74: | $result->num_rows = count($data);
|
| 75: | $this->affected = 0;
|
| 76: |
|
| 77: | return $result;
|
| 78: | } else {
|
| 79: | $this->affected = $statement->rowCount();
|
| 80: | $statement->closeCursor();
|
| 81: |
|
| 82: | return true;
|
| 83: | }
|
| 84: | } else {
|
| 85: | return true;
|
| 86: | }
|
| 87: | } catch (\PDOException $e) {
|
| 88: | throw new \Exception('Error: ' . $e->getMessage() . ' <br/>Error Code : ' . $e->getCode() . ' <br/>' . $sql);
|
| 89: | }
|
| 90: | }
|
| 91: |
|
| 92: | |
| 93: | |
| 94: | |
| 95: | |
| 96: | |
| 97: | |
| 98: |
|
| 99: | public function escape(string $value): string {
|
| 100: | $key = ':' . count($this->data);
|
| 101: |
|
| 102: | $this->data[$key] = $value;
|
| 103: |
|
| 104: | return $key;
|
| 105: | }
|
| 106: |
|
| 107: | |
| 108: | |
| 109: | |
| 110: | |
| 111: |
|
| 112: | public function countAffected(): int {
|
| 113: | return $this->affected;
|
| 114: | }
|
| 115: |
|
| 116: | |
| 117: | |
| 118: | |
| 119: | |
| 120: |
|
| 121: | public function getLastId(): ?int {
|
| 122: | $id = $this->connection->lastInsertId();
|
| 123: |
|
| 124: | return $id ? (int)$id : null;
|
| 125: | }
|
| 126: |
|
| 127: | |
| 128: | |
| 129: | |
| 130: | |
| 131: |
|
| 132: | public function isConnected(): bool {
|
| 133: | return $this->connection !== null;
|
| 134: | }
|
| 135: |
|
| 136: | |
| 137: | |
| 138: | |
| 139: | |
| 140: |
|
| 141: | public function __destruct() {
|
| 142: | $this->connection = null;
|
| 143: | }
|
| 144: | }
|
| 145: | |