Changeset 606 for trunk/admin/include/functions.php
- Timestamp:
- Nov 17, 2004, 12:38:34 AM (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/include/functions.php
r597 r606 785 785 } 786 786 } 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 */ 796 function mass_inserts($table_name, $dbfields, $inserts) 797 { 798 // inserts all found categories 799 $query = ' 800 INSERT 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 } 787 834 ?>
Note: See TracChangeset
for help on using the changeset viewer.