From 76b11d5d31d92191ea2d42cee1560b153737933c Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Fri, 25 Mar 2016 01:44:55 +0100 Subject: [PATCH] update --- lib/php/db/table.php | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/lib/php/db/table.php b/lib/php/db/table.php index e86b71cb..020d3a1b 100644 --- a/lib/php/db/table.php +++ b/lib/php/db/table.php @@ -1057,6 +1057,11 @@ FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT c.oid FROM pg_catalog. .' WHERE ' . join(' AND ',$this->ar_map('"$a=:key_$a"',$keys)) ; + $sql = '' + .'SELECT * FROM ' . $this->sql_name() + .' WHERE ' . join(' AND ',$this->ar_map('"$a=:key_$a"',$keys)) + ; + #bye($sql); $this->debug($sql,1); @@ -1067,12 +1072,13 @@ 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"); + #$field->bindParam($query,$hvalues[$name],":$name"); } foreach ($keys as $name) { #debug("$name: ".$hvalues[$name]); - $field->bindParam($query,$hvalues[$name],":key_$name"); + #$field->bindParam($query,$hvalues[$name],":key_$name"); + $query->bindValue(":key_$name", $hvalues[$name], PDO::PARAM_STR); } #return $sql; @@ -1082,7 +1088,8 @@ FROM pg_catalog.pg_attribute a WHERE a.attrelid = (SELECT c.oid FROM pg_catalog. return false; } - #debug($query); + #debug($execute); + debug($query->fetch()); return $execute; } -- 2.47.3