Changeset 4892 for trunk/include/dblayer

Timestamp:

Feb 15, 2010, 8:49:04 PM (14 years ago)

Author:

nikrou

Message:

Feature 1255 :
update pwg_db_insert_id() function.
PosgreSQL needs table name to retrieve last insert auto increment id.

Location:

trunk/include/dblayer

Files:

• functions_mysql.inc.php (modified) (1 diff)
• functions_pgsql.inc.php (modified) (1 diff)
• functions_sqlite.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_mysql.inc.php

@@ -158 +158 @@
 }
 
-function pwg_db_insert_id()
+function pwg_db_insert_id($table=null, $column='id')
 {
   return mysql_insert_id();

trunk/include/dblayer/functions_pgsql.inc.php

@@ -193 +193 @@
 }
 
-function pwg_db_insert_id()
-{
-  // select currval('piwigo_user_id_seq');
+function pwg_db_insert_id($table=null, $column='id')
+{
+  $sequence = sprintf('%s_%s_seq', strtolower($table), $column);
+  $query = '
+SELECT CURRVAL(\''.$sequence.'\');';
+
+  list($id) = pwg_db_fetch_row(pwg_query($query));
+
+  return $id;
 }
 

trunk/include/dblayer/functions_sqlite.inc.php

@@ -215 +215 @@
 }
 
-function pwg_db_insert_id()
+function pwg_db_insert_id($table=null, $column='id')
 {
   global $pwg_db_link;