Ignore:
Timestamp:
Nov 17, 2004, 12:38:34 AM (19 years ago)
Author:
plg
Message:
  • images.path column added to reduce database access
  • function mass_inserts moved from admin/remote_sites.php to admin/include/function.php
  • function mass_inserts used in admin/update.php
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/admin/include/functions.php

    r597 r606  
    785785  }
    786786}
     787
     788/**
     789 * inserts multiple lines in a table
     790 *
     791 * @param string table_name
     792 * @param array dbields
     793 * @param array inserts
     794 * @return void
     795 */
     796function mass_inserts($table_name, $dbfields, $inserts)
     797{
     798  // inserts all found categories
     799  $query = '
     800INSERT INTO '.$table_name.'
     801  ('.implode(',', $dbfields).')
     802   VALUES';
     803  foreach ($inserts as $insert_id => $insert)
     804  {
     805    $query.= '
     806  ';
     807    if ($insert_id > 0)
     808    {
     809      $query.= ',';
     810    }
     811    $query.= '(';
     812    foreach ($dbfields as $field_id => $dbfield)
     813    {
     814      if ($field_id > 0)
     815      {
     816        $query.= ',';
     817      }
     818     
     819      if (!isset($insert[$dbfield]) or $insert[$dbfield] == '')
     820      {
     821        $query.= 'NULL';
     822      }
     823      else
     824      {
     825        $query.= "'".$insert[$dbfield]."'";
     826      }
     827    }
     828    $query.=')';
     829  }
     830  $query.= '
     831;';
     832  pwg_query($query);
     833}
    787834?>
Note: See TracChangeset for help on using the changeset viewer.