lastErrorMsg(); } else { // gestione vallori da URL $reqReset=$_GET[btnReset]; $newCID=$_GET[selCID]; $newArt=$_GET[selArt]; $newQta=$_GET[newQta]; $newNote=$_GET[newNote]; $note=""; $qta=$newQta; $mode=""; if ( $reqReset == 'Reset') { $cmd=""; $newCID=""; } if($oid!="" && $cmd=="edit" && $mode=="") { $mode="upd"; $sql = "SELECT * FROM Ordini WHERE ID =$oid;"; $ret = $db->query($sql); while($row = $ret->fetchArray(SQLITE3_ASSOC) ){ $note=$row['Note']; $qta=$row['Qta']; } } ?>
sel
".$newCID.""; } else { $sql="SELECT * FROM Tipi ORDER BY ID;"; $ret = $db->query($sql); while($row = $ret->fetchArray(SQLITE3_ASSOC) ){ echo "
".$row['ID']."
"; } } ?>
query($sql); while($row = $ret->fetchArray(SQLITE3_ASSOC) ){ echo "
".$row['Articolo']."
"; } ?>
res
QuantitÃ
Note:
Annulla
Salva
exec($sql); if(!$ret){ error_log($db->lastErrorMsg()); } else { echo "Articolo eliminato!"; } } // altrimenti verifico se devo aggiungere o modificare qualcosa else if($newArt!="" && $newQta!="") { if($mode=="upd") { //$sql = "UPDATE Listino SET Articolo='$newArt',Prezzo='$newQta' WHERE ID = $oid;"; //$ret = $db->exec($sql); //if(!$ret){ // error_log($db->lastErrorMsg()); //} else { // echo "Articolo modificato!"; //} } else { $sql = "INSERT INTO Ordini (TavID,Cameriera,ArtID,Qta,Note) Values ($_SESSION[tavolo],'$_SESSION[cameriera]','$newArt',$newQta,'$newNote');"; $ret = $db->exec($sql); if(!$ret){ error_log($db->lastErrorMsg()); } else { echo "Articolo aggiunto!"; } } } $sql = "SELECT o.*, l.Articolo FROM Ordini o INNER JOIN Listino l ON o.ArtID = l.ID WHERE TavID=$_SESSION[tavolo] ORDER BY Articolo;"; $ret = $db->query($sql); echo "
"; while($row = $ret->fetchArray(SQLITE3_ASSOC) ){ echo "
".$row['Articolo']." (".$row['Note'].")
".$row['Qta']."
"; } echo "
"; $db->close(); } ?>