codepad
[
create a new paste
]
login
|
about
Language:
C
C++
D
Haskell
Lua
OCaml
PHP
Perl
Plain Text
Python
Ruby
Scheme
Tcl
<?php $array = array( array('name', 'age', 'gender' ), array('Ian', 24, 'male'), array('Janice', 21, 'female') ); $fields = implode(', ', array_shift($array)); $values = array(); foreach ($array as $rowValues) { foreach ($rowValues as $key => $rowValue) { $rowValues[$key] = $rowValues[$key]; } $values[] = "(" . implode(', ', $rowValues) . ")"; } $query = "INSERT INTO table_name ($fields) VALUES " . implode (', ', $values); echo $query;
Private
[
?
]
Run code
Submit