Changeset 684 for trunk/bin

Timestamp:

May 19, 2019 10:51:43 PM (5 years ago)

Author:

anonymous

Message:

 

File:

• trunk/bin/module_maker/sql.cli.php (modified) (6 diffs)

trunk/bin/module_maker/sql.cli.php

@@ -133 +133 @@
     $insert_c[$k] = $v;
 }
-$db_keys = join(",\n            ", array_keys($insert_c));
+$db_keys = join("`,\n            `", array_keys($insert_c));
 $db_vals = join(",\n            ", $insert_c);
 echo <<<E_O_F
@@ -139 +139 @@
     \$db->query("
         INSERT INTO $db_tbl (
-            $db_keys
+            `$db_keys`
         ) VALUES (
             $db_vals
@@ -158 +158 @@
         continue;
     }
-    $key_eq_val .= $comma . "\n            $k = $v";
+    $key_eq_val .= $comma . "\n            `$k` = $v";
     $comma = ',';
 }
@@ -165 +165 @@
     \$db->query("
         UPDATE $db_tbl SET$key_eq_val
-        WHERE $primary_key = '" . \$db->escapeString(\$frm['$primary_key']) . "'
+        WHERE `$primary_key` = '" . \$db->escapeString(\$frm['$primary_key']) . "'
     ");
 E_O_F;
@@ -178 +178 @@
 $delim = 'WHERE';
 if (!empty($primary_key)) {
-    $where_clause = "            $delim $primary_key = '\" . \$db->escapeString(\$frm['$primary_key']) . \"'\n";
+    $where_clause = "            $delim `$primary_key` = '\" . \$db->escapeString(\$frm['$primary_key']) . \"'\n";
     $delim = 'AND';
 }
@@ -185 +185 @@
         continue;
     }
-    $where_clause .= "            $delim $k = '\" . \$db->escapeString(\$frm['$k']) . \"'\n";
+    $where_clause .= "            $delim `$k` = '\" . \$db->escapeString(\$frm['$k']) . \"'\n";
     $delim = 'AND';
 }