From 634f880e13defe9a5c3d2d121975ebc5a888837d Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Sat, 2 Dec 2023 00:55:49 +0000 Subject: [PATCH] fix bug create_temporary_rows --- lib/php/db/table.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/lib/php/db/table.php b/lib/php/db/table.php index 1468c356..3d19050e 100644 --- a/lib/php/db/table.php +++ b/lib/php/db/table.php @@ -122,9 +122,13 @@ Class Table extends nb { $fields = array_keys($this->rows[0]); $sql_names = $this->sql_names($fields); + #bye($this->db()->type); + $map = $this->db()->type == 'mysql' ? '"$a=text"' : '"$a text"'; + $sep = $this->db()->type == 'mysql' ? '=' : ' '; $this->db()->conn->query("CREATE ".$this->sql_temporary()." TABLE $this->name (" # NB 15.12.22 .join(',',$this->ar_map('"$a text"',$sql_names)) - .join(',',array_map(function($a){return("$a=text");},$sql_names)) + # NB 02.12.23 .join(',',array_map(function($a){return("$a=text");},$sql_names)) + .join(',',array_map(function($a) use($sep) {return($a.$sep."text");},$sql_names)) .')'); $sql = 'INSERT INTO '. $this->sql_name("$this->name") . ' (' . join(',',array_values($sql_names)).')' -- 2.47.3