Sync php and javascript to send data in SQL db

Question

I have a loop in javascript file to get variable, i send it in php to insert in SQL. The problem is that javascript doesn't wait that all informations are insert in SQL db. Is it possible to sync Javascript and php ?

Part of Js file :

while(i<myRoute.steps.length){

var path = myRoute.steps[i].path;

var trajet = path + ''; 

        var data = {
        var2: trajet    
  };  

  $.post("proc.php", data);

  i++;

}

proc.php :

<?php 

$var2 = $_POST['var2'];

$db = mysql_connect('127.0.0.1:3306', '***', '****')  or die('Erreur de connexion '.mysql_error());

mysql_select_db('tc',$db)  or die('Erreur de selection '.mysql_error()); 

$sql = "INSERT INTO ligne(Route) VALUES ('$var2')";

 mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); 

?>

JCOC611 · Accepted Answer · 2015-01-04 22:49:28Z

1

You can use the third argument of $.post, which is a callback function once a response from the server is received.

var i = 0;
var sendData = function(){
   var path = myRoute.steps[i].path;

   var trajet = path + ''; 
   var data = {
        var2: trajet    
   };  

   $.post("proc.php", data, function(){
      if(i < myRoute.steps.length){
         i++;
         sendData();
      }
   });
}
sendData();

answered Jan 4, 2015 at 22:49

JCOC611

19.8k15 gold badges71 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sync php and javascript to send data in SQL db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related