jQuery+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 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);
}
<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);
}
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); }
常见问题FAQ
- 免费下载或者VIP会员专享资源能否直接商用?
- 下载资源需要解压密码,解压密码是什么?
1、本站所有资源来源于用户上传和网络,如有侵权请邮件联系站长!
2、分享目的仅供大家学习和交流,请不要用于商业用途!
3、本站提供的源码、模板、插件等等其他资源,都不包含技术服务请大家谅解!
4、如有链接无法下载、失效或广告,请联系管理员处理!
5、本站资源售价只是赞助,收取费用仅维持本站的日常运营所需!
OO.INK资源网 » jQuery+PHP实现开关效果
2、分享目的仅供大家学习和交流,请不要用于商业用途!
3、本站提供的源码、模板、插件等等其他资源,都不包含技术服务请大家谅解!
4、如有链接无法下载、失效或广告,请联系管理员处理!
5、本站资源售价只是赞助,收取费用仅维持本站的日常运营所需!
OO.INK资源网 » jQuery+PHP实现开关效果