ajax开发：ajax页面加载与删除

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>


<h2>ajax实现页面加载和内容删除</h2>
<table cellpadding="0" cellspacing="0" border="1" width="100%">
    <tr>
        <td>水果名称</td>
        <td>水果价格</td>
        <td>水果产地</td>
        <td>操作</td>
    </tr>
    <tbody id="tb"></tbody>
</table>

<script type="text/javascript">
    Load();
    function Load() {
        $.ajax({
            url: "jiazaiym.php",
            dataType: "TEXT",
            success: function (data) {
                var str = "";
                var hang = data.split("|");

                for (var i = 0; i < hang.length; i++) {
                    var lie = hang[i].split("^");
                    str = str + "<tr><td>" + lie[1] + "</td><td>" + lie[2] + "</td><td>" + lie[3] + "</td><td><input type='button' ids='" + lie[0] + "' class='sc' value='删除'/></td></tr>";

                }
                $("#tb").html(str);
                //删除页面
                $(".sc").click(function(){
                    var ids=$(this).attr("ids");
                    $.ajax({
                        url: "shanchu.php",
                        data: {ids: ids},
                        type: "POST",
                        dataType: "TEXT",
                        success: function (aa) { //去空格
                            if (aa.trim() == "OK") {
                                alert("删除成功");
                                Load();
                            }
                            else {
                                alert("删除失败");
                            }
                        }
                    })
                })
            }
        })
    }
</script>



//jiazaiym.php
<?php
include("DADB.class.php");
$db=new DADB();
$sql="select * from fruit ";
$arr=$db->Query($sql);
$str="";
foreach($arr as $v)
{
$str=$str.implode("^",$v)."|"; //每一行之间用“|”连接，这样最后就会多出一个“|”
}
$str=substr($str,0,strlen($str)-1); //把最后多出的“|”用截取字符串的方式删去
echo $str;
?>

//shanchu.php
<?php
$ids=$_POST["ids"];
include("DADB.class.php");
$db=new DADB();
$sql="delete from fruit where ids={$ids}";
if($db->Query($sql,0))
{
echo"OK";
}
else{
echo"flase";
}



</body>
</html>