The efficacy and function of Cordyceps sinensis and how to consume it. How to delete unlimited categories and delete all subcategories under it at the same time.

Copy code The code is as follows:

$act = isset ($_GET['act']) ? trim ($_GET['act']) : ";
if ($act == 'del' )
{
$sort_id = isset ($_GET['id']) ? intval($_GET['id']) : '0' ;
$sort_ids = $sort_id;
$childrenIds = getChildrenIds ($sort_id);
if (!empty ($childrenIds))
{
$sort_ids .= $childrenIds;
}
$sql = "delete from `article_sort` WHERE `sort_id` in ({$sort_ids})";
$res = mysql_query ($sql);
if ($res)
{
alert ('Deletion successful');
exit;
}
else
{
alert ('Deletion failed');
exit;
}
}

getChildrenIds This function has been given before. If you are not sure, please refer to Custom Function to Get the Subcategory ID Set under Unlimited Category IDs
Custom Function to Get the Subcategory ID Set under Unlimited Category IDs

Copy the code The code is as follows:

/*———————————————————— */
//– Get the subcategory ID set under the unlimited category ID
//– $sort_id = $sort_id.getChildrenIds($sort_id);
//– $sql = "….. where sort_id in ($sort_id)";
/*—————————————————— */
function getChildrenIds ($sort_id)
{
global $db;
$ids = ";
$sql = "SELECT * FROM ".$db->table('article_sort')." WHERE `parent_id` = '{$sort_id}'";
$res = $db->query ($sql);
if ($res)
{
while ($row = $db->fetch_assoc ($res))
{
$ids .= ','.$row['sort_id'];
$ids .= getChildrenIds ($row['sort_id']);
}
}
return $ids;
}

The above introduces the efficacy and function of Cordyceps sinensis and how to eat it. How to delete unlimited categories and delete all sub-categories under it at the same time, including the efficacy and function of Cordyceps sinensis and how to eat it. I hope friends who are interested in PHP tutorials will have it. helped.