@@ -2,51 +2,51 @@ |
||
2 | 2 | jRequire("../Module/Module.php"); |
3 | 3 | requireComponents("Adapters"); |
4 | 4 | class Connection extends Module { |
5 | - public $database; |
|
6 | - public $info; |
|
7 | - public function __construct() { |
|
8 | - parent::__construct(); |
|
9 | - $args = func_get_args(); |
|
10 | - $count = func_num_args(); |
|
11 | - if (method_exists($this,$func='__construct'.$count)) |
|
12 | - call_user_func_array(array($this,$func),$args); |
|
13 | - } |
|
14 | - public function __construct0() { |
|
15 | - $this->database = null; |
|
16 | - } |
|
17 | - public function __construct4 ( $_srv, $_db, $_usr, $_pass ) { |
|
18 | - $this->setConnection($_srv, $_db, $_usr, $_pass, "pdo"); |
|
19 | - } |
|
20 | - public function __construct5 ( $_srv, $_db, $_usr, $_pass, $_type ) { |
|
21 | - $type = $this->getConnectionType($_type); |
|
22 | - $this->setConnection($_srv, $_db, $_usr, $_pass, $type); |
|
23 | - } |
|
24 | - protected function setConnection ( $_srv, $_db, $_usr, $_pass, $_type ) { |
|
25 | - switch ($_type) { |
|
26 | - case "mysqli": |
|
27 | - $this->database = new ConnectionMysqliAdapter($_srv, $_db, $_usr, $_pass); |
|
28 | - break; |
|
29 | - case "postgresql": |
|
30 | - $this->database = new ConnectionPostgresqlAdapter($_srv, $_db, $_usr, $_pass); |
|
31 | - break; |
|
32 | - default: |
|
33 | - $this->database = new ConnectionPdoAdapter($_srv, $_db, $_usr, $_pass); |
|
34 | - break; |
|
35 | - } |
|
36 | - $this->setConnectionParameters( $_srv, $_db, $_usr, $_pass); |
|
37 | - } |
|
38 | - protected function getConnectionType( $_type ) { |
|
39 | - foreach ($_type as $key => $value) |
|
40 | - if($value) |
|
41 | - return $key; |
|
42 | - return "pdo"; |
|
43 | - } |
|
44 | - protected function setConnectionParameters( $_srv, $_db, $_usr, $_pass) { |
|
45 | - $this->info = []; |
|
46 | - $this->info["server"] = $_srv; |
|
47 | - $this->info["database"] = $_db; |
|
48 | - $this->info["user"] = $_usr; |
|
49 | - $this->info["password"] = $_pass; |
|
50 | - } |
|
5 | + public $database; |
|
6 | + public $info; |
|
7 | + public function __construct() { |
|
8 | + parent::__construct(); |
|
9 | + $args = func_get_args(); |
|
10 | + $count = func_num_args(); |
|
11 | + if (method_exists($this,$func='__construct'.$count)) |
|
12 | + call_user_func_array(array($this,$func),$args); |
|
13 | + } |
|
14 | + public function __construct0() { |
|
15 | + $this->database = null; |
|
16 | + } |
|
17 | + public function __construct4 ( $_srv, $_db, $_usr, $_pass ) { |
|
18 | + $this->setConnection($_srv, $_db, $_usr, $_pass, "pdo"); |
|
19 | + } |
|
20 | + public function __construct5 ( $_srv, $_db, $_usr, $_pass, $_type ) { |
|
21 | + $type = $this->getConnectionType($_type); |
|
22 | + $this->setConnection($_srv, $_db, $_usr, $_pass, $type); |
|
23 | + } |
|
24 | + protected function setConnection ( $_srv, $_db, $_usr, $_pass, $_type ) { |
|
25 | + switch ($_type) { |
|
26 | + case "mysqli": |
|
27 | + $this->database = new ConnectionMysqliAdapter($_srv, $_db, $_usr, $_pass); |
|
28 | + break; |
|
29 | + case "postgresql": |
|
30 | + $this->database = new ConnectionPostgresqlAdapter($_srv, $_db, $_usr, $_pass); |
|
31 | + break; |
|
32 | + default: |
|
33 | + $this->database = new ConnectionPdoAdapter($_srv, $_db, $_usr, $_pass); |
|
34 | + break; |
|
35 | + } |
|
36 | + $this->setConnectionParameters( $_srv, $_db, $_usr, $_pass); |
|
37 | + } |
|
38 | + protected function getConnectionType( $_type ) { |
|
39 | + foreach ($_type as $key => $value) |
|
40 | + if($value) |
|
41 | + return $key; |
|
42 | + return "pdo"; |
|
43 | + } |
|
44 | + protected function setConnectionParameters( $_srv, $_db, $_usr, $_pass) { |
|
45 | + $this->info = []; |
|
46 | + $this->info["server"] = $_srv; |
|
47 | + $this->info["database"] = $_db; |
|
48 | + $this->info["user"] = $_usr; |
|
49 | + $this->info["password"] = $_pass; |
|
50 | + } |
|
51 | 51 | } |
52 | 52 | ?> |
@@ -1,46 +1,46 @@ |
||
1 | 1 | <?php |
2 | 2 | jRequire("ConnectionInterface.php"); |
3 | 3 | class ConnectionPostgresqlAdapter implements ConnectionAdapterInterface { |
4 | - public $connection; |
|
5 | - public function __construct( $_srv, $_db, $_usr, $_pass ) { |
|
6 | - $this->connection = pg_connect("host=$_srv dbname=$_db user=$_usr password=$_pass") |
|
7 | - or die('Could not connect: '.pg_last_error()); |
|
8 | - } |
|
9 | - public function query( $_query ) { |
|
10 | - $this->stdQuery($_query); |
|
11 | - return true; |
|
12 | - } |
|
13 | - public function queryInsert( $_query ) { |
|
14 | - $this->stdQuery($_query); |
|
15 | - return $this->stdQuery("SELECT lastval()"); |
|
16 | - } |
|
17 | - public function queryFetch( $_query ) { |
|
18 | - $result = $this->stdQuery($_query); |
|
19 | - $rows = []; |
|
20 | - while($row = pg_fetch_assoc($result)) |
|
21 | - $rows[] = $row; |
|
22 | - pg_free_result($result); |
|
23 | - return $rows; |
|
24 | - } |
|
25 | - public function queryArray( $_query ) { |
|
26 | - $result = $this->stdQuery($_query); |
|
27 | - $rows = []; |
|
28 | - while($row = pg_fetch_array($result)) |
|
29 | - $rows[] = $row; |
|
30 | - pg_free_result($result); |
|
31 | - return $rows; |
|
32 | - } |
|
33 | - protected function stdQuery( $_query ) { |
|
34 | - $database = $this->connection; |
|
35 | - $error = "Error query [$_query]"; |
|
36 | - $result = pg_query($database, $_query); |
|
37 | - if(!$result) { |
|
38 | - echo "$_query<br>"; |
|
39 | - echo "Something wrong: $error"; |
|
40 | - var_dump(pg_last_error()); |
|
41 | - exit(); |
|
42 | - } |
|
43 | - return $result; |
|
44 | - } |
|
4 | + public $connection; |
|
5 | + public function __construct( $_srv, $_db, $_usr, $_pass ) { |
|
6 | + $this->connection = pg_connect("host=$_srv dbname=$_db user=$_usr password=$_pass") |
|
7 | + or die('Could not connect: '.pg_last_error()); |
|
8 | + } |
|
9 | + public function query( $_query ) { |
|
10 | + $this->stdQuery($_query); |
|
11 | + return true; |
|
12 | + } |
|
13 | + public function queryInsert( $_query ) { |
|
14 | + $this->stdQuery($_query); |
|
15 | + return $this->stdQuery("SELECT lastval()"); |
|
16 | + } |
|
17 | + public function queryFetch( $_query ) { |
|
18 | + $result = $this->stdQuery($_query); |
|
19 | + $rows = []; |
|
20 | + while($row = pg_fetch_assoc($result)) |
|
21 | + $rows[] = $row; |
|
22 | + pg_free_result($result); |
|
23 | + return $rows; |
|
24 | + } |
|
25 | + public function queryArray( $_query ) { |
|
26 | + $result = $this->stdQuery($_query); |
|
27 | + $rows = []; |
|
28 | + while($row = pg_fetch_array($result)) |
|
29 | + $rows[] = $row; |
|
30 | + pg_free_result($result); |
|
31 | + return $rows; |
|
32 | + } |
|
33 | + protected function stdQuery( $_query ) { |
|
34 | + $database = $this->connection; |
|
35 | + $error = "Error query [$_query]"; |
|
36 | + $result = pg_query($database, $_query); |
|
37 | + if(!$result) { |
|
38 | + echo "$_query<br>"; |
|
39 | + echo "Something wrong: $error"; |
|
40 | + var_dump(pg_last_error()); |
|
41 | + exit(); |
|
42 | + } |
|
43 | + return $result; |
|
44 | + } |
|
45 | 45 | } |
46 | 46 | ?> |
@@ -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()); |
@@ -17,16 +17,18 @@ |
||
17 | 17 | public function queryFetch( $_query ) { |
18 | 18 | $result = $this->stdQuery($_query); |
19 | 19 | $rows = []; |
20 | - while($row = pg_fetch_assoc($result)) |
|
21 | - $rows[] = $row; |
|
20 | + while($row = pg_fetch_assoc($result)) { |
|
21 | + $rows[] = $row; |
|
22 | + } |
|
22 | 23 | pg_free_result($result); |
23 | 24 | return $rows; |
24 | 25 | } |
25 | 26 | public function queryArray( $_query ) { |
26 | 27 | $result = $this->stdQuery($_query); |
27 | 28 | $rows = []; |
28 | - while($row = pg_fetch_array($result)) |
|
29 | - $rows[] = $row; |
|
29 | + while($row = pg_fetch_array($result)) { |
|
30 | + $rows[] = $row; |
|
31 | + } |
|
30 | 32 | pg_free_result($result); |
31 | 33 | return $rows; |
32 | 34 | } |