Reputation: 3081
New to using this Jquery AJAX method. So i'm making an AJAX call with Jquery, In my PHP script i'm checking a condition to be true from my Database, before I pass in my datastring and bind the variables, then execute that query. Both the script and Database insert work correctly.
My question is, how can I get it to display the error message in my AJAX call on return from my PHP script?
JS
$.ajax({
type: "POST",
url: 'submit_form.php',
data: dataString,
error: function() { alert('Error'); },
success: function() { alert('Success'); }
});
if ( count of rows in db < x )
{
return false;
exit();
}
if this condition is true I want to stop execution of my script and execute the error condition in my AJAX function.
elseif ($stmt = $mysqli->prepare("INSERT INTO blah (stuff, morestuff) values (?, ?)")) {
/* Bind our params */
$stmt->bind_param("ss", $param1, $param1);
/* Set our params */
$param1= $_POST["name"];
$param2= $_POST["email"];
/* Execute the prepared Statement */
$stmt->execute();
/* Close the statement */
$stmt->close();
}
if the first condition is false then I want to return the success function in my ajax call which it is currently doing.
Upvotes: 2
Views: 6666
Reputation: 173562
To invoke the error handler of your $.ajax
, you can write the following code in PHP (for FastCGI):
header('Status: 404 Not found');
exit;
Alternatively, use header('HTTP/1.0 404 Not Found')
if you're not using FastCGI.
Personally I wouldn't use this approach, because it blurs the line between web server errors and application errors.
You're better off with an error mechanism like:
echo json_encode(array('error' => array(
'message' => 'Error message',
'code' => 123,
)));
exit;
Inside your success handler:
if (data.error) {
alert(data.error.message);
}
Upvotes: 7
Reputation: 4617
i think you are little confused about jquery error setting, according to jquery
error : A function to be called if the request fails.
so your error code will be fired only because of the following reasons
404 Error – ajax file not found error
500 Error – ajax internal system error
Upvotes: 0
Reputation: 7954
YOur concept is wrong. error condtion means error in ajax call Change your code to this
$.ajax({
type: "POST",
url: 'submit_form.php',
data: dataString,
error: function() {
alert('Error'); //here the error is the error in ajax call.eg failing to call or a 404..etc
},
success: function(msg) {
if(msg=='error'){
alert('Error'); //this is the error you are looking for
}else{
alert('Success');
}
}
});
Your PHP
if ( count of rows in db < x )
{
echo 'error'; //this is enough
exit;
}
Upvotes: 2
Reputation: 5817
If you want to execute error command in jquery you can try using:
throw new Exception("Invalid");
inside your php code (where error should invoke).
This will cause http server to return error code 500 to your javascript code.
Upvotes: 2