require_once('../private/sql2.php') ;
$cottage=mysqli_real_escape_string($link, $_GET['cottage']);
$usertable = "users" ;
$query = "SELECT * from $usertable WHERE username ='$cottage' LIMIT 1" ;
$result = mysqli_query( $link, $query );
$rows=mysqli_num_rows($result);
$c=0;
while ($row = mysqli_fetch_array($result))
{
include ('vars.php');
foreach($row as $var => $value) { $$var = $value; }
foreach($row as $var => $value) { ${"cottage_".$var} = $value; }
}
IF ($var11=="yes") { $sleeping .= " - wheelchair access "; }
$title = "$var101 - Sleeps $cottage_Sleeps";
$title .= " - Chilton Farm, Isle of Wight";
$metadesc = "Self catering ";
IF ($cottage_user_type=="u") {
IF ($cottage_floors==1) { $metadesc .= "bungalow "; }
IF ($cottage_floors==2) { $metadesc .= "cottage"; }
}
ELSEIF ($cottage_user_type=="c") {
IF ($cottage_floors==1) { $metadesc .= "two bungalows"; }
IF ($cottage_floors==2) { $metadesc .= "bungalow and cottage"; }
}
$metadesc .= " at Chilton Farm, Brighstone, Isle of Wight. $var52 $var52b Sleeps $cottage_Sleeps";
$metakey = "self catering, isle of wight, Chilton Farm"; IF ($var52) {$metakey .=", $var52, $var52b"; } $metakey .=", $cottage_Sleeps";
include ('topcode.php') ;
?>
$pagelinks = "stay";
for ($i=1; $i<2; $i++) {
IF (${"picture".$i} ) {
$slide = "/images/".${"picture".$i};
}
}
include('header.php') ;
// include('bookingform.php');
echo "
";
IF ($cottage_bedrooms==1) {$s = ""; } ELSE {$s = "s"; }
echo "

$cottage_bedrooms bedroom$s
";
IF ($cottage_dogs==1) { echo "

Dogs welcome
"; }
IF ($cottage_balcony==1) { echo "

Balcony
"; }
IF ($cottage_wifi==1) { echo "

Wi-fi
"; }
IF ($cottage_Sleeps>0) { echo "

Sleeps $cottage_Sleeps
"; }
IF ($cottage_bathroom!="") { echo "

$cottage_bathroom bathrooms
"; }
IF ($cottage_playarea==1) { echo "

Children's play area
"; }
echo "
$cottage_contact_name
$var9
";
IF ($var58) {echo "
Floorplan
";}
echo "
Availability
";
$uname="$cottage";
$beginon = "$var59" ;
include('includes2/startup.php') ;
echo "
Self catering tariff
";
IF ($cottage=="bb") {
echo "Prices are per night. There is no minimum period.
";
}
ELSE {
echo "Short breaks are available outside of school holidays.
";
}
echo "
weeks commencing from $var59...
|
|
" ;
$usertable = "tariff" ;
$epoch = date("U");
$chosen_start_day = date("U",mktime(23, 59, 59, $todaymonthn, $day, $year)); // seconds since epoch
// $usertable = "tariff" ;
//////SEVEN NIGHTS
$query = "SELECT * from $usertable WHERE numberofnights='7' ORDER BY year ASC, month ASC, day ASC, yearto ASC,monthto ASC, dayto ASC " ;
$result = mysqli_query( $link, $query );
$rows1=mysqli_num_rows($result);
while ($row = mysqli_fetch_array($result))
{
$prices=$row["$cottage"];
// IF ($cottage == "west") { $prices = $row["ash"] + $row["willow"] ; }
// ELSEIF ($cottage == "east") { $prices = $row["oak"] + $row["lacewood"] ; }
// ELSE
// { }
// $prices=$row["Clematis"];
// IF ($var59=="Friday") { include('varstariffsat.php') ; } ELSE { }
include('varstariff.php') ;
if ( ($c / 2) - (intval($c/2)) == 0 )
{$colour = "creamtwo"; } ELSE {$colour = "creamone"; }
IF (date("U", mktime(0, 0, 0, $var32, $var31, $var33))>$epoch) {
echo "
| ".date("jS F Y", mktime(0, 0, 0, $var29, $var28, $var30))."
| to | ".date("jS F Y", mktime(0, 0, 0, $var32, $var31, $var33))."
|
£".number_format($prices)."
|
" ;
$c++ ;
}
} // end while 7 NIGHTS
echo "
";
/////////////////////ACCESS STATEMENT
IF ($access1) {
echo "
Access statement
Please click here to download our access statement.
";
}
echo "
";
//IF ( $picture2) {
echo "
";
for ($i=1; $i<21; $i++) {
IF (${"picture".$i} ) { echo "
";
} // if pic
} // end for
echo "
";
include ('footer.php') ; ?>