Can Ajax check if a Query succeeded?

Dev Shed Forums Sponsor:

February 5th, 2013, 07:18 AM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Can Ajax check if a Query succeeded?

I'm using Ajax to update a text in my database but I'm wondering if php can send a response back with Ajax if the Query is succesfull

Code:

        $.ajax({
          type: 'POST',
          url: 'test.php',
          data: 'text=' + text,

and on my test.php page

Code:

if($_POST){
	try {
		$insert_query = $db->prepare('UPDATE fields SET content = :content WHERE name = "homepage_mission" ');
		$insert_query->execute(array('content' => $_POST['text']));
	}
	catch(PDOException $e){
		print $e->getMessage();
		die();
	}
}

Help would be loved! thanks

February 5th, 2013, 07:26 AM

gw1500se

Contributing User

Join Date: Jul 2003

Posts: 2,879

Time spent in forums: 1 Year 2 Weeks 1 Day 56 m 52 sec
Reputation Power: 581

It is not clear what you want to accomplish. If the query is initiated by a form submit then PHP can report success/failure directly. If the query is initiated by an Ajax call then the answer is yes.

__________________
There are 10 kinds of people in the world. Those that understand binary and those that don't.

February 5th, 2013, 07:28 AM

Bronzesoda

Registered User

Join Date: Feb 2013

Posts: 1

Time spent in forums: 9 m 28 sec
Reputation Power: 0

Code:

$.ajax({
  type: 'POST',
  url: "test.php",
  data: { example: "text" },
  success: function(msg) {
    alert('success');
  }
});

February 5th, 2013, 07:32 AM

Northie

Square Peg in a Round Hole

Join Date: Oct 2007

Location: North Yorkshire, UK

Posts: 3,420

Time spent in forums: 3 Weeks 5 Days 10 h 27 m 11 sec
Reputation Power: 3896

yes

whatever your php page outputs is sent back to the client (think normal page, but asked for by javascript).

Now, it looks like you are using jQuery, which has a myriad of options for the ajax method.

many of the call back functions take this responded info as an argument.

A favourite for beginners is "complete", eg

Code:

$.ajax({
          type: 'POST',
          url: 'test.php',
          data: 'text=' + text,
          complete:function(a,b) {
          	if(b == 'success') {
          		var d = a.responseText; //this is the data the server 'sent' back
          		
          		//process d
          		
          		//eg $("body").append(d);
          		
          		//or
          		
          		//var json = eval("("+a+")") //if someone knows a cleaner way, please let me know! (dataType:JSON has never worked for me)
          		
          	} else {
          		//something went wrong
          	}
          }
});

__________________
PHP OOPS! <?php DB::Execute(SQL::makeFrom($_GET))->fetchArray()->FormatWith(Template::getInstance('default'))->printHtml(); ?>

PDO vs mysql_* functions: Find a Migration Guide Here

[ Xeneco - T'interweb Development ] - [ Are you a Help Vampire? ] - [ Read The manual! ] - [ W3 methods - GET, POST, etc ] - [ Web Design Hell ]

February 5th, 2013, 07:44 AM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Quote:

Originally Posted by Bronzesoda

Code:

$.ajax({
  type: 'POST',
  url: "test.php",
  data: { example: "text" },
  success: function(msg) {
    alert('success');
  }
});

What is this 'msg' variable? I don't quite understand how or what PHP is sending back? Could you give me an example please?

Thanks!

February 5th, 2013, 07:46 AM

notflip

Contributing User

Join Date: Sep 2012

Posts: 148

Time spent in forums: 18 h 39 m 9 sec
Reputation Power: 1

Quote:

Originally Posted by Northie

many of the call back functions take this responded info as an argument.

});[/CODE]

Aha! i found it thanks to this. So it doesn't matter what the name of the argument is, it's always from the server. how nice! thanks !

Can Ajax check if a Query succeeded?

Developer Shed Advertisers and Affiliates