@@ -2,43 +2,43 @@ |
||
| 2 | 2 | jRequire("ConnectionInterface.php"); |
| 3 | 3 | class ConnectionPostgresqlAdapter implements ConnectionAdapterInterface { |
| 4 | 4 | public $connection; |
| 5 | - public function __construct( $_srv, $_db, $_usr, $_pass ) { |
|
| 5 | + public function __construct($_srv, $_db, $_usr, $_pass) { |
|
| 6 | 6 | try { |
| 7 | 7 | $this->connection = pg_connect("host=$_srv dbname=$_db user=$_usr password=$_pass") |
| 8 | 8 | or die('Could not connect: '.pg_last_error()); |
| 9 | - } catch( Exception $error ) { |
|
| 9 | + } catch (Exception $error) { |
|
| 10 | 10 | Debug::fatal($error->getMessage()); |
| 11 | 11 | exit(); |
| 12 | 12 | } |
| 13 | 13 | } |
| 14 | - public function query( $_query ) { |
|
| 14 | + public function query($_query) { |
|
| 15 | 15 | $this->stdQuery($_query); |
| 16 | 16 | return true; |
| 17 | 17 | } |
| 18 | - public function queryInsert( $_query ) { |
|
| 18 | + public function queryInsert($_query) { |
|
| 19 | 19 | $this->stdQuery($_query); |
| 20 | 20 | return $this->stdQuery("SELECT lastval()"); |
| 21 | 21 | } |
| 22 | - public function queryFetch( $_query ) { |
|
| 22 | + public function queryFetch($_query) { |
|
| 23 | 23 | $result = $this->stdQuery($_query); |
| 24 | 24 | $rows = []; |
| 25 | - while($row = pg_fetch_assoc($result)) |
|
| 25 | + while ($row = pg_fetch_assoc($result)) |
|
| 26 | 26 | $rows[] = $row; |
| 27 | 27 | pg_free_result($result); |
| 28 | 28 | return $rows; |
| 29 | 29 | } |
| 30 | - public function queryArray( $_query ) { |
|
| 30 | + public function queryArray($_query) { |
|
| 31 | 31 | $result = $this->stdQuery($_query); |
| 32 | 32 | $rows = []; |
| 33 | - while($row = pg_fetch_array($result)) |
|
| 33 | + while ($row = pg_fetch_array($result)) |
|
| 34 | 34 | $rows[] = $row; |
| 35 | 35 | pg_free_result($result); |
| 36 | 36 | return $rows; |
| 37 | 37 | } |
| 38 | - protected function stdQuery( $_query ) { |
|
| 38 | + protected function stdQuery($_query) { |
|
| 39 | 39 | $database = $this->connection; |
| 40 | 40 | $result = pg_query($database, $_query); |
| 41 | - if(!$result) { |
|
| 41 | + if (!$result) { |
|
| 42 | 42 | Debug::fatal([ |
| 43 | 43 | "query" => $_query, |
| 44 | 44 | "error" => pg_last_error() |
@@ -2,40 +2,40 @@ |
||
| 2 | 2 | jRequire("ConnectionInterface.php"); |
| 3 | 3 | class ConnectionMysqliAdapter implements ConnectionAdapterInterface { |
| 4 | 4 | public $connection; |
| 5 | - public function __construct( $_srv, $_db, $_usr, $_pass ) { |
|
| 5 | + public function __construct($_srv, $_db, $_usr, $_pass) { |
|
| 6 | 6 | try { |
| 7 | - $this->connection = new mysqli( $_srv, $_usr, $_pass, $_db ); |
|
| 8 | - } catch( Exception $error ) { |
|
| 7 | + $this->connection = new mysqli($_srv, $_usr, $_pass, $_db); |
|
| 8 | + } catch (Exception $error) { |
|
| 9 | 9 | Debug::fatal($error->getMessage()); |
| 10 | 10 | exit(); |
| 11 | 11 | } |
| 12 | 12 | } |
| 13 | - public function query( $_query ) { |
|
| 13 | + public function query($_query) { |
|
| 14 | 14 | $this->stdQuery($_query); |
| 15 | 15 | return true; |
| 16 | 16 | } |
| 17 | - public function queryInsert( $_query ) { |
|
| 17 | + public function queryInsert($_query) { |
|
| 18 | 18 | $this->stdQuery($_query); |
| 19 | 19 | return $this->connection->insert_id; |
| 20 | 20 | } |
| 21 | - public function queryFetch( $_query ) { |
|
| 21 | + public function queryFetch($_query) { |
|
| 22 | 22 | $result = $this->stdQuery($_query); |
| 23 | 23 | $rows = []; |
| 24 | - while($row = $result->fetch_assoc()) |
|
| 24 | + while ($row = $result->fetch_assoc()) |
|
| 25 | 25 | $rows[] = $row; |
| 26 | 26 | return $rows; |
| 27 | 27 | } |
| 28 | - public function queryArray( $_query ) { |
|
| 28 | + public function queryArray($_query) { |
|
| 29 | 29 | $result = $this->stdQuery($_query); |
| 30 | 30 | $rows = []; |
| 31 | - while($row = $result->fetch_array()) |
|
| 31 | + while ($row = $result->fetch_array()) |
|
| 32 | 32 | $rows[] = $row; |
| 33 | 33 | return $rows; |
| 34 | 34 | } |
| 35 | - protected function stdQuery( $_query ) { |
|
| 35 | + protected function stdQuery($_query) { |
|
| 36 | 36 | $database = $this->connection; |
| 37 | 37 | $result = $database->query($_query); |
| 38 | - if(!$result) { |
|
| 38 | + if (!$result) { |
|
| 39 | 39 | Debug::fatal([ |
| 40 | 40 | "query" => $_query, |
| 41 | 41 | "error" => $database->error |
@@ -2,36 +2,36 @@ |
||
| 2 | 2 | jRequire("ConnectionInterface.php"); |
| 3 | 3 | class ConnectionPdoAdapter implements ConnectionAdapterInterface { |
| 4 | 4 | public $connection; |
| 5 | - public function __construct( $_srv, $_db, $_usr, $_pass ) { |
|
| 5 | + public function __construct($_srv, $_db, $_usr, $_pass) { |
|
| 6 | 6 | try { |
| 7 | 7 | $connection = "mysql:host=$_srv;dbname=$_db"; |
| 8 | - $this->connection = new PDO( $connection, $_usr, $_pass, [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"] ); |
|
| 9 | - } catch( Exception $error ) { |
|
| 8 | + $this->connection = new PDO($connection, $_usr, $_pass, [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"]); |
|
| 9 | + } catch (Exception $error) { |
|
| 10 | 10 | Debug::fatal($error->getMessage()); |
| 11 | 11 | exit(); |
| 12 | 12 | } |
| 13 | 13 | } |
| 14 | - public function query( $_query ) { |
|
| 14 | + public function query($_query) { |
|
| 15 | 15 | $this->stdQuery($_query); |
| 16 | 16 | return true; |
| 17 | 17 | } |
| 18 | - public function queryInsert( $_query ) { |
|
| 18 | + public function queryInsert($_query) { |
|
| 19 | 19 | $this->stdQuery($_query); |
| 20 | 20 | return $this->connection->lastInsertId(); |
| 21 | 21 | } |
| 22 | - public function queryFetch( $_query ) { |
|
| 22 | + public function queryFetch($_query) { |
|
| 23 | 23 | $temp = $this->stdQuery($_query); |
| 24 | 24 | return $temp->fetchAll(PDO::FETCH_ASSOC); |
| 25 | 25 | } |
| 26 | - public function queryArray( $_query ) { |
|
| 26 | + public function queryArray($_query) { |
|
| 27 | 27 | $temp = $this->stdQuery($_query); |
| 28 | 28 | return $temp->fetchAll(PDO::FETCH_COLUMN, 0); |
| 29 | 29 | } |
| 30 | - protected function stdQuery( $_query ) { |
|
| 30 | + protected function stdQuery($_query) { |
|
| 31 | 31 | $database = $this->connection; |
| 32 | 32 | $query = $database->prepare($_query); |
| 33 | 33 | $result = $query->execute(); |
| 34 | - if(!$result) { |
|
| 34 | + if (!$result) { |
|
| 35 | 35 | Debug::fatal([ |
| 36 | 36 | "query" => $_query, |
| 37 | 37 | "error" => [ |