php - inserting value into database using post method not working -


i want update database table newlessontime posting value as3.but query not working ...but when give $etime = 4 in php code database updating lesson1 column but when comes post method, value not inserting lesson1 column why happening? stdroll column value inserted already want update lesson1 in same row of table here php file

// lesson1t.php  include('connect.php');   $etime = $_post['time1']; //$etime = 4;  if (mysqli_query($link, "update newlessontime set lesson1=$etime stdroll=123")) {      echo 'result=system updated';  } else {     echo 'result=error'; }  mysqli_close($link);  ?> 

here fla file

home_btn.buttonmode = true; home_btn.addeventlistener(mouseevent.click, indexbtn_click1);  function indexbtn_click1(event:mouseevent):void {  mytime.stop();  variables.time1 =  my_time.text ;  var request:urlrequest = new urlrequest('http://localhost/lesson1t.php');  request.method = urlrequestmethod.post;  request.data = variables;  var loader:urlloader = new urlloader(request);  loader.dataformat = urlloaderdataformat.variables;  loader.load(request);  loader.addeventlistener(event.complete, dataonloadl);  function dataonloadl(event:event)  {     var variables:urlvariables = urlvariables(event.target.data);     trace(variables.result);    // gives : system updated }  gotoandplay("manu");  soundmixer.stopall();  } 

maybe problem not defined variable.time1 var in as3.

try this...

home_btn.buttonmode = true; home_btn.addeventlistener(mouseevent.click, indexbtn_click1);  function indexbtn_click1(event:mouseevent):void {  mytime.stop();  var request:urlrequest = new urlrequest('http://localhost/lesson1t.php');  request.method = urlrequestmethod.post;  //you should define variables...  var variables:urlvariables = new urlvariables(); //this forgot!  variables.time1 =  my_time.text ;  request.data = variables;  var loader:urlloader = new urlloader(request);  loader.dataformat = urlloaderdataformat.variables;  loader.load(request);  loader.addeventlistener(event.complete, dataonloadl);  function dataonloadl(event:event)   {  var variables:urlvariables = urlvariables(event.target.data);  trace(variables.result);    // gives : system updated   }  gotoandplay("manu");  soundmixer.stopall();   } 

try , tell happen...


Comments

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -