📄 module_delete.php
字号:
<?php
function content_delete($course) {
global $db;
// related_content + content:
$sql = "SELECT content_id FROM ".TABLE_PREFIX."content WHERE course_id=$course";
$result = mysql_query($sql, $db);
while ($row = mysql_fetch_array($result)) {
$sql = "DELETE FROM ".TABLE_PREFIX."related_content WHERE content_id=$row[0]";
$result2 = mysql_query($sql, $db);
$sql3 = "DELETE FROM ".TABLE_PREFIX."member_track WHERE content_id=$row[0]";
$result3 = mysql_query($sql3, $db);
}
$sql = "DELETE FROM ".TABLE_PREFIX."content WHERE course_id=$course";
$result = mysql_query($sql,$db);
$sql = "OPTIMIZE TABLE ".TABLE_PREFIX."content";
$result = @mysql_query($sql, $db);
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -