@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | $exec = sqlsrv_execute($stmt); |
117 | 117 | } |
118 | 118 | else |
119 | - $exec = $this->result = sqlsrv_query($this->dbconn, $sql, $params, array( "Scrollable" => SQLSRV_CURSOR_KEYSET )); |
|
119 | + $exec = $this->result = sqlsrv_query($this->dbconn, $sql, $params, array("Scrollable" => SQLSRV_CURSOR_KEYSET)); |
|
120 | 120 | |
121 | 121 | if ($exec === false) |
122 | 122 | { |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | $this->rowsAffected = sqlsrv_rows_affected($this->result); |
138 | 138 | |
139 | 139 | if ($this->transac_mode) |
140 | - $this->transac_result = is_null($this->transac_result) ? $this->result: $this->transac_result && $this->result; |
|
140 | + $this->transac_result = is_null($this->transac_result) ? $this->result : $this->transac_result && $this->result; |
|
141 | 141 | |
142 | 142 | return $this->result; |
143 | 143 | } |
@@ -31,15 +31,17 @@ discard block |
||
31 | 31 | */ |
32 | 32 | public function __construct($options) |
33 | 33 | { |
34 | - if (!array_key_exists("dbchar", $options)) |
|
35 | - $options["dbchar"] = "UTF-8"; |
|
34 | + if (!array_key_exists("dbchar", $options)) { |
|
35 | + $options["dbchar"] = "UTF-8"; |
|
36 | + } |
|
36 | 37 | |
37 | 38 | parent::__construct($options); |
38 | 39 | |
39 | 40 | $auto_connect = array_key_exists('auto_connect', $options) ? $options["auto_connect"] : true; |
40 | 41 | |
41 | - if ($auto_connect) |
|
42 | - $this->connect(); |
|
42 | + if ($auto_connect) { |
|
43 | + $this->connect(); |
|
44 | + } |
|
43 | 45 | } |
44 | 46 | |
45 | 47 | /** |
@@ -52,11 +54,13 @@ discard block |
||
52 | 54 | */ |
53 | 55 | public function connect() |
54 | 56 | { |
55 | - if (!extension_loaded('sqlsrv')) |
|
56 | - throw new \RuntimeException("The Sqlsrv extension is not loaded"); |
|
57 | + if (!extension_loaded('sqlsrv')) { |
|
58 | + throw new \RuntimeException("The Sqlsrv extension is not loaded"); |
|
59 | + } |
|
57 | 60 | |
58 | - if (!is_null($this->dbport) && !empty($this->dbport)) |
|
59 | - $this->dbhost .= ', ' . $this->dbport; |
|
61 | + if (!is_null($this->dbport) && !empty($this->dbport)) { |
|
62 | + $this->dbhost .= ', ' . $this->dbport; |
|
63 | + } |
|
60 | 64 | |
61 | 65 | $db_info = array("Database" => $this->dbname, "UID" => $this->dbuser, "PWD" => $this->dbpass, "CharacterSet" => $this->dbchar); |
62 | 66 | $this->dbconn = sqlsrv_connect($this->dbhost, $db_info); |
@@ -114,9 +118,9 @@ discard block |
||
114 | 118 | } |
115 | 119 | |
116 | 120 | $exec = sqlsrv_execute($stmt); |
121 | + } else { |
|
122 | + $exec = $this->result = sqlsrv_query($this->dbconn, $sql, $params, array( "Scrollable" => SQLSRV_CURSOR_KEYSET )); |
|
117 | 123 | } |
118 | - else |
|
119 | - $exec = $this->result = sqlsrv_query($this->dbconn, $sql, $params, array( "Scrollable" => SQLSRV_CURSOR_KEYSET )); |
|
120 | 124 | |
121 | 125 | if ($exec === false) |
122 | 126 | { |
@@ -136,8 +140,9 @@ discard block |
||
136 | 140 | $this->numFields = sqlsrv_num_fields($this->result); |
137 | 141 | $this->rowsAffected = sqlsrv_rows_affected($this->result); |
138 | 142 | |
139 | - if ($this->transac_mode) |
|
140 | - $this->transac_result = is_null($this->transac_result) ? $this->result: $this->transac_result && $this->result; |
|
143 | + if ($this->transac_mode) { |
|
144 | + $this->transac_result = is_null($this->transac_result) ? $this->result: $this->transac_result && $this->result; |
|
145 | + } |
|
141 | 146 | |
142 | 147 | return $this->result; |
143 | 148 | } |
@@ -204,9 +209,8 @@ discard block |
||
204 | 209 | { |
205 | 210 | $data[] = $row; |
206 | 211 | } |
207 | - } |
|
208 | - else |
|
209 | - /* |
|
212 | + } else { |
|
213 | + /* |
|
210 | 214 | * "This kind of exception should lead directly to a fix in your code" |
211 | 215 | * So much production tests tell us this error is throwed because developers |
212 | 216 | * execute toArray() before execute(). |
@@ -214,6 +218,7 @@ discard block |
||
214 | 218 | * Ref: http://php.net/manual/en/class.logicexception.php |
215 | 219 | */ |
216 | 220 | throw new \LogicException('There are not data in the buffer!'); |
221 | + } |
|
217 | 222 | |
218 | 223 | $this->arrayResult = $data; |
219 | 224 | |
@@ -227,7 +232,8 @@ discard block |
||
227 | 232 | */ |
228 | 233 | public function __destruct() |
229 | 234 | { |
230 | - if ($this->dbconn) |
|
231 | - sqlsrv_close($this->dbconn); |
|
235 | + if ($this->dbconn) { |
|
236 | + sqlsrv_close($this->dbconn); |
|
237 | + } |
|
232 | 238 | } |
233 | 239 | } |
234 | 240 | \ No newline at end of file |
@@ -26,18 +26,18 @@ discard block |
||
26 | 26 | * |
27 | 27 | * @return string |
28 | 28 | */ |
29 | - public function read($socket) |
|
30 | - { |
|
31 | - if (($message = @socket_read($socket, 1024)) === false) |
|
32 | - { |
|
33 | - $errno = socket_last_error(); |
|
34 | - $this->error($errno, socket_strerror($errno)); |
|
29 | + public function read($socket) |
|
30 | + { |
|
31 | + if (($message = @socket_read($socket, 1024)) === false) |
|
32 | + { |
|
33 | + $errno = socket_last_error(); |
|
34 | + $this->error($errno, socket_strerror($errno)); |
|
35 | 35 | |
36 | - throw new \RuntimeException("Could not read message from client socket"); |
|
37 | - } |
|
36 | + throw new \RuntimeException("Could not read message from client socket"); |
|
37 | + } |
|
38 | 38 | |
39 | - return $message; |
|
40 | - } |
|
39 | + return $message; |
|
40 | + } |
|
41 | 41 | |
42 | 42 | /** |
43 | 43 | * Sends a message to client socket |
@@ -49,18 +49,18 @@ discard block |
||
49 | 49 | * |
50 | 50 | * @return integer |
51 | 51 | */ |
52 | - public function send($socket, $message) |
|
53 | - { |
|
54 | - if (($bytes = @socket_write($socket, $message, strlen($message))) === false) |
|
55 | - { |
|
56 | - $errno = socket_last_error(); |
|
57 | - $this->error($errno, socket_strerror($errno)); |
|
52 | + public function send($socket, $message) |
|
53 | + { |
|
54 | + if (($bytes = @socket_write($socket, $message, strlen($message))) === false) |
|
55 | + { |
|
56 | + $errno = socket_last_error(); |
|
57 | + $this->error($errno, socket_strerror($errno)); |
|
58 | 58 | |
59 | - throw new \RuntimeException("Could not send message to the client socket"); |
|
60 | - } |
|
59 | + throw new \RuntimeException("Could not send message to the client socket"); |
|
60 | + } |
|
61 | 61 | |
62 | - return $bytes; |
|
63 | - } |
|
62 | + return $bytes; |
|
63 | + } |
|
64 | 64 | |
65 | 65 | /** |
66 | 66 | * Sets socket to listening |
@@ -71,54 +71,54 @@ discard block |
||
71 | 71 | * |
72 | 72 | * @return boolean |
73 | 73 | */ |
74 | - public function listen(Array $eventHandlers = array()) |
|
75 | - { |
|
76 | - $event = $eventHandlers; |
|
77 | - $clousure = function(){}; |
|
74 | + public function listen(Array $eventHandlers = array()) |
|
75 | + { |
|
76 | + $event = $eventHandlers; |
|
77 | + $clousure = function(){}; |
|
78 | 78 | |
79 | - if (!array_key_exists('success', $event)) |
|
80 | - $event["success"] = $clousure; |
|
79 | + if (!array_key_exists('success', $event)) |
|
80 | + $event["success"] = $clousure; |
|
81 | 81 | |
82 | - if (!array_key_exists('error', $event)) |
|
83 | - $event["error"] = $clousure; |
|
82 | + if (!array_key_exists('error', $event)) |
|
83 | + $event["error"] = $clousure; |
|
84 | 84 | |
85 | - $listener = false; |
|
85 | + $listener = false; |
|
86 | 86 | |
87 | - if (!($listener = @socket_listen($this->socket, 30))) |
|
88 | - { |
|
89 | - $errno = socket_last_error(); |
|
90 | - $this->error($errno, socket_strerror($errno)); |
|
87 | + if (!($listener = @socket_listen($this->socket, 30))) |
|
88 | + { |
|
89 | + $errno = socket_last_error(); |
|
90 | + $this->error($errno, socket_strerror($errno)); |
|
91 | 91 | |
92 | - throw new \RuntimeException("Could not set socket to listen"); |
|
93 | - } |
|
94 | - else { |
|
92 | + throw new \RuntimeException("Could not set socket to listen"); |
|
93 | + } |
|
94 | + else { |
|
95 | 95 | |
96 | - echo "\n"; |
|
97 | - echo "Server Started : " . date('Y-m-d H:i:s') . "\n"; |
|
98 | - echo "Master socket : " . $this->socket . "\n"; |
|
99 | - echo "Listening on : " . $this->host . " port " . $this->port . "\n\n"; |
|
96 | + echo "\n"; |
|
97 | + echo "Server Started : " . date('Y-m-d H:i:s') . "\n"; |
|
98 | + echo "Master socket : " . $this->socket . "\n"; |
|
99 | + echo "Listening on : " . $this->host . " port " . $this->port . "\n\n"; |
|
100 | 100 | |
101 | - $socket = $this->socket; |
|
101 | + $socket = $this->socket; |
|
102 | 102 | |
103 | - if (!($spawn = @socket_accept($this->socket))) |
|
104 | - { |
|
105 | - $errno = socket_last_error(); |
|
106 | - $this->error($errno, socket_strerror($errno)); |
|
103 | + if (!($spawn = @socket_accept($this->socket))) |
|
104 | + { |
|
105 | + $errno = socket_last_error(); |
|
106 | + $this->error($errno, socket_strerror($errno)); |
|
107 | 107 | |
108 | - throw new \RuntimeException("Could not accept incoming connection"); |
|
109 | - } |
|
108 | + throw new \RuntimeException("Could not accept incoming connection"); |
|
109 | + } |
|
110 | 110 | |
111 | - $input = $this->read($spawn); |
|
111 | + $input = $this->read($spawn); |
|
112 | 112 | |
113 | - $input = trim($input); |
|
114 | - call_user_func($event["success"], $input, $this, $spawn); |
|
113 | + $input = trim($input); |
|
114 | + call_user_func($event["success"], $input, $this, $spawn); |
|
115 | 115 | |
116 | - socket_close($spawn); |
|
117 | - } |
|
116 | + socket_close($spawn); |
|
117 | + } |
|
118 | 118 | |
119 | - if (!$listener) |
|
120 | - call_user_func($event["error"], $this->getLastError()); |
|
119 | + if (!$listener) |
|
120 | + call_user_func($event["error"], $this->getLastError()); |
|
121 | 121 | |
122 | - return $listener; |
|
123 | - } |
|
122 | + return $listener; |
|
123 | + } |
|
124 | 124 | } |
125 | 125 | \ No newline at end of file |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | |
120 | 120 | throw new \RuntimeException("Could not create the socket"); |
121 | 121 | } |
122 | - } |
|
122 | + } |
|
123 | 123 | |
124 | 124 | /** |
125 | 125 | * Binds the socket |
@@ -143,8 +143,8 @@ discard block |
||
143 | 143 | * |
144 | 144 | * @return null |
145 | 145 | */ |
146 | - public function close() |
|
147 | - { |
|
146 | + public function close() |
|
147 | + { |
|
148 | 148 | return socket_close($this->socket); |
149 | - } |
|
149 | + } |
|
150 | 150 | } |
151 | 151 | \ No newline at end of file |