dsnw2651 2017-02-28 10:14
浏览 39

PHP脚本不会将变量返回给AJAX

The code is for simple login validation.

The PHP script doesnt seem to run when returning values to JavaScript but runs fine when there are not variables to return. So is there anything wrong or do I need to add anything else to return the values from PHP.

<?php
    header('Content-type: application/json; charset=utf-8');
    include("config.php");
    $formd=array();
    //Fetching Values from URL
    $username2=$_POST['username1'];
    $password2=$_POST['password1'];
    $query = mysqli_query($db,"SELECT username FROM login WHERE username = '$username2'");
    $result=mysqli_fetch_assoc($query);
    $sql=mysqli_query($db,"SELECT password FROM login WHERE username = '$username2'");
    $resul=mysqli_fetch_assoc($sql);
    $row = mysqli_fetch_array($query,MYSQLI_ASSOC);
    $count = mysqli_num_rows($query);
    $pass=$resul['password'];

    if((password_verify($password2,$pass))and($count==1)) { 
        echo "ds";
    } else {
        echo "no";
        $formd['no']="Invalid password or username"
    }
    mysqli_close($db); // Connection Closed
    echo json_encode($formd);
    exit();
?>

JavaScript

<script>
    $(document).ready(function(){
        $("#submit").click(function(){
           var username = $("#username").val();
          var password = $("#password").val();
          // Returns successful data submission message when the entered information is stored in database.
          var dataString = 'username1='+ username + '&password1='+ password;
          if(username==''||password=='') {
             alert("Please Fill All Fields");
          } else {
             // AJAX Code To Submit Form.
            $.ajax({
               type: "POST",
               url: "ajaxsubmit.php",
               dataType: "json",
               data: dataString,
               success: function(data){
                  alert(data.no);
               }
            });
          }
        return false;
      });
  });
</script>
  • 写回答

2条回答 默认 最新

  • douxiong3234 2017-02-28 10:32
    关注

    your Php code has 2 echo statements

    if((password_verify($password2,$pass))and($count==1))
    {   
       echo "ds";  // first 
    }
    else
    {
       echo "no";  // first
       $formd['no']="Invalid password or username"
    }
      mysqli_close($db); // Connection Closed
      echo json_encode($formd);   // second
    

    This way, your php script returns malformed JSON data and hence $.ajax() cannot handle it. Also, as others pointed out, please use the developer console to verify your script returns the expected data.

    评论

报告相同问题?

悬赏问题

  • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?