PHP ItemTable::get_items_categories示例

if (isset($_POST["addItem"])) {
    try {
        if (!ItemTable::add_new_item($_POST["itemName"], $_POST["itemUnit"])) {
            echo '<div class="error">Item already exists</div>';
        } else {
            if (!empty($_POST["itemQuant"])) {
                BaseQuantityTable::set_base_quantity($_POST["itemName"], $_POST["itemQuant"]);
            }
            echo '<div class="error">Item added successfully</div>';
        }
    } catch (Exception $e) {
        echo '<div class="error">' . $e->getMessage() . '</div>';
    }
}
if (isset($_POST["getItems"])) {
    $result = ItemTable::get_items_categories();
    $current_category = 1;
    while ($row = $result->fetch_assoc()) {
        if ($row["category_name"] != $current_category and $row["category_name"] != null) {
            $current_category = $row["category_name"];
            echo '
                <tr class="item_category_tr">
                    <td id="category" colspan="5" class="table_heading"><h4 class="none">' . $row["category_name"] . '<span class="arrow_down float_right collapse_arrow"></span></h4></td>
                </tr>';
        } else {
            if ($row["category_name"] != $current_category and $row["category_name"] == null) {
                $current_category = $row["category_name"];
                echo '
                <tr class="item_category_tr">
                    <td id="category" colspan="5" class="table_heading"><h4 class="none">' . "Uncategorized Items" . '<span class="arrow_down float_right collapse_arrow"></span></h4></td>
                </tr>';