<?php

function get_all_categories(): array
{
	$sql = "SELECT cat_id FROM categories ORDER BY cat_id;";
	$result = Database::get()->query($sql);

	$categories = array();

	foreach ($result as $row) {
		$category = new Category();
		$category->get_from_database($row['cat_id']);
		array_push($categories, $category);
	}

	return $categories;
}