Changeset 2226

Timestamp:

03/06/2008 12:02:41 PM (10 months ago)

Author:

zombor

Message:

Fixing #463. Thanks ixmatus!

Files:

• trunk/system/libraries/drivers/Database/Mssql.php (modified) (1 diff)

trunk/system/libraries/drivers/Database/Mssql.php

@@ -236 +236 @@
                 is_resource($this->link) or $this->connect();
                 //mssql_real_escape_string($str, $this->link); <-- this function doesn't exist
-                
-                /* Below is my test of the addcslashes function to mimic the mysql_real_escape_string function
-                 * 
-                 * $array       = array('\x00', '\x1a', '\n', '\r', '\\', "'", '"');
-                 * foreach($array as $item)
-                 * {
-                 *        echo addcslashes($item, '\\\'"').'<br />';
-                 * }
-                 */
-                $characters     = array('/\x00/', '/\x1a/', '/\n/', '/\r/', '/\\\/', '/\'/', '/\"/');
-                return preg_replace($characters, '\\', $str);
+
+                $characters = array('/\x00/', '/\x1a/', '/\n/', '/\r/', '/\\\/', '/\'/');
+                $replace    = array('\\\x00', '\\x1a', '\\n', '\\r', '\\\\', "''");
+                return preg_replace($characters, $replace, $str);
         }