Hi guys,
I'm a bit of a newbie to PHP/MySQL, so please excuse me if I seem ignorant of something seemingly obvious. I'm writing a booking system for a holiday home rental company. I'm building it up slowly. What I have so far is trying to calculate the number of nights that a person will stay based on the date that they arrive and depart.
This is what I have so far: -
<html>
<head><title>Booking Form</title></head>
<body>
<form action="calculate.php" method="post">
Date of arrival: <input type="text" name="arrival">
Date of departure: <input type="text" name="departure">
<input type="Submit" value="Submit"><input type="Reset" value="Reset">
</form>
</body>
</html>The code above is for the user to insert the dates of arrival and departure.
<?php
// Connects to your Database
mysql_connect("localhost", "", "") or die(mysql_error());
mysql_select_db("dissertation") or die(mysql_error());
$sql="SELECT datediff('$departure','$arrival')" or die(mysql_error());
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$insert = "INSERT INTO booking (arrival, nights, departure)
VALUES ('".$_POST['arrival']."', '$result', '".$_POST['departure']."')";
$holiday = mysql_query($insert);
?>Using the code above, I want to work out the number of nights a person is staying for, and enter that with the dates of arrival and departure into the database. Currently, when I run the code, I get 'Resource id #3' in the 'nights' column of the table. Doing a search on Google would imply that I'm missing something, but i can't see what.
Below is the code for my table. The reason for such a big 'nights' column is so I can see the full error that I'm getting currently.
create table booking (
id INT primary key auto_increment,
arrival date NOT NULL,
nights varchar(100) NOT NULL,
departure date NOT NULL
);Thanks in advance for any tips! :)