<?php
require "authentication.inc";
require "db.inc";

session_start();
session_authenticate();

$connection = db_connect();

$query = "select * from car_booking, users where ".
"user_id=users.id and car_booking.id=$_GET[bid];";
$result = db_query($query, $connection);
$row = mysql_fetch_array($result);

$query = "select * from car_booking where car_id = $_GET[roomid] ".
"and start < '$row[end]' and end > '$row[start]';";
$result = db_query($query, $connection);
if (mysql_num_rows($result) > 0) {
    $_SESSION[errorMessage] = "There is an overlap. Booking not possible";
    header("Location: error.php");
    exit;
}

$query = "update car_booking set car_id=$_GET[carid] where id=$_GET[bid];";
db_query($query, $connection);

header("Location: car_booking.php");

include("header.php.inc");
?>


<?php
include("footer.php.inc");
?>