jQuery+PHP实现开关效果

在开发项目中，我们会经常碰到需要及时开启某项功能的情况，PHP+Ajax开关效果，通过Ajax实现实时开启和关闭功能，无疑增强了用户体验。

分类：表单代码 > 表格难易：初级

下载资源下载积分： 20 积分

PHP

<table width="100%" cellspacing="0" cellpadding="0" border="0" class="table_parameters">
    <tbody>
        <tr class="tr_head">
            <td>用户名</td>
            <td>内容</td>
            <td>是否开启</td>
        </tr>
        <?php
        $sql = "SELECT name,content,id,is_check FROM wishing_wall limit 0,10";
        $query = mysql_query($sql);
        while ($row = mysql_fetch_array($query)) {
            ?>
            <tr>
                <td align="center"><?php echo $row['name']; ?></td>
                <td><?php echo $row['content']; ?></td>
                <td align="center"><a onclick="yes($(this), '<?php echo $row['id']; ?>')"><?php
                        if ($row['is_check'] == 1) {
                            echo "是";
                        } else {
                            echo "<span style='color:red'>否</span>";
                        }
                        ?></a></td>
            </tr>   
        <?php } ?>
    </tbody>
</table>

JS

function yes(obj, id) {
    $.post("ajax.php", {
        id: id
    },
    function(data) {
        if (data == "1") {
            obj.parent("td").html("<a onclick=yes($(this)," + id + ")>是</a>");
        } else {
            obj.parent("td").html("<a onclick=yes($(this)," + id + ")><span style='color:red'>否</span></a>");
        }
    })
}

Ajax.php

include_once("connect.php");

$id = isset($_POST['id']) ? intval($_POST['id']) : 0;
if ($id > 0) {
    $sql = "SELECT is_check FROM wishing_wall WHERE id = '" . $id . "'";
    $query = mysql_query($sql);
    $row = mysql_fetch_array($query);
    if ($row['is_check'] == 0) {
        echo "1";
        $sql = "UPDATE `wishing_wall` SET `is_check` = '1' WHERE `id` = '" . $id . "';";
    } else {
        echo "-1";
        $sql = "UPDATE `wishing_wall` SET `is_check` = '0' WHERE `id` = '" . $id . "';";
    }
    mysql_query($sql);
}