Ajax Call error, Not working

Question

Following is code for calling ajax as well as php which is not working please help me. It gives 500 error i don't know why. I have also used $ instead of jQuery and jquery.min.js is also there.

jQuery.ajax({

        url: 'http://domain.com/adminer/validate.php',
        method    : 'post',
        data    : {email:emailField.value},
        dataType: 'text',
        success : function(data){
            if(data=="1")
            {
                alert('Already exists');
                return false;
            }
            else
            {
                alert('available');
                return false;
            }
        }
});

Here is the php code to get email details and reruns the message 1.The php code is working fine but here is something misstate which will be gives 500 error which is display into console.

if($_POST['email'])
{       
        $con = mysqli_connect("localhost","uname","pass","dbname");
        if (mysqli_connect_errno())
        {
            echo "Failed to connect to MySQL: " . mysqli_connect_error();
        }       
        $result = mysqli_query($con,"SELECT email FROM master_user where email='".$_POST['email']."'");
        $row_cnt = $result->num_rows;
        if($row_cnt > 0){               
            echo "1"; exit;
        }
        else
        {
            echo "2"; exit;
        }
        mysqli_close($con);
}

There may be some error in your server side code. Can you run the php code without the ajax ? — Jashwant, Nov 22 '14 at 08:39
**Danger**: You are **vulnerable to [SQL injection attacks](http://bobby-tables.com/)** that you need to [defend](http://stackoverflow.com/questions/60174/best-way-to-prevent-sql-injection-in-php) yourself from. — Quentin, Nov 22 '14 at 08:40
A 500 error in the browser means "Read your server logs to find out what the error is". — Quentin, Nov 22 '14 at 08:41
I will give me error just after the ajax call, it will display RED path in the console as path is correct. — webseo, Nov 22 '14 at 08:43
May be in your php `if` statement. `if(isset($_POST['email']) && $_POST['email'] != "")` — Chin, Nov 22 '14 at 08:49
No Chin it's not working so far. still it is give me RED into console, — webseo, Nov 22 '14 at 08:55
Here is the text display into RED console and it shows me jquery.min.js path at right side of console. "POST http://domain.com/adminer/validate.php" 15ms — webseo, Nov 22 '14 at 08:56

score 0 · Accepted Answer · answered Nov 22 '14 at 09:32

Change your code as per below.I have not tested but ,I think its working fine.

jQuery.ajax({

    url: 'http://domain.com/adminer/validate.php?email='+emailField.value,
    method    : 'post',
    success : function(data){
        if(data=="1")
        {
            alert('Already exists');
            return false;
        }
        else
        {
            alert('available');
            return false;
        }
    }

});

Ajax Call error, Not working

1 Answers1