Bonjour,
Je ne comprends pas pourquoi cette erreur apparait, pouvez vous m'aider ?
https://cdn.discordapp.com/attachments/295221108901281794/479061019658944513/unknown.png
<?php
session_start();
include "../include/functions.php";
$folderId = $_POST["folder"];
$totalFolderSize = 0;
$db = connectDb();
$query = $db->prepare("SELECT target FROM FOLDER WHERE id=:id");
$query->bindParam(':id', $folderId);
$query->execute();
$result = $query->fetch();
$query = $db->prepare("SELECT size FROM FILE WHERE id_folder=:id_folder");
$query->bindParam(':id_folder', $folderId);
$query->execute();
$fileSize = $query->fetchAll();
foreach ($fileSize as $size) {
$totalFolderSize = $totalFolderSize + $size["size"];
}
$query = $db->prepare("SELECT id FROM FOLDER WHERE id_folder=:id_folder");
$itemsFolderList = [];
folderList($query, $folderId, $itemsFolderList);
$queryDeleteItem = $db->prepare("DELETE FROM FILE WHERE id_folder=:id_folder; DELETE FROM FILE_SHARE WHERE id_folder=:id_folder; DELETE FROM FOLDER WHERE id_folder=:id_folder; DELETE FROM FOLDER_SHARE WHERE id_folder=:id_folder");
$queryFileSize = $db->prepare("SELECT size FROM FILE WHERE id_folder=:id_folder");
foreach ($itemsFolderList as $item) {
$queryFileSize->bindParam(':id_folder', $item["id"]);
$queryFileSize->execute();
$fileSize = $queryFileSize->fetchAll();
$queryFileSize->closeCursor();
foreach ($fileSize as $size) {
$totalFolderSize = $totalFolderSize + $size["size"];
}
$queryDeleteItem->bindParam(':id_folder', $item["id"]);
$queryDeleteItem->execute();
}
