RE: [PHP] INSERT Array Values into mySQL Table
| From: | Jim Moseby | Date: | Wed, 02 May 2007 16:03:19 +0000 |
| Subject: | RE: [PHP] INSERT Array Values into mySQL Table | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254242@lists.php.net to get a copy of this message | ||
>
> $sql = "INSERT INTO table (f1, f2, f3, ". implode(",",
> array_keys($pr1)) .")
> VALUES ('abc', '123', '456', ". implode(",",
> array_values($pr1))
> .")";
>
> HTH,
>
> Brad
Might not work if the array values need to be enclosed in quotes. I would
build the query string in a foreach loop and execute the query afterwards.
JM