Big project, need help designing the system

[Karatancheva]

Right, for a college project I have quite a complex problem I need to solve.

Problem: Create an online lesson booker.

What makes this hard? The college uses a two-weekly timetable, with college holidays not being counted as weeks.

Lessons take place in a room, at a given period on a given day in either week 1 or 2. The system must allow users to book rooms around these dates.

I was wondering how to go around designing this, I thought:

• Determine the day of the current week we are on - the admin will specify the particular week (either 1 or 2.)
• the system will (temporary hold) each week (somehow loop 7 days to do this?) show each week and its number (1 or 2) for a given period (say a year)
• the admin will select which weeks are holiday, thus telling the system which weeks to 'ignore' when assinging week numbers.
• when this is complete, roll of the list, assigning a particular day to a given week based upon the above table . when a booking is made / viewed etc it can be made in relation to the day which is stored with a reference to the week number.

Ok sorry this is jumbled, I'm finding it difficult to explain all this!

Does anyone have any ideas on how I should approach this, work on my "plan" above, or have any thoughts / comments, I'll greatly appreciate it.

Many thanks in advance.

[batman]

basically have the page they put in the info post to another .php where you will set up something more advanced than this little example:

//make a field in your database which sets room status to 1 or something when it is being used

<?
$room = $_POST['room'];
$date = $_POST['date'];
if($date == "")
{
$date = date();
}
$var1 = "whatever info"; //and so on with other variables

$sql = mysql_query("SELECT * FROM table WHERE week='$date' and room='$room'"); //This will get all info from table for either the slected date of the current date, depending on which is set
while($row = mysql_fetch_array($sql)){
	foreach( $row AS $key => $val ){
		$$key = stripslashes( $val );
	}
        $status = $row["status"];
	$room = $row["room"];
	$var1 = $row["var1l"];
	$var2 = $row["var2"];
	$var3 = $row["var3"];
	}
if($status == '1')
{
echo "Im sorry but this room is already being used for that day";
include("previouspage.php");
exit();
}
else
{
$sql = mysql_query("UPDATE table //set variables");
}
if(!sql)
{
echo "Im sorry there was an error updating your request!";
}
else
{
echo "congragulations, you are approved to use $room on $date";
}

But that that is really rough, dont try to use it as is.....😃 good luck!!!!

[harmor]

Hey batman,

edit your code and change
if($date = "")

To
if($date == "")

You forgot the second equal sign.

[batman]

lol, my bad. but i did also put

But that that is really rough

😃 Im sure in all reality there would be a ton of mistakes in that code compared to what he wants to use exactly....why did you not catch this one too: if($status = '1') ??? 😛 lol jk

[Karatancheva]

Thanks for the replies - I've now solved the problem and my system now works perfectly. 🙂