@@ -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  |