删除无限分类并同时删除它下面的所有子分类的方法_PHP教程

<br>$act = isset ($_GET['act']) ? trim ($_GET['act']) : "; <br>if ($act == 'del') <br>{ <br>$sort_id = isset ($_GET['id']) ? intval($_GET['id']) : '0' ; <br>$sort_ids = $sort_id; <br>$childrenIds = getChildrenIds ($sort_id); <br>if (!empty ($childrenIds)) <br>{ <br>$sort_ids .= $childrenIds; <br>} <br>$sql = “delete from `article_sort` WHERE `sort_id` in ({$sort_ids})"; <br>$res = mysql_query ($sql); <br>if ($res) <br>{ <br>alert ('删除成功'); <br>exit; <br>} <br>else <br>{ <br>alert ('删除失败'); <br>exit; <br>} <br>} <br> <br>getChildrenIds 这个函数以前已经给出来过，不清楚的请参考 自定义函数之获取无限分类ID下的子类ID集 <br><br>自定义函数之获取无限分类ID下的子类ID集<br><span style="CURSOR: pointer" onclick="doCopy('code77341')"><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>/*—————————————————— */ <br>//– 获取无限分类ID下面的子类ID集 <br>//– $sort_id = $sort_id.getChildrenIds($sort_id); <br>//– $sql = " ….. where sort_id in ($sort_id)"; <br>/*—————————————————— */ <br>function getChildrenIds ($sort_id) <br>{ <br>global $db; <br>$ids = "; <br>$sql = "SELECT * FROM ".$db->table('article_sort')." WHERE `parent_id` = '{$sort_id}'"; <br>$res = $db->query ($sql); <br>if ($res) <br>{ <br>while ($row = $db->fetch_assoc ($res)) <br>{ <br>$ids .= ','.$row['sort_id']; <br>$ids .= getChildrenIds ($row['sort_id']); <br>} <br>} <br>return $ids; <br>} <br></li><li><p></p></li><li><p align="left"><span id="url" itemprop="url">http://www.bkjia.com/PHPjc/322322.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http://www.bkjia.com/PHPjc/322322.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description"> 代码如下:</span></p><pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li>$act = isset ($_GET['act']) ? trim ($_GET['act']) : "; if ($act == 'del') { $sort_id = isset ($_GET['id']) ? intval($_GET['id']) : '0' ; $sort_ids = $sor...<p></p></li><li>                    </li></ol></pre></li></ol></pre>