Samuele E. Locatelli
76 lines
1.7 KiB
PHP
76 lines
1.7 KiB
PHP
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<?php include 'header.php'; ?>
|
|
</head>
|
|
<body>
|
|
<div data-role="page" id="page1" data-title="Operatore">
|
|
<?php include 'navbar.php'; ?>
|
|
<div data-role="content" style="padding: 5px">
|
|
<form>
|
|
<div class="ui-field-contain">
|
|
<label for="newCam">Nuova Cameriera:</label>
|
|
<input name="newCam" id="newCam" value="" type="text">
|
|
</div>
|
|
<?php
|
|
|
|
include 'db.php';
|
|
$db = new MyDB();
|
|
if(!$db){
|
|
echo $db->lastErrorMsg();
|
|
} else {
|
|
// gestione vallori da URL
|
|
$newCam=$_GET[newCam];
|
|
$cmd=$_GET[cmd];
|
|
$oid=$_GET[oID];
|
|
|
|
// verifico se devo cancellare qualcosa
|
|
if($cmd=="del" && $oid!="")
|
|
{
|
|
$sql = "DELETE FROM Cameriere WHERE ID = '$oid';";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Cameriera eliminata!";
|
|
}
|
|
}
|
|
else if($cmd=="sel" && $oid!="")
|
|
{
|
|
$_SESSION[cameriera]=$oid;
|
|
}
|
|
// altrimenti verifico se devo aggiungere qualcosa
|
|
else if($newCam!="")
|
|
{
|
|
$sql = "INSERT INTO Cameriere (ID) Values ('$newCam');";
|
|
$ret = $db->exec($sql);
|
|
if(!$ret){
|
|
error_log($db->lastErrorMsg());
|
|
} else {
|
|
echo "Cameriera aggiunta!";
|
|
}
|
|
}
|
|
$sql = "SELECT * FROM Cameriere ORDER BY ID;";
|
|
$ret = $db->query($sql);
|
|
|
|
echo "<ul data-role=\"listview\" data-mini=\"true\" data-inset=\"true\">";
|
|
while($row = $ret->fetchArray(SQLITE3_ASSOC) ){
|
|
echo "<li><a href=\"?cmd=sel&setCam=".$row['ID']."\">".$row['ID']."</a><a href=\"?cmd=del&oID=".$row['ID']."\" data-icon=\"delete\" onclick=\"return confirm('Sicuro di voler cancellare?');\"></a></li>";
|
|
}
|
|
echo "</ul>";
|
|
|
|
$db->close();
|
|
}
|
|
|
|
|
|
?>
|
|
</form>
|
|
</div>
|
|
<?php include 'footer.php'; ?>
|
|
</div>
|
|
<script>
|
|
//App custom javascript
|
|
</script>
|
|
</body>
|
|
</html>
|