function insert_item($PO_num)
{
    if ($PO_num <= 0) {
        return $PO_num;
    }
    include 'php/dbconnect.php';
    if ($link->connect_error) {
        die("Connection failed: " . $link->connect_error);
    }
    $Insert_OK = TRUE;
    $sql = "SELECT SKU, Count FROM purchase_order_log WHERE PONumber = '{$PO_num}'";
    $result = $link->query($sql);
    if ($result->num_rows > 0) {
        // use the first row
        $row = $result->fetch_assoc();
        $SKU = $row["SKU"];
        $Count = get_stock_count($SKU);
        $PO_Count = $row["Count"];
        if (is_consumable($SKU)) {
            //Is consumable
            $sql = "UPDATE item SET Stock_Count=Stock_Count+{$PO_Count} WHERE item.SKU={$SKU}";
            $result = $link->query($sql);
            $sql = "SELECT Description, Manufacturer FROM item WHERE SKU = {$SKU}";
            $result = $link->query($sql);
            if ($result->num_rows > 0) {
                // use the first row
                $row = $result->fetch_assoc();
                $Description = $row["Description"];
                $Manufacturer = $row["Manufacturer"];
                echo "<h3>Consumable Item Updated</h3>";
                echo "<br>";
                echo "Description: ";
                echo $Description;
                echo "<br>";
                echo "Manufacturer: ";
                echo get_manufacturer($Manufacturer);
                echo "<br>";
                echo "SKU: ";
                echo $SKU;
                echo "<br>";
                echo "Stock Count: ";
                echo $Count;
                echo "<br>";
            } else {
                //Database error
                $Insert_OK = FALSE;
            }
        } else {
            //Not consumable
            for ($i = 1; $i <= $PO_Count; $i++) {
                $Serial_Number = get_serial_number();
                $sql = "SELECT Description, Manufacturer FROM item WHERE SKU = {$SKU}";
                $result = $link->query($sql);
                if ($result->num_rows > 0) {
                    // use the first row
                    $row = $result->fetch_assoc();
                    $Description = $row["Description"];
                    $Manufacturer = $row["Manufacturer"];
                    $sql = "INSERT INTO item (Description, Manufacturer, Serial_Number, SKU, Stock_Count) VALUES ('{$Description}', '{$Manufacturer}', '{$Serial_Number}', '{$SKU}', 1)";
                    if ($link->query($sql) === TRUE) {
                        echo "<h3>Equipment Entered</h3>";
                        echo "<br>";
                        echo "Description: ";
                        echo $Description;
                        echo "<br>";
                        echo "Manufacturer: ";
                        echo get_manufacturer($Manufacturer);
                        echo "<br>";
                        echo "Serial Number: ";
                        echo $Serial_Number;
                        echo "<br>";
                        echo "SKU: ";
                        echo $SKU;
                        echo "<br>";
                        echo "Stock Count: ";
                        echo $Count;
                        echo "<br>";
                    } else {
                        $Insert_OK = FALSE;
                        echo "Error: " . $sql . "<br>" . $link->error;
                    }
                } else {
                    //Database error
                    $Insert_OK = FALSE;
                }
            }
        }
    } else {
        //error PO number not found
        $Insert_OK = FALSE;
    }
    if ($Insert_OK == TRUE) {
        close_PO($PO_num);
    }
    return $PO_num;
}
<?php 
if (isset($_POST['Submit'])) {
    echo "<h3>Purchase Order Submitted</h3>";
    echo "<br>";
    echo "Requestor: ";
    echo $_SESSION['username'];
    echo "<br>";
    echo "SKU: ";
    echo $SKU;
    echo "<br>";
    echo "Description: ";
    echo $description[$SKU];
    echo "<br>";
    echo "Manufacturer: ";
    echo get_manufacturer($manufacturer[$SKU]);
    echo "<br>";
    echo "Count: ";
    echo $count;
    echo "<br>";
    create_purchase_order($SKU, $count, $_SESSION['username']);
}
?>

</div>
<?php 
include 'php/footer.php';
?>
</body>

</html>