weixin_33736649 2017-11-02 10:00 采纳率: 0%
浏览 36

在Ajax中测试PHP响应

I'm making a simple registration mechanism that stores username and password into a MySQL database. How it works:

  1. User enters his data into textboxes.
  2. The values get fetched and validation via JQuery script.
  3. If the validation is passed, an Ajax call is made to a PHP file that then checks if the Username has already been taken. If it's taken, it does echo '0'. If not, it does echo '1' and inserts the values into the database.
  4. Jquery then checks the response and does an appropriate action.

    $.ajax({
        type: "POST",
        url: "register.php",
        data: {usn:us, pwd: pw},
        cache: false,
        success: function(result){
            console.log(result);
            if (result=='1'){
                window.location = "next.php";
            }else{
                errorMessage= "Username taken. <br>";
                $("#regerrormsg").html(errorMessage);
            }
        }
        });
    

PHP:

include 'dbconnect.php';
    $us = $_POST["usn"];
    $pw = $_POST["pwd"];

    $tryus = $conn->query("SELECT Username from users WHERE Username='" . $us . "'");
    if ($tryus->num_rows == 0){
        echo '1';
        $conn->query("INSERT INTO users (ID, Username, Password) VALUES (DEFAULT, '" . $us . "', '" . $pw . "')");  
        session_start();
        $_SESSION["user"] = $us;
    }else{
        echo '0';
    }

Now, here's the weird thing. This pretty much works, except for one part. The query does indeed check if the username already exist and it does echo the appropriate value ('0' or '1'). I've tested this by logging the output in the javascript file. I've also checked my database and it never stores a duplicate user. But, for some weird reason, the window.location = "next.php"; is never executed, even when the value of the output is '1'. It always goes to the 'else' block. Any idea why this is happening? Thanks.

  • 写回答

2条回答 默认 最新

  • bug^君 2017-11-02 10:04
    关注

    The best way to check backend responses is to use a REST Api Client. Postman is the most popular but I prefer Insomnia. Try it out, in my opinion it's a must have for front-end development.

    评论

报告相同问题?

悬赏问题

  • ¥15 Qt4代码实现下面的界面
  • ¥15 prism提示我reinstall prism 如何解决
  • ¥15 asp.core 权限控制怎么做,需要控制到每个方法
  • ¥20 while循环中OLED显示中断中的数据不正确
  • ¥15 这个视频里的stm32f4代码是怎么写的
  • ¥15 JNA调用DLL报堆栈溢出错误(0xC00000FD)
  • ¥15 请教SGeMs软件的使用
  • ¥15 自己用vb.net编写了一个dll文件,如何只给授权的用户使用这个dll文件进行打包编译,未授权用户不能进行打包编译操作?
  • ¥50 深度学习运行代码直接中断
  • ¥20 需要完整的共散射点成像代码