From a0f562938d72561efeceeb8a5c088941c28b89ae Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Wed, 22 Aug 2018 11:33:17 +0100 Subject: [PATCH] lib/php/db/table.php --- lib/php/db/table.php | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/lib/php/db/table.php b/lib/php/db/table.php index 21765b6e..861e115c 100644 --- a/lib/php/db/table.php +++ b/lib/php/db/table.php @@ -1839,6 +1839,7 @@ Class Table extends nb { $fields_values = []; # NB 14.12.17 $bindParam = false; # NB 12.05.17: Not working ???? $bindParam = true; # NB 12.05.17: Not working ???? + $bindParam = false; # NB 12.05.17: Not working ???? foreach ($this->fields() as $name => $field) { @@ -1911,14 +1912,17 @@ Class Table extends nb { $row = [ $name => $post[$name] ]; $this->db()->table_row_encrypt($this,$row); if ($bindParam) $field->bindParam($query,$row[$name],":$name"); - $sql = str_replace(":$name",$this->field($name)->quote($row[$name]),$sql); +# NB 21.08.18 $sql = str_replace(":$name",$this->field($name)->quote($row[$name]),$sql); + $sql = str_replace("$name=:$name",$this->field($name)->sql_name().'='.$this->field($name)->quote($row[$name]),$sql); } foreach ($info['keys'] as $name => $value) { #debug("$name: ".$post[$name]); if ($bindParam) $field->bindParam($query,$value,":key_$name"); - $sql = str_replace(":key_$name",$this->field($name)->quote($value),$sql); +# NB 21.08.18 $sql = str_replace(":key_$name",$this->field($name)->quote($value),$sql); + $sql = str_replace("$name=:key_$name",$this->field($name)->sql_name().'='.$this->field($name)->quote($value),$sql); } + #bye(">>> ".$sql); $info['sql'] = $sql; if (!$bindParam) { @@ -2157,7 +2161,7 @@ Class Table extends nb { $buttons = ''; if (!empty($opt['buttons'])) $buttons = $opt['buttons']; - $r = '
'.NB_EOL; + $r = ''.NB_EOL; # See: http://html5doctor.com/html5-forms-input-types/ #$r .= ''; -- 2.47.3