javascript - Ajax 将参数发送到 php 页面时不执行任何操作

Question

我是一个使用ajax的初学者，正在尝试通过单击图像来更改阅读书籍的状态。我的代码可以工作，但没有ajax。现在我没有 php 错误，但 mysql 没有变化。代码:

<script type="text/javascript">
    function sendState(state_id){
        var hd_haveread = $("#hd_haveread").val();
        var hd_toread = $("#hd_toread").val();
        var hd_reading = $("#hd_reading").val();

        var val = 0;
        var baseurl = "img/";

        switch(state_id){
            case 1:
                if (hd_haveread == "0"){
                    document.getElementById('hd_haveread').value = "1";
                    document.getElementById('hd_toread').value = "0";
                    document.getElementById('hd_reading').value = "0";
                    val = 1;
                }
                else{
                    document.getElementById('hd_haveread').value = "0";
                    val = 0;
                }
            break;
            case 3:
                if (hd_toread == "0"){
                    document.getElementById('hd_toread').value = "1";
                    document.getElementById('hd_haveread').value = "0";
                    document.getElementById('hd_reading').value = "0";
                    val = 1;
                }
                else{
                    document.getElementById('hd_toread').value = "0";
                    val = 0;
                }
            break;
            case 2:
                if (hd_reading == "0"){
                    document.getElementById('hd_reading').value = "1";
                    document.getElementById('hd_haveread').value = "0";
                    document.getElementById('hd_toread').value = "0";
                    val = 1;
                }
                else{
                    document.getElementById('hd_reading').value = "0";
                    val = 0;
                }
            break;
        }

        var parameters = {
            "book" : <?php echo $id_book; ?>,
            "state" : state_id,
            "val" : val
        };
        $.ajax({
            cache: false,
            data:  parameters,
            url:   'change_state_ajax.php',
            type:  'post',
            dataType: "html",
            beforeSend: function (){
            },
            success: function (response){
                switch(state_id){
                    case 1:
                        if (hd_haveread == "0"){
                            $("#img_haveread1").css("display","none");
                            $("#img_haveread2").css("display","inline-block");
                            $("#img_toread1").css("display","inline-block");
                            $("#img_toread2").css("display","none");
                            $("#img_reading1").css("display","inline-block");
                            $("#img_reading2").css("display","none");
                        }
                        else{
                            $("#img_haveread1").css("display","inline-block");
                            $("#img_haveread2").css("display","none");
                        }
                    break;
                    case 3:
                        if (hd_toread == "0"){
                            $("#img_haveread1").css("display","inline-block");
                            $("#img_haveread2").css("display","none");
                            $("#img_toread1").css("display","none");
                            $("#img_toread2").css("display","inline-block");
                            $("#img_reading1").css("display","inline-block");
                            $("#img_reading2").css("display","none");
                        }
                        else{
                            $("#img_toread1").css("display","inline-block");
                            $("#img_toread2").css("display","none");
                        }
                    break;
                    case 2:
                        if (hd_reading == "0"){
                            $("#img_haveread1").css("display","inline-block");
                            $("#img_haveread2").css("display","none");
                            $("#img_toread1").css("display","inline-block");
                            $("#img_toread2").css("display","none");
                            $("#img_reading1").css("display","none");
                            $("#img_reading2").css("display","inline-block");
                        }
                        else{
                            $("#img_reading1").css("display","inline-block");
                            $("#img_reading2").css("display","none");
                        }
                    break;
                }
            }
        });
    }
</script>

以及change_state_ajax.php代码:

<?php

    if(isset($_POST['book']) && isset($_POST['state']) && isset($_POST['val'])){
        include 'connection.php';
        include('php_lib/config.ini.php');
        include_once('php_lib/login.lib.php');

        $lib_id = $_POST['book'];
        $state = $_POST['state'];
        $val = $_POST['val'];

        $result=changeState($lib_id, $state, $val); 
        echo $result;
    }

    function changeState($lib_id, $state, $val){
        session_start();
        $usu_id = $_SESSION['USSER']['id'];
        $mark = 0;
        $pos = 0;

        $query = $pdo->prepare('SELECT uliusu_id, ulilib_id, uliedl_id FROM '.TABLE_USSERS_BOOKS.' WHERE ulilib_id = :fil_lib_id AND uliusu_id = :fil_usu_id');
        $query->bindParam(':fil_lib_id', $lib_id, PDO::PARAM_INT);
        $query->bindParam(':fil_usu_id', $usu_id, PDO::PARAM_INT);
        $query->execute();

        while($row = $query->fetch(PDO::FETCH_OBJ)){
            $mark = 1;
            $state_actual = $row->uliedl_id;
        }

        if($mark == 0){
            $query = $pdo->prepare('INSERT INTO '.TABLE_USSERS_BOOKS.' (uliusu_id, ulilib_id, uliedl_id, uli_posicion, uli_fecha) VALUES (:fil_usu_id, :fil_lib_id, :fil_edl_id, :fil_pos, NOW())');
            $query->bindParam(':fil_usu_id', $usu_id, PDO::PARAM_INT);
            $query->bindParam(':fil_lib_id', $lib_id, PDO::PARAM_INT);
            $query->bindParam(':fil_edl_id', $state, PDO::PARAM_INT);
            $query->bindParam(':fil_pos', $pos, PDO::PARAM_INT);
            $query->execute();
        }else{
            if($state == $state_actual){
                $query = $pdo->prepare('DELETE FROM '.TABLE_USSERS_BOOKS.' WHERE ulilib_id = :fil_lib_id AND uliusu_id = :fil_usu_id');
                $query->bindParam(':fil_usu_id', $usu_id, PDO::PARAM_INT);
                $queryquery->bindParam(':fil_lib_id', $lib_id, PDO::PARAM_INT);
                $query->execute();
            }else{
                $query = $pdo->prepare('UPDATE '.TABLE_USSERS_BOOKS.' SET uliedl_id = :fil_edl_id WHERE ulilib_id = :fil_lib_id AND uliusu_id = :fil_usu_id');
                $query->bindParam(':fil_edl_id', $state, PDO::PARAM_INT);
                $query->bindParam(':fil_usu_id', $usu_id, PDO::PARAM_INT);
                $query->bindParam(':fil_lib_id', $lib_id, PDO::PARAM_INT);
                $query->execute();
            }
        }

        if($state == 1){
            $result = 0;
        }else{
            $result = 1;
        }

        return $result;
    }
?>

谁能帮我解决这个问题吗？

谢谢。

Answer 1

您没有检查正确的变量。您的 JavaScript 传递一个名为 estado 的 var，但您在 PHP 中检查名为 state 的 var。

并且因为您需要设置所有三个变量，所以您的条件失败。

也像汉克在他的评论中所说的那样，您的 jQuery.Ajax 调用使用 POST (type: 'post',) 但随后在您的 PHP 脚本中检查 GET 变量当然没有设置。

将 jQuery 调用类型更改为 GET 或将 PHP 脚本中的检查更改为 POST

if(isset($_POST['book']) && isset($_POST['state']) && isset($_POST['val'])){
    include 'connection.php';
    include('php_lib/config.ini.php');
    include_once('php_lib/login.lib.php');

    $lib_id = $_POST['book'];
    $state = $_POST['state'];
    $val = $_POST['val'];

    $result=changeState($lib_id, $state, $val); 
    echo $result;
}