Guest User

Untitled

a guest
Aug 20th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.39 KB | None | 0 0
  1. Having trouble with a foreach mysql INSERT
  2. <script>
  3. var count = 0;
  4. $(function(){
  5. $('p#add_field').click(function(){
  6. count += 1;
  7. $('#container').append(
  8. '<strong>Recipient #' + count + '</strong><br />'
  9. + '<tr><td><label>Client First Name:</label><input id="f_name_' + count + '" name="f_name[]' + '" type="text" /></td><td><label>Client Last Name:</label><input id="l_name_' + count + '" name="l_name[]' + '" type="text" /></td></tr>');
  10.  
  11. });
  12. });
  13. </script>
  14.  
  15. //Loop through added fields
  16. foreach ( $_POST['f_name'] as $key=>$f_name) {
  17. foreach ( $_POST['l_name'] as $key=>$l_name) {
  18.  
  19. //Insert static values into table
  20. $sql_user = sprintf("INSERT INTO mytable (f_name, l_name) VALUES ('%s','%s')",
  21. mysql_real_escape_string($f_name),
  22. mysql_real_escape_string($l_name));
  23. $result_user = $db->query($sql_user);
  24. }
  25. }
  26.  
  27.  
  28. <?php if (!isset($_POST['btnSubmit'])) { ?>
  29. <h1>My Form</h1>
  30. <form name="userdata" method="post" action="">
  31.  
  32. <h3>Please list the names:</h3>
  33. <table>
  34. <div id="container">
  35. <p id="add_field"><a href="#"><span>+ Add Names</span></a></p>
  36. </div>
  37. </table>
  38.  
  39. <input type="submit" name="btnSubmit" id="go" value="Submit Your Names" class="btn" />
  40.  
  41.  
  42. </form>
  43. <?php } ?>
  44.  
  45. foreach ( $_POST['f_name'] as $key => $f_name ) {
  46. $l_name = $_POST['l_name'][$key];
  47. // do something with $f_name and $l_name
  48. }
Add Comment
Please, Sign In to add comment