Kleines Lagerprogramm coden

protected function storeData($artikel, $menge, $lagerort, $kommentar)
    {
        //$sql = "INSERT INTO testLager(artikel,menge,lagerort,kommentar) VALUES('$artikel','$menge','$lagerort','$kommentar');"; 
        $sql = "INSERT INTO testLager(artikel,menge,lagerort,kommentar) VALUES ('$artikel','$menge','$lagerort','$kommentar')  
        ON DUPLICATE KEY UPDATE menge=menge+'$menge', kommentar='$kommentar';";   
        if (!$sql) {
            throw new Exception('Fehler bei Speichern in Datenbank'.$sql);  
        }
        mysqli_query($this->db, $sql);


    }

protected function getViewData()
    {
        $sql = 'SELECT lagerort FROM lagerort ORDER BY lagerort;';  
        $recordset = $this->db->query($sql);
        if (!$recordset) {
            throw new Exception('Fehler bei der Datenbank Abfrage'.$sql);  
        }
        $lagerortArray = array();
        $i = 0;
        while ($lagerort = $recordset->fetch_assoc()) {
            $lagerortArray[$i] = $lagerort['lagerort'];  
            ++$i;
        }
        $recordset->free();

        return $lagerortArray;
    }

protected function getArticleData()
    {
        $sql = 'SELECT material FROM material ORDER BY material;';  
        $recordset = $this->db->query($sql);
        if (!$recordset) {
            throw new Exception('Fehler bei der Datenbank Abfrage'.$sql);  
        }
        $itemArray = array();
        $i = 0;
        while ($item = $recordset->fetch_assoc()) {
            $itemArray[$i] = $item['material'];  
            ++$i;
        }
        $recordset->free();

        return $itemArray;
    }

protected function generateView()
    {
        $lagerort = $this->getViewData();
        $item = $this->getArticleData();
        $this->generatePageHeader('Lager');  
        $this->generateMenu();

        echo <<< showHTML
  <h1> Drumcafe Lager </h1>
  <small>Mit * gekennzeichnete Felder sind Pflicht</small>
  <form method="POST" action="lager.php" onsubmit="return checkIsSet();">  
  <label class="mobile">  
  Artikel*<br/>
  <!--<input type="text" name="artikel"/>--> 
  <select name="artikel" size="1">  
  <option value="1" selected>Auswählen ...</option>  
showHTML;
        foreach ($item as $key => $value) {
            $value = htmlspecialchars($value);
            echo <<< showHTML
    <option>$value</option>
showHTML;
        }
        echo <<< showHTML
  </select>
  </label>
  <label class="mobile">  
  Menge*<br/>
  <input type="text" name="menge" size="10"/>  
  </label>
  <label class="mobile">  
  Lagerort*<br/>
  <!--<input type="text" name="lagerort"/>--> 
  <select name="lagerort" size="1">  
  <option value="1" selected>Auswählen ...</option>  
showHTML;
        foreach ($lagerort as $key => $value) {
            $value = htmlspecialchars($value);
            echo <<< showHTML

            <option>$value</option>
showHTML;
        }
        echo <<< showHTML
  </select>
  </label>
  <label class="mobile">  
  Kommentar<br/>
  <input type="text" name="kommentar"/>  
  </label>
  <!--<input type="submit" class="submit submit1" name="speichern" value="einlagern"/>--> 
  <button type="submit" class="submit submit1" name="speichern">einlagern</button>  
  <button type="submit" class="submit submit2" name="auslagern">Auslagern</button>  
  <!--<input type="submit" class="submit submit2" name="auslagern" value="auslagern"/>--> 
  </form>
showHTML;
        $this->showStockData();
        $this->generatePageFooter();
    }