Changeset 4892 for trunk/include

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

Files:

• dblayer/functions_mysql.inc.php (modified) (1 diff)
• dblayer/functions_pgsql.inc.php (modified) (1 diff)
• dblayer/functions_sqlite.inc.php (modified) (1 diff)
• functions_comment.inc.php (modified) (1 diff)
• ws_functions.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;

trunk/include/functions_comment.inc.php

@@ -169 +169 @@
     pwg_query($query);
 
-    $comm['id'] = pwg_db_insert_id();
+    $comm['id'] = pwg_db_insert_id(COMMENTS_TABLE);
 
     if (($comment_action=='validate' and $conf['email_admin_on_comment']) or

trunk/include/ws_functions.inc.php

@@ -1248 +1248 @@
     );
 
-  $image_id = pwg_db_insert_id();
+  $image_id = pwg_db_insert_id(IMAGES_TABLE);
 
   // let's add links between the image and the categories