@@ -2,39 +2,39 @@ |
||
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 | $this->connection = pg_connect("host=$_srv dbname=$_db user=$_usr password=$_pass") |
7 | 7 | or die('Could not connect: '.pg_last_error()); |
8 | 8 | } |
9 | - public function query( $_query ) { |
|
9 | + public function query($_query) { |
|
10 | 10 | $this->stdQuery($_query); |
11 | 11 | return true; |
12 | 12 | } |
13 | - public function queryInsert( $_query ) { |
|
13 | + public function queryInsert($_query) { |
|
14 | 14 | $this->stdQuery($_query); |
15 | 15 | return $this->stdQuery("SELECT lastval()"); |
16 | 16 | } |
17 | - public function queryFetch( $_query ) { |
|
17 | + public function queryFetch($_query) { |
|
18 | 18 | $result = $this->stdQuery($_query); |
19 | 19 | $rows = []; |
20 | - while($row = pg_fetch_assoc($result)) |
|
20 | + while ($row = pg_fetch_assoc($result)) |
|
21 | 21 | $rows[] = $row; |
22 | 22 | pg_free_result($result); |
23 | 23 | return $rows; |
24 | 24 | } |
25 | - public function queryArray( $_query ) { |
|
25 | + public function queryArray($_query) { |
|
26 | 26 | $result = $this->stdQuery($_query); |
27 | 27 | $rows = []; |
28 | - while($row = pg_fetch_array($result)) |
|
28 | + while ($row = pg_fetch_array($result)) |
|
29 | 29 | $rows[] = $row; |
30 | 30 | pg_free_result($result); |
31 | 31 | return $rows; |
32 | 32 | } |
33 | - protected function stdQuery( $_query ) { |
|
33 | + protected function stdQuery($_query) { |
|
34 | 34 | $database = $this->connection; |
35 | 35 | $error = "Error query [$_query]"; |
36 | 36 | $result = pg_query($database, $_query); |
37 | - if(!$result) { |
|
37 | + if (!$result) { |
|
38 | 38 | echo "$_query<br>"; |
39 | 39 | echo "Something wrong: $error"; |
40 | 40 | var_dump(pg_last_error()); |