function remove_section_images($connection, $id)
{
$images = get_section_images($connection, $id);
foreach ($images as $image) {
remove_image_file($image['filePath']);
}
$delete_images_by_section_id_stmt = delete_images_by_section_id_stmt($connection);
$delete_images_by_section_id_stmt->bind_param("i", $id);
catch_execution_error($delete_images_by_section_id_stmt->execute(), $connection);
}
function get_sections($connection)
{
$connection->begin_transaction();
$get_section_query = <<<SQL
select s.id, s.type, s.title
from section s
order by s.order asc;
SQL;
if ($results = $connection->query($get_section_query)) {
$result_array = [];
while ($row = $results->fetch_assoc()) {
$id = $row['id'];
$type = $row['type'];
$array_builder = array("id" => $id, "title" => $row['title'], "type" => $type, "text" => "", "buttonText" => "", "images" => [], "youtubes" => []);
if ($type == "TEXT" || $type == "INTRO" || $type == "JOIN" || $type == "MODS") {
$array_builder["text"] = get_section_text($connection, $id);
if ($type == "JOIN" || $type == "MODS") {
$array_builder["buttonText"] = get_section_button_text($connection, $id);
}
} else {
if ($type == "MEDIA") {
$array_builder["images"] = get_section_images($connection, $id);
$array_builder["youtubes"] = get_section_youtubes($connection, $id);
}
}
$result_array[] = $array_builder;
}
print "[[\"SUCCESS\"],";
print json_encode($result_array);
print "]";
$results->close();
} else {
$error = $connection->error;
print "[[\"ERROR\"],[\"{$error}\"]]";
exit;
}
$connection->commit();
}