MySQL update PHP and JS

Question

I have the following code in my change.php page:

$con = mysql_connect("localhost","root","root");
 if (!$con)
   {
    die('Could not connect: ' . mysql_error());
    }

  mysql_select_db("FACT", $con);


  if($_POST['isChecked']==1)  // SEE THIS LINE PLEASE
  {
  mysql_query("UPDATE Orc SET CON = 'CHECKED'
  WHERE UID = '1'");
   }
  else
   {
   mysql_query("UPDATE Orc SET CON = 'NO'
   WHERE UID = '1'");
   } 

  mysql_close($con);

This page is called from my index.php which uses jQuery and:

  $.post("test.php", { isChecked:$('#checkbox_id').attr('checked') } );

It works almost fine for deselecting the checkbox I still need to manually refresh the page for the change take place in the DB and I can't change the box back to selected...

I'm stumped on this one, please help.

Are you sure that this .post is called when user clicks the checkbox? — Peter Lindqvist
– Peter Lindqvist, Commented Nov 17, 2009 at 10:46
It must be since the DB is updating from 'Checked' to 'NO' if the JS wasnt working I never called the change.php page. Still I dont know how to debug js. — Jay
– Jay, Commented Nov 17, 2009 at 11:00

Adam Heath · Accepted Answer · 2009-11-27 18:53:14Z

1

In order to update the page without refreshing you will need to provide a callback function to the ajax call (code to run when the call has been successfully completed). From jQuery Docs:

 $.post("test.php", { name: "John", time: "2pm" },
  function(data){
    alert("Data Loaded: " + data);
  });

So you can use jQueries DOM manipulation to change parts of the page, get the php page to return new data to update the page with, or automatically refresh if you rely on data from the DB.

answered Nov 27, 2009 at 18:53

Adam Heath

4,7832 gold badges37 silver badges52 bronze badges

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

Comments

Giorgi · Accepted Answer · 2012-09-05 00:31:22Z

0

Adam Heath solution would work as well, but the way i would do it is the following:

  $.ajax({
    type : 'post',
    url : 'your url',
    data: {isChecked : $('#checkbox_id').attr('checked')},
    success: function(resultData) {
      //in your php script do all server side scripting and then
      //if your methods executed successfully return true otherwise return false
      if (resultData == true) {
         $('#checkbox_id').attr('checked', true);
      } else {
         $('#checkbox_id').attr('checked', false);
      }
    }
  });

answered Sep 5, 2012 at 0:31

Giorgi

6092 gold badges15 silver badges29 bronze badges

Collectives™ on Stack Overflow

MySQL update PHP and JS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related