我有三页:
1)index.php(从select.php获取结果并将它们放入div#results)
2)select.php(循环到MySQL的表中)
3)delete.php(获取user_id作为参数并从MySQL的表中删除它).
我的目标是:用户点击删除后!显示更新的结果(更改/删除后)
来自MySQL的表
我的问题是我不知道如何告诉jQuery:listen process delete.php?id = 123&然后
在保留index.php的同时重新加载select.php而不重定向到delete.php
所以用户实际上看不到会发生什么,或者看不到他被重定向到
另一页.
的index.php
a$(function() {
$('#result').load('select.php');
});
select.php
$con = mysql_connect("localhost","root","123");
if (!$con) { die('Could not connect: '); }
mysql_select_db("test", $con);
$result = mysql_query("select * from users");
while($rs3 = mysql_fetch_array($result)) {
echo $rs3["user_email"]." ".$rs3["user_name"]." ";
echo "Delete";
echo "
";
}
?>
delete.php
$con = mysql_connect("localhost","root","123");
if (!$con) { die('Could not connect: '); }
mysql_select_db("test", $con);
$id = mysql_escape_string($_GET["id"]);
$delete = "delete from users where user_id='{$id}'";
@mysql_query($delete);
?>
谢谢.