<?php
session_start();
// If already signed in (when we came from, for example, actavateAccount)
if (isset($_SESSION['g_username'])) {
echo "Session is on<br>";
http_response_code(302);
exit;
}
require_once "../app-config.php";
include_once ABSPATH . "/php/CDBConn.php";
include_once ABSPATH . "/php/hostconfig.php";
$login = json_decode($_POST['login']);
$password = json_decode($_POST['password']);
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123");
if (!$conn->connect()) {
http_response_code(503);
exit;
}
$check_user_sql = "SELECT * FROM users WHERE login='******' AND password='******'";
echo $conn->run_select($check_user_sql);
if ($conn->affected_rows() != 1) {
echo "user with login:'******'; and password:'******' doesnot exists" . "<br>";
http_response_code(401);
exit;
} else {
$_SESSION['g_username'] = $login;
$get_hostel_id_sql = "SELECT hostel_id FROM users WHERE login='******'";
$conn->run_query($get_hostel_id_sql);
$row = $conn->fetch_array();
$hostel_id = $row['hostel_id'];
<?php
session_start();
if (!isset($_SESSION['g_username'])) {
http_response_code(401);
exit;
}
$date_in = $_POST['date_in'];
$date_out = $_POST['date_out'];
$bed_index = $_POST['bed_index'];
$room_id = $_POST['room_id'];
require_once '../app-config.php';
include_once ABSPATH . '/php/CDBConn.php';
include_once ABSPATH . '/php/hostconfig.php';
$conn = new CDBConn($jet_ip, $db_name, $db_user, 'qwerty123', FALSE);
$conn->connect();
// Finding whether it overlaps with some of existing orders
$check_availability = "SELECT guest_id, date_in, date_out, date_overlap(date_in, date_out, '{$date_in}', '{$date_out}') FROM orders WHERE bed_index={$bed_index} AND room_id={$room_id}";
$conn->run_query($check_availability);
$order_info = new stdClass();
while ($line = $conn->fetch_array()) {
if ($line['date_overlap'] == 1) {
// avail = 0; does mean there exists at least on order
// which conflicts with the current order.
$order_info->avail = 0;
$order_info->date_in = $line['date_in'];
$order_info->date_out = $line['date_out'];
$guest_id = $line['guest_id'];
$guest_query = "SELECT * FROM guests WHERE id = '{$guest_id}'";
$conn->run_query($guest_query);
if ($conn->affected_rows() == 1) {
function putRoomsToDatabase(&$arr, $rcount)
{
$path_to_hostconfig = $_SERVER['DOCUMENT_ROOT'] . "/php/hostconfig.php";
include_once $path_to_hostconfig;
$path_to_cdbconn = $_SERVER["DOCUMENT_ROOT"] . "/php/CDBConn.php";
include_once $path_to_cdbconn;
$my_conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", FALSE);
$my_conn->connect();
for ($i = 1; $i <= $rcount; $i++) {
$nazv = "nazv" . $i;
$room_info[$i] .= "<br><br>Room name: " . $arr[$nazv];
$type_id = "type" . $i;
$q_select = "SELECT room_type_name FROM room_type WHERE room_type_id = '" . $arr[$type_id] . "'";
$my_conn->run_query($q_select);
$line = pg_fetch_array($my_conn->getResult());
$type_name = "type_name" . $i;
$arr[$type_name] = $line[0];
$room_info[$i] .= "<br><br>Category of room: " . $arr[$type_name];
$capacity = "capacity" . $i;
$room_info[$i] .= "<br><br>Capacity of the room: " . $arr[$capacity];
//$q_insert = "INSERT INTO room (room_name, room_type_id, bed_count) VALUES('".$arr[$nazv]."',".$arr[$type_id].",".$arr[$capacity].")";
//$my_conn->run_insert($q_insert);
}
$my_conn->close();
return $room_info;
}
