Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 12th, 2012  |  syntax: None  |  size: 1.18 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. passing dynamic multidimensional array from jQuery to php and insert into database
  2. <?php
  3. $name = $_POST['name'];
  4. $problem = $_POST['problem'];
  5. $timedate = $_POST['timedate'];
  6. $con = mysql_connect("localhost","wayko","b4v0e1jj");
  7. if (!$con)
  8. {
  9. die('Could not connect: ' . mysql_error());
  10. }
  11. mysql_select_db("joinus", $con);
  12. $seriname =  mysql_real_escape_string(serialize($name));
  13. $seriprob =  mysql_real_escape_string(serialize($problem));
  14. $seritd =  mysql_real_escape_string(serialize($timedate));
  15. foreach($name as  $valname){
  16. foreach($problem as  $valprob){
  17. foreach($timedate as $valtd){
  18. }
  19. }
  20. }
  21. $sql="INSERT INTO roomchart (Name,TimeDate,Problem)
  22. VALUES
  23. ('$valname','$valtd','$valprob')";
  24. echo $sql;
  25.  
  26. if (!mysql_query($sql,$con))
  27. {
  28. die('Error: ' . mysql_error(). "Actual query: " . $sql);
  29. }
  30.  
  31. mysql_close($con);
  32. ?>
  33.        
  34. foreach($name as  $valname){
  35. foreach($problem as  $valprob){
  36. foreach($timedate as $valtd){
  37. $sql="INSERT INTO roomchart (Name,TimeDate,Problem)
  38. VALUES
  39. ('$valname','$valtd','$valprob')";
  40. echo $sql;
  41. }
  42. }
  43. }
  44.        
  45. foreach ($name as $key => $valname) {
  46.     $sql = "INSERT INTO roomchart (Name, TimeDate, Problem)
  47.     VALUES ('$valname', '$timedate[$key]', '$problem[$key]')";
  48.     echo $sql;
  49. }