From 033a383dc7ee39663dd8cdc51f397967487c6353 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Thu, 19 Oct 2017 17:26:47 +0100
Subject: [PATCH] lib/php/db/table.php

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

diff --git a/lib/php/db/table.php b/lib/php/db/table.php
index d61b8c07..0fed3565 100644
--- a/lib/php/db/table.php
+++ b/lib/php/db/table.php
@@ -453,7 +453,7 @@ Class Table extends nb {
 
     foreach ($keys as $name => $field) {
       if (isset($values[$name]))
-        $url[] = $name . '=' .urlencode($values[$name])
+        $url[] = self::$field_preff.$name . '=' .urlencode($values[$name])
       ;
     }
 
@@ -1537,19 +1537,21 @@ Class Table extends nb {
   }
 
   public function insert($post,&$info=[],$insert_word='INSERT') {
+
     if (empty($info['values'])) $info['values'] = [];
     if (empty($post)) $this->bye('insert(): No values');
+
     $info['values'] = $post;
 
     $sql_names = $fields = $values = [];
 
     foreach ($this->fields() as $name => $field) {
-      if (!isset($post[$name])) continue;
+      if (!isset($post[self::$field_preff.$name])) continue;
       if ($field->key and $field->autoincrement()) continue;
 
       $fields[$name] = $field;
       $sql_names[$name] = $field->sql_name();
-      $values[] = $post[$name];
+      $values[] = $post[self::$field_preff.$name];
     }
 
     if (empty($fields)) $this->bye('insert(): No fields for table');
@@ -1602,7 +1604,7 @@ Class Table extends nb {
 
     foreach ($this->fields() as $name => $field) {
 
-      if (!isset($post[$name])) {
+      if (!isset($post[self::$field_preff.$name])) {
         if ($field->key) $this->bye("Missing `$name`!");
         continue;
       }
-- 
2.47.3