Action = "update";
$UpdateQuery->Table = "service";
$UpdateQuery->bindColumn("servicename", "s", isset($_POST["servicename"]) ? $_POST["servicename"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("wpcatalognumber", "i", isset($_POST["wpcatalognumber"]) ? $_POST["wpcatalognumber"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("day", "s", isset($_POST["classdayday"]) ? $_POST["classdayday"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("time", "s", isset($_POST["classtime"]) ? $_POST["classtime"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("category", "i", isset($_POST["servicecategory"]) ? $_POST["servicecategory"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("maxcapacity", "i", isset($_POST["maxcapacity"]) ? $_POST["maxcapacity"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("colorclass", "s", isset($_POST["colorclass"]) ? $_POST["colorclass"] : "", "WA_DEFAULT");
$UpdateQuery->bindColumn("classduration", "d", isset($_POST["classduration"]) ? $_POST["classduration"] : "", "WA_DEFAULT");
$UpdateQuery->addFilter("idservice", "=", "s", $idservice);
$UpdateQuery->saveInSession("");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) {
$UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : "";
}
$UpdateQuery->redirect($UpdateGoTo);
}
}
?>
setQuery("SELECT * FROM service LEFT JOIN servicecategory on service.category=servicecategory.idservicecategory WHERE service.idservice='$idservice'");
$servicesclass->execute();
?>
setQuery("SELECT * FROM servicecategory");
$categoryclass->execute();
?>
connect_error) {
die("Connessione fallita: " . $conn->connect_error);
}
// Query per ottenere le categorie dal database
$query = "SELECT idservicecategory, namecategory FROM servicecategory";
$result = $conn->query($query);
?>
Starter Page | webadmin - Admin & Dashboard Template
Benvenuta/o
Modifica il tuo servizio
|
Classe |
Giorno |
Orario |
Durata |
Categoria |
Action |
atEnd()) {
$wa_startindex = $servicesclass->Index;
?>
|
|
getColumnVal("day")); ?>
|
getColumnVal("time")); ?>
|
getColumnVal("classduration")); ?>
|
getColumnVal("namecategory")); ?>
|
">
">
|
|
|
moveNext();
}
$servicesclass->moveFirst(); //return RS to the first record
unset($wa_startindex);
unset($wa_repeatcount);
?>