From f402bc89eb34c90382601e11acf2960c0b94510a Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Thu, 24 Mar 2016 17:39:34 +0100
Subject: [PATCH] tables.update

---
 lib/php/db/field.php | 2 +-
 lib/php/db/table.php | 7 +++++--
 2 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/lib/php/db/field.php b/lib/php/db/field.php
index 7ba2abad..18cd60ce 100644
--- a/lib/php/db/field.php
+++ b/lib/php/db/field.php
@@ -131,7 +131,7 @@ class field {
     return PDO::PARAM_STR;
   }
 
-  function bindParam($sth,$value,$name=null) {
+  function bindParam(&$sth,$value,$name=null) {
     # See: http://php.net/manual/en/pdostatement.bindparam.php
     if ($name === null) $name = ':'.$this->name;
 #debug($this->name . " | $name | $value | $this->type | " .  $this->size()."<br/>");
diff --git a/lib/php/db/table.php b/lib/php/db/table.php
index 194932f4..e86b71cb 100644
--- a/lib/php/db/table.php
+++ b/lib/php/db/table.php
@@ -1053,8 +1053,8 @@ FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT c.oid FROM pg_catalog.
 
     $sql =  ''
       .'UPDATE ' . $this->sql_name()
-      .' SET '   . join(',',ar_map('"$a=:$a"',$fields))
-      .' WHERE ' . join(' AND ',ar_map('"$a=:key_$a"',$keys))
+      .' SET '   . join(',',$this->ar_map('"$a=:$a"',$fields))
+      .' WHERE ' . join(' AND ',$this->ar_map('"$a=:key_$a"',$keys))
     ;
 
     #bye($sql);
@@ -1066,10 +1066,12 @@ FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT c.oid FROM pg_catalog.
     }
      
     foreach ($fields as $name) {
+      #debug("$name: ".$hvalues[$name]);
       $field->bindParam($query,$hvalues[$name],":$name");
     }
 
     foreach ($keys as $name) {
+      #debug("$name: ".$hvalues[$name]);
       $field->bindParam($query,$hvalues[$name],":key_$name");
     }
 
@@ -1080,6 +1082,7 @@ FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT c.oid FROM pg_catalog.
       return false;
     }
 
+    #debug($query);
     return $execute;
 
   }
-- 
2.47.3