利用jQuery+Ajax+PHP实现属性开关效果

详细介绍：

前台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 demo_04 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", { //将指令提交给ajax.php进行处理，并返回对应状态
        id: id 
    }, 
    function(data)
	{ 
        if (data == "1")
		{ //返回1则进行以下处理
            obj.parent("td").html(" + id + ")>是"); 
        }
		else
		{ //否则进行以下处理
            obj.parent("td").html(" + id + ")>否"); 
        } 
    }) 
}

后端php（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); 
}