From d769c670105b87d3b320615520b2d18c09112025 Mon Sep 17 00:00:00 2001
From: Devops <sys@15gifts.com>
Date: Fri, 12 May 2017 17:08:24 +0100
Subject: [PATCH] lib/php/db/table.php

---
 lib/php/db/table.php | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/lib/php/db/table.php b/lib/php/db/table.php
index fb0456b0..76a2324c 100644
--- a/lib/php/db/table.php
+++ b/lib/php/db/table.php
@@ -1607,6 +1607,7 @@ Class Table extends nb {
       $this->err_sql($sql);
       return false;
     }
+
     foreach ($fields as $name => $field) {
       $row = [ $name => $post[$name] ];
       $this->db()->table_row_encrypt($this,$row);
@@ -1707,15 +1708,17 @@ Class Table extends nb {
       #debug("$name: ".$post[$name]);
       $row = [ $name => $post[$name] ];
       $this->db()->table_row_encrypt($this,$row);
-      #debug($this->db()->status());
       $field->bindParam($query,$row[$name],":$name");
+      #$sql = str_replace(":$name",$row[$name],$sql);
     }
 
     foreach ($keys as $name) {
       #debug("$name: ".$post[$name]);
       $field->bindParam($query,$post[$name],":key_$name");
+      #$sql = str_replace(":key_$name",$row[$name],$sql);
     }
 
+    $info['sql'] = $sql;
     #return $sql;
     if (self::p('debug')) {
       $this->debug($info,1);
@@ -1723,16 +1726,13 @@ Class Table extends nb {
     }
 
     if (!($ex = $query->execute())) {
-      err('PDO::errorInfo(): ' .join(' ', $this->db()->conn->errorInfo()) .NB_EOL);
+      $this->err_sql($sql);
       return false;
     }
 
     #$info['rowCount'] = $query->rowCount();
     $info = [ 'rowCount' => $query->rowCount()] + $info;
-    #bye($this->db()->row("SELECT value FROM crypt WHERE id='zaza'"));
-    #bye($info);
-    #return true;
-    #debug($execute);
+    debug($info); return 0;
     return $info['rowCount'];
 
   }
-- 
2.47.3