Action = "insert";
$InsertQuery->Table = "service";
$InsertQuery->bindColumn("servicename", "s", "".((isset($_POST["servicename"]))?$_POST["servicename"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("wpcatalognumber", "i", "".((isset($_POST["wpcatalognumber"]))?$_POST["wpcatalognumber"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("day", "s", "".((isset($_POST["classdayday"]))?$_POST["classdayday"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("time", "s", "".((isset($_POST["classtime"]))?$_POST["classtime"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("category", "i", "".((isset($_POST["servicecategory"]))?$_POST["servicecategory"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("maxcapacity", "i", "".((isset($_POST["maxcapacity"]))?$_POST["maxcapacity"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("colorclass", "s", "".((isset($_POST["colorclass"]))?$_POST["colorclass"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("classduration", "d", "".((isset($_POST["classduration"]))?$_POST["classduration"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
setQuery("SELECT * FROM service LEFT JOIN servicecategory on service.category=servicecategory.idservicecategory");
$servicesclass->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);
?>
YogiBook - Prenotazioni YogaSoul
Benvenuta/o
Di seguito puoi vedere lo stato delle tue prenotazioni
Propagazione avvenuta con successo
|
Classe |
Giorno |
Orario |
Durata |
Categoria |
Action |
atEnd()) {
$wa_startindex = $servicesclass->Index;
?>
|
|
getColumnVal("day")); ?>
|
getColumnVal("time")); ?>
|
getColumnVal("classduration")); ?>
|
getColumnVal("namecategory")); ?>
|
">
getColumnVal("idservice"); ?>
">
|
|
|
moveNext();
}
$servicesclass->moveFirst(); //return RS to the first record
unset($wa_startindex);
unset($wa_repeatcount);
?>