Fix escaping not copying non-escapeable chars to the escaped string

1 files changed, 10 insertions, 6 deletions

diff --git a/lib/mysql.php b/lib/mysql.php
index c2f3aad..9fa32cb 100644
--- a/lib/mysql.php
+++ b/lib/mysql.php
@@ -688,24 +688,28 @@ namespace Dshafik {
             for ($i = 0; $i < strlen($unescapedString); $i++) {
                 switch ($unescapedString{$i}) {
                     case "\0":
-                        $esc = 0;
+                        $esc = "\\0";
                         break;
                     case "\n":
-                        $esc = "n";
+                        $esc = "\\n";
                         break;
                     case "\r":
-                        $esc = "r";
+                        $esc = "\\r";
                         break;
                     case '\\':
                     case '\'':
                     case '"':
-                        $esc = $unescapedString{$i};
+                        $esc = "\\{$unescapedString{$i}}";
                         break;
                     case "\032":
-                        $esc = 'Z';
+                        $esc = "\\Z";
+                        break;
+                    default:
+                        $esc = $unescapedString{$i};
                         break;
                 }
-                $escapedString .= "\\$esc";
+
+                $escapedString .= $esc;
 
             }