Advertisement
Guest User

Untitled

a guest
Sep 20th, 2016
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. var jsonString = "";
  2. function jsonconversion(){
  3.  
  4. jsonString = JSON.stringify(myArr);
  5. return jsonString;
  6. console.log(jsonString);
  7.  
  8. $.ajax({
  9. type: "POST",
  10. url: "http://192.168.192.17:80/watercooler/index2.php",
  11. data: jsonString,
  12. complete: function() {
  13. console.log("Success");
  14. },
  15. error: function() {
  16. console.log("Function: forward_to_server() error")
  17. }
  18. });
  19. }
  20.  
  21. <?php
  22.  
  23. $servername = "localhost";
  24. $username = "root";
  25. $password = "xx";
  26. $dbname = "xx";
  27.  
  28. //$myArray = $_REQUEST['jsonString'];
  29. $myArray = array(100,1,19);
  30.  
  31. $con = mysqli_connect($servername,$username,$password ,$dbname) or die ("could not connect database");
  32. echo $myArray;
  33.  
  34. $keys = array_keys($myArray); // get the value of keys
  35. $rows = array(); // create a temporary storage for rows
  36. foreach($keys as $key) { // loop through
  37. $value = $myArray[$key]; // get corresponding value
  38. $rows[] = "('" . $key . "', '" . $value . "')";
  39. // add a row to the temporary storage
  40. }
  41. $values = implode(",", $rows); // 'glue' your rows into a query
  42. $sql = "INSERT INTO php_test (temp, sound, light) VALUES (10,20,30)"; //. $values
  43. $rs = mysqli_query($con,$sql) or die(mysqli_error($con));
  44.  
  45. if ($con->query($sql) === TRUE) {
  46. echo "New record created successfully";
  47. } else {
  48. echo "Error: " . $sql . "<br>" . $con->error;
  49. }
  50.  
  51. $con->close();
  52.  
  53. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement