Cacher is the code snippet organizer for pro developers

include_once('connections/location_db.php');
    $query = "SELECT categoryID, categoryName FROM location_categories";
    $result = $conn->query($query);
    $location_categories_array = [];
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            $location_categories_array[$row['categoryID']] = $row['categoryName'];
        }
    }
    return $location_categories_array;
    $conn->close();