<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<TITLE>Displaying tables</TITLE>
<script type="text/javascript" src ="js/jquery-1.7.2.min.js"></script>
</head>
<body>
<form action="employeeDataEditingLogic.php" method="post">
<fieldset>
<h1>Employee Info and Editing data</h1>
<?php
include_once 'DataBase.php';
if (isset($_POST['id'])) {
$employeeId = (int) $_POST['id'];
if (EmployeeExists($employeeId)) {
$result = DataBase::getInstance()->query("select * from `Representative` WHERE `ID` = '{$employeeId}'");
$repsArray = array();
while (($row = mysql_fetch_assoc($result)) !== false) {
$repsArray[] = array('ID' => $row['ID'], 'Phone' => $row['Phone'], 'FirstName' => $row['FirstName'], 'LastName' => $row['LastName'], 'E-mail' => $row['E-mail'], 'Password' => $row['Password'], 'Permission' => $row['Permission']);
}
if (count($repsArray) != 0) {
echo '<br>';
echo "<table border='1'>\r\n <tr>\r\n <th>FirstName</th>\r\n <th>LastName</th>\r\n <th>Phone</th>\r\n <th>E-mail</th>\r\n <th>Password</th>\r\n <th>Permission</th>\r\n\r\n </tr>";
foreach ($repsArray as $rep) {
echo "<td>" . "<input id=first_id type=text name=first value=" . $rep['FirstName'] . " </td>";
echo "<td>" . "<input id=last_id type=text name=last value=" . $rep['LastName'] . " </td>";
echo "<td>" . "<input id=phone_id type=text name=phone value=" . $rep['Phone'] . " </td>";
echo "<td>" . "<input id=email_id type=text name=email value=" . $rep['E-mail'] . " </td>";
echo "<td>" . "<input id=password_id type=text name=password value=" . $rep['Password'] . " </td>";
echo "<td>" . "<input id=permission_id type=text name=permission value=" . $rep['Permission'] . " </td>";
$number = $_POST['number'];
$postalcode = $_POST['postalcode'];
$city = $_POST['city'];
$hotel_id = $_POST['hotel_id'];
$start_date = $_POST['start_date'];
$salary = $_POST['salary'];
if (isset($_POST['end_date'])) {
$end_date = $_POST['end_date'];
} else {
$end_date = NULL;
}
if (isset($_POST['phone_number_1'])) {
$phone_number_1 = $_POST['phone_number_1'];
} else {
$phone_number_1 = NULL;
}
if (isset($_POST['phone_number_2'])) {
$phone_number_2 = $_POST['phone_number_2'];
} else {
$phone_number_2 = NULL;
}
$exists = EmployeeExists($ssn);
if (!$exists) {
$employee_id = AddEmployee($ssn, $name, $surname, $street, $number, $postalcode, $city, $hotel_id, $start_date, $end_date, $salary, $phone_number_1, $phone_number_2);
header('Location: employees_add.php?success=true');
} else {
header('Location: employees_add.php?exists=true');
}
} else {
header('Location: employees_add.php?missing=true');
}
