所属分类:PHP实例-Ajax
详细介绍:
前台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);
}