<?php
    require "db.php";

    function get_item_base_attributes(){
        $conn = get_db_connection();
        $rows = [];
        $query = "SELECT COLUMN_NAME
                  FROM INFORMATION_SCHEMA.COLUMNS
                  WHERE TABLE_SCHEMA = 'inventory' AND TABLE_NAME = 'item_info';";
        $data = mysqli_query($conn, $query);

        while($row = mysqli_fetch_array($data)){
            $rows[] = str_replace("_", " ", $row["COLUMN_NAME"]);
        }

        $data->free();
        $conn->close();

        return $rows;
    }
?>