dedecms自动更新一级栏目的排序程序

作者：袖梨 2022-06-25

代码如下

复制代码

require_once (dirname ( __FILE__ ) . '/core/include/common.inc.php');
$dsql = "select * from dede_arctype where topid='0'";
$db->SetQuery ( $dsql );
$db->Execute ();
$i = 1;
while ( $row = $db->GetArray () ) {
$dsql = "update dede_arctype set sortrank='{$i}' where id='{$row['id']}'";
if($db->ExecuteNoneQuery($dsql)){
echo "成功更新ID {$row['id']} {$row['typename']}={$row['sortrank']}

";
}
else{
echo $dsql.'

';
}
$i ++;
}
?>