RE: [PHP] db insert question
| From: | Jim Moseby | Date: | Thu, 21 Jul 2005 13:42:23 +0000 |
| Subject: | RE: [PHP] db insert question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-219118@lists.php.net to get a copy of this message | ||
>
> Im using mysql with PHP4, whats the best way to insert as many as 20
> records at one time from a form?
>
> Currently im just assigning each one a variable but that is messy and
> takes ages, is their a way to loop over the array of form data then
> maybe do the same to enter it into a database?
>
>
> Thanks for any help.
A generic question begs a generic answer:
foreach($formdata as $thisdata){
$result=mysql_query("insert into ... values($thisdata) where ...");
}
Hope this helps, but it would be useful to have code examples, etc so that a
more relevant answer could be rendered.
JM