PHP Delete::delete_locationの例

コード例 #1

ファイル: delete_location.php プロジェクト: nloadholtes/people-prodigy

include "../session.php";
include "header.php";
class Delete
{
    function Delete($common, $db_object, $id, $denotes)
    {
        $location_relate = $common->prefix_table("location_relate");
        $qry = "select loc_id from {$location_relate} where sub_id='{$id}'";
        $main_id = $db_object->get_a_line($qry);
        $this->mainid = $main_id["loc_id"];
    }
    function delete_location($common, $db_object, $id, $denotes)
    {
        $location = $common->prefix_table("location");
        $location_relate = $common->prefix_table("location_relate");
        $qry = "delete from {$location} where loc_id='{$id}'";
        $db_object->insert($qry);
        $qry2 = "select sub_id from {$location_relate} where loc_id='{$id}'";
        $result = $db_object->get_rsltset($qry2);
        $qry1 = "delete from {$location_relate} where sub_id='{$id}'";
        $db_object->insert($qry1);
        for ($i = 0; $i < count($result); $i++) {
            $this->delete_location($common, $db_object, $result[$i]["sub_id"], $denotes);
        }
        $id = $this->mainid;
        echo "<script language='javascript'>window.location.replace('location_settings.php?id={$id}&denotes={$denotes}')</script>";
    }
}
$delobj = new Delete($common, $db_object, $id, $denotes);
$delobj->delete_location($common, $db_object, $id, $denotes);
include "footer.php";