Lua登录系统

我在使用Corona SDK Lua中将信息发送到我的数据库时遇到了问题。我先前使用$_GET方法,但被告知这不安全,所以我切换到_POST,但我一直收到else语句,但我的控制台日志没有显示任何错误。

register.php:

// 检查连接
             if ($con->connect_error) {
             die("检查连接。");
                }

                if(isset($_POST['Register'])) {
            if ($_POST['pw'] == $_POST['pw2']) {
                 $username = mysqli_real_escape_string($con, $_POST["username"]);
                 $pw= mysqli_real_escape_string($con, $_POST["pw"]);
                 $email = mysqli_real_escape_string($con, $_POST["email"]);

            $result = mysqli_query($con ,"SELECT * FROM users WHERE username='" . $username . "'");

                    if(mysqli_num_rows($result) > 0)
                    {
                    echo "用户名存在";
                    } else {

                       $result2 = mysqli_query($con ,"SELECT * FROM users WHERE email='" . $email. "'");

                       if(mysqli_num_rows($result2) > 0)
                       {
                       echo "邮件地址已存在";
                       } else {

               $sql = "INSERT INTO users (username, pw, email) VALUES('" . $username . "', '" . $pw . "', '" . $email . "')";

                       if(mysqli_query($con, $sql)){
                       // 如果插入检测成功,则回显用户名和密码保存成功
                    echo"成功";
                       }else{
                       echo mysqli_error($con);
                       }

        } } }
            }else{
            echo "密码不匹配。";  // 并将他们发送回注册页面
            }

register.lua:

local function userRegister( event )
if ( "ended" == event.phase ) then
 if emptyFields() == true then

 else

     if passwordMatch() == true then

    else

    local URL = "http://hash.comxa.com/register.php?Register=1&username=" .. username.text .. "&pw=" .. pw.text .. "&pw2=" .. pw2.text .. "&email=" .. urlencode( email.text )
    network.request(URL, "POST", networkListener)

end
end
end

local function networkListener( event )

if ( event.isError ) then
    print( "网络错误。")
else
    if event.response == "success" then
        -- 在成功注册后,在此处放置代码以转到用户所需的位置
        composer.gotoScene("login")

    else
        -- 在此处放置代码以通知用户问题,可能是本机.alert()对话框,显示其值
        -- 和返回注册屏幕,让他们重试

      local alert = native.showAlert( "注册错误", "注册出现错误。", { "再试一次" }  )

end
end
end
点赞