SQLɾ³ýÓï¾äÎÊÌâ - PHP / »ù´¡±à³Ì

album:
id p_id title 
1 0 Àà±ðÒ»
2 1 Àà±ðµÄ×ÓÀà
3 0 Àà±ðÈý
4 3 Àà±ðÈýµÄ×ÓÀà


album_photo:
id albumid(¶ÔÓ¦ÉÏÃæµÄid) title
1 3 ÎÄÕÂÒ»
2 4 ÎÄÕÂ2


ÏÖÔÚÐèÒª×öÒ»¸ö ɾ³ý Àà±ðµÄ²Ù×÷£¬ µ±É¾³ýalbum Ò»¸öÀà±ðµÄʱºò £¬ ¼ì²éËüÊÇ·ñÓÐ×ÓÀà±ð£¬ÈçÓоÍɾ³ý£¬ ºÍɾ³ýalbum_phot ¶ÔÓ¦µÄÎÄÕÂ
Çë¸ßÊÖÖ¸µãһϣ¬ лл

---

ÊÔÒ»ÊÔ
SQL code:

delete album ,album_photo
from
album_photo left join album on album_photo.albumid = album.id where album_photo.albumid='{$you_want_to_del_ID}'

---

Õâ¸öÒªµÝ¹é´¦Àí¡£
PHP code:

function recursion_del($pid)
{
echo "ÕýÔÚ´¦ÀíÀà±ð£º$pid <hr/> ";
$sql = "select id from album where pid = $pid";
$row = $db->get($sql); //¼ÙÉèÕâÑù¾ÍÄܵõ½Êý¾Ý²¢ÒÔobj ÐÎʽ·µ»Ø.
foreach($row as $key=>$val)
{
recursion_del($val->id);
}
handle_delete($pid);
}

function handle_delete($id)
{
$sql = "delete from album where id = $id"; //ɾÀà±ðÊý¾Ý
$db->query($sql);

$sql = "delete from album_photo where albumid = $id";
$db->query($sql);

}
recursion_del