function checkIfExists($con, $columnName, $data)
{
$sql = "SELECT " . $columnName . " FROM users WHERE " . $columnName . "='" . $data . "'";
$result = pushQueryToArray($con, $sql);
if (!empty($result)) {
return true;
} else {
return false;
}
}
function makeTreatmentsOfAppointment($con)
{
$sqlLatest = "SELECT max(ID) FROM appointments";
$appointmentID = pushQueryToArray($con, $sqlLatest);
foreach ($_SESSION['chosenTreatments'] as $treatment) {
$sql = "INSERT INTO appointments_has_treatments (appointments_ID, treatments_ID) VALUES (" . $appointmentID[0]['max(ID)'] . "," . $treatment . ")";
mysqli_query($con, $sql);
}
unsetAppointmentSessionVars();
redirectToHome();
}
function searchUsers($con)
{
$sql = "SELECT *\t\t\t\t\t\r\n\t\t\tFROM users\r\n\t\t\tWHERE lastName\r\n\t\t\tLIKE '%" . $_GET['search'] . "%'\r\n\t\t\tOR firstName LIKE '%" . $_GET['search'] . "%'\r\n\t\t\tOR phoneNumber LIKE '%" . $_GET['search'] . "%'\r\n\t\t\tor emailAdress LIKE '%" . $_GET['search'] . "%'\t\r\n\t\t\tORDER BY ID DESC";
$usersBySearchInput = pushQueryToArray($con, $sql);
return $usersBySearchInput;
}
<?php require '../other/config.php'; // config.php is always required. require '../functions/generalFunctions.php'; // generalFunctions.php is required on almost every page. It contains general functions used on many pages. require '../other/metaData.php'; // metaData.php is used to print the credentials of the user. checkIfLoggedIn(); //Check if the user is logged in. $nameInfo = getFullName($con, $_SESSION['ID']); //The variable nameInfo contains data about the name of the user. $sql = "SELECT * FROM users WHERE ID=" . $_SESSION['ID']; //Query that retrieves user info. $userInfo = pushQueryToArray($con, $sql); //The array userInfo contains the retrieved user info. require '../pages/requireshtml/htmlTillEndHeader.php'; ?> <div class="column"> <div class="lined"> <h1>Gegevens van <?php echo $nameInfo[0]; ?> </h1> <span class="bold-line"></span> </div> <p>U bent nu op de pagina 'Mijn gegevens' u kunt hiernaast zien wat uw huidige gegevens zijn.</p> <p>Druk hieronder op 'Wijzig gegevens' om uw gegevens te wijzigen. Om uw wachtwoord te wijzigen, druk op 'Wijzig wachtwoord'.</p> <a href="../pages/home.php" class="button link" id="back">Terug</a> </div> <div class="column">
function defineDay($con)
{
$day = date('l', strtotime($_SESSION['date']));
if ($day == "Sunday") {
$_SESSION['errorDate'] = "Sorry, we zijn op zondag gesloten, kies alstublieft een andere datum.";
header('Location: ../pages/steptwomakeapp.php');
die;
} else {
$sql = "SELECT starttime, endtime FROM openingtimes WHERE day='" . $day . "'";
$_SESSION['detailsOfDate'] = pushQueryToArray($con, $sql);
}
print_r($_SESSION['detailsOfDate']);
checkIfAlreadyClosed($con);
}
require '../other/config.php'; // config.php is always required. require '../functions/generalFunctions.php'; // generalFunctions.php is needed on almost every page. It contains general functions used on many pages. require '../functions/stepTwoMakeAppFunctions.php'; // stepTwoMakeAppFunctions.php is required. It contains functions used on this page. checkIfLoggedIn(); // Chekc if the user is logged in. checkIfCustomerTypeIsValid(); // Check if the customertype is valid. //SQL code to retrieve treatments and hairdressers and the corresponding arrays with the results. $sqlTreatments = "SELECT ID, name, code FROM treatments"; $treatments = pushQueryToArray($con, $sqlTreatments); $sqlHairdressers = "SELECT * FROM hairdressers"; $hairDressers = pushQueryToArray($con, $sqlHairdressers); require '../pages/requireshtml/htmlTillEndHeader.php'; ?> <div class="column"> <div class="lined"> <h1><?php echo isset($_SESSION['edit']) && $_SESSION['edit'] == true ? 'Wijzig' : 'Maak'; ?> een afspraak</h1> <span class="bold-line"></span> </div> <h2>Stap 2</h2> <p> Kies hiernaast uw gewenste behandelingen, kapper of kapster en datum. Data voor de dag van vandaag zijn niet beschikbaar voor keuze. </p>
function printAppointmentDetails($con)
{
$sql = "SELECT appointments.*, hairdressers.name AS kapster, customertypes.name AS klantType, \r\n\t\t\ttreatments.name AS behandeling, users.firstName, users.insertion, users.lastName\r\n\t\t\tFROM appointments JOIN hairdressers ON hairdressers.ID = appointments.hairDressers_ID \r\n\t\t\tJOIN customertypes ON customertypes.ID = appointments.customerTypes_ID \r\n\t\t\tJOIN users ON users.ID = appointments.USERS_ID\r\n\t\t\tJOIN (appointments_has_treatments JOIN treatments ON treatments.ID = appointments_has_treatments.treatments_ID) \r\n\t\t\tON appointments_has_treatments.appointments_ID = appointments.ID\r\n\t\t\tWHERE appointments.ID=" . $_GET['app'];
$appointmentDetails = pushQueryToArray($con, $sql);
return $appointmentDetails;
}
function createEditSessionVars($con)
{
$_SESSION['chosenTreatments'] = [];
$sqlSelectAppDetails = "SELECT\r\n\t\t\t\t\t\t\t\t\tusers_ID,\r\n\t\t\t\t\t\t\t\t\thairDressers_ID, \r\n\t\t\t\t\t\t\t\t\tdate, \r\n\t\t\t\t\t\t\t\t\ttime, \r\n\t\t\t\t\t\t\t\t\tnotice, \r\n\t\t\t\t\t\t\t\t\tduration, \r\n\t\t\t\t\t\t\t\t\tcustomerTypes_ID\r\n\t\t\t\t\t\t\t\tFROM \r\n\t\t\t\t\t\t\t\t\tappointments\r\n\t\t\t\t\t\t\t\tWHERE \r\n\t\t\t\t\t\t\t\t\tID=" . $_GET['edit'];
$appDetails = pushQueryToArray($con, $sqlSelectAppDetails);
$_SESSION['edit'] = true;
$_SESSION['appointmentID'] = $_GET['edit'];
$_SESSION['date'] = $appDetails[0]['date'];
$_SESSION['hairdresser'] = $appDetails[0]['hairDressers_ID'];
$_SESSION['notice'] = $appDetails[0]['notice'];
$_SESSION['customerType'] = $appDetails[0]['customerTypes_ID'];
$sqlSelectTreatmentsOfApp = "SELECT treatments_ID \r\n\t\t\t\t\t\t\t\tFROM appointments_has_treatments \r\n\t\t\t\t\t\t\t\t\tJOIN treatments ON treatments.ID = appointments_has_treatments.treatments_ID\r\n\t\t\t\t\t\t\t\tWHERE appointments_ID=" . $_GET['edit'];
$treatmentsQuery = mysqli_query($con, $sqlSelectTreatmentsOfApp);
$_SESSION['chosenTreatments'] = [];
foreach ($treatmentsQuery as $treatmentID) {
foreach ($treatmentID as $id) {
array_push($_SESSION['chosenTreatments'], $id);
}
}
}
