krv Posted November 19, 2008 Share Posted November 19, 2008 Hello I am trying to insert multiple line items into a table and can only seem to get 1 item in a time my array is failing. Below is my example of what I want it to do. Any help is appreciated. Thanks! <?php // something i tired $query = "INSERT INTO table(part,qty,qty2)VALUES"; foreach ($_POST[part] as $key) { $query .= "('$key','$_POST[qty][$key]','$_POST[qty2][$key]')"; $result = mysql_query($query)or die(mysql_error()); if(isset($_POST['add'])){ // need to be able to insert all values shown above using a loop and array $sql = "INSERT INTO table (part,qty,qty2) VALUES ()"; $result = mysql_query($sql)or die(mysql_error()); } ?> <form method="POST"> <table> <tr> <td><input type="text" name="part[]"></td> <td><input type="text" name="qty[]"></td> <td><input type="text" name="qty2[]"></td> </tr> <tr> <td><input type="text" name="part[]"></td> <td><input type="text" name="qty[]"></td> <td><input type="text" name="qty2[]"></td> </tr> <tr> <td><input type="text" name="part[]"></td> <td><input type="text" name="qty[]"></td> <td><input type="text" name="qty2[]"></td> </tr> <tr> <td><input type="text" name="part[]"></td> <td><input type="text" name="qty[]"></td> <td><input type="text" name="qty2[]"></td> </tr> <tr> <td><input type="text" name="part[]"></td> <td><input type="text" name="qty[]"></td> <td><input type="text" name="qty2[]"></td> </tr> <tr> <td><input type="submit" name="submit" value="add"></td> </tr> </table> </form> Link to comment https://forums.phpfreaks.com/topic/133418-solved-help-mysql-insert-multiple-items-into-table-from-form/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.