function delete_($ID, $isFolder = 0)
{
global $db;
if ($isFolder) {
$error = 0;
//delete notes in folder
$sql = "delete from notes where parentFolder = '" . $ID . "'";
$db->query($sql);
//$error = 0 || ($db->affected()==0);
//delete subfolder and subfiles
$sql = "select * from folders where parentFolder = '" . $ID . "'";
$res = $db->query($sql);
if ($db->count($sql) > 0) {
while ($data = mysqli_fetch_array($res)) {
$folderID = $data['folderID'];
$result = delete_($folderID, 1);
if ($result['error']) {
$error = $error . '|2';
}
}
}
//delete folder itself
$sql = "delete from folders where folderID = '" . $ID . "'";
$db->query($sql);
$error = $db->affected() == 0 ? $error . '|no folder deleted with ID' : $error;
return array("error" => $error);
} else {
$sql = "delete from notes where noteID = '" . $ID . "'";
$db->query($sql);
$error = 0 || $db->affected() == 0;
return array("error" => $error);
}
}
//根据请求进行数据操作
switch (@$param['type']) {
case 'add':
add_();
break;
case 'updateOK':
update_();
break;
case 'update':
getOne();
break;
case 'list':
list_();
break;
case 'delete':
delete_();
break;
case 'openvalid':
openvalid();
break;
case 'closevalid':
closevalid();
break;
case 'openReview':
openReview();
break;
case 'closeReview':
closeReview();
break;
default:
}
