Hi guys,
I just joined this list today, and I'm already seeking for
advice :)
So,
I'm working on a project for my university. The project
consists in a web interface (php) and a mysql database.
The purpose of this project is to let teachers make room
reservations for specific classes at specific times.
I have been working with C and some other programming
languages before, and found php to be similar, although I
still have some small things to clarify here and there.
At the present moment, I have already implemented the most
part of this project, but I got stuck with the error
handling. (Most likely because I do not know a lot about
php -> mysql connectivity)
I need to make a check at the time the user submits a new
entry, that the new entry won't overlap timewise with other
entries already in the database.
The only thing that needs to be checked is the time, in a
certain day/month/year. (Reservations cannot be carried
over to a different day).
Here's how my "selected" table looks like:
$tables = "CREATE TABLE selected (
id int(3) ZEROFILL unsigned auto_increment NOT NULL,
month tinyint(3) unsigned NOT NULL DEFAULT '0',
date tinyint(3) unsigned NOT NULL DEFAULT '0',
year smallint(4) unsigned NOT NULL DEFAULT '0',
time_start smallint(4) unsigned NOT NULL DEFAULT '0',
time_end smallint(4) unsigned NOT NULL DEFAULT '0',
class tinytext,
special_request blob,
PRIMARY KEY (id),
UNIQUE id (id),
INDEX id_2 (id)
)";
And below is a piece of code with my attempts to do the
check. (mysql does not like it, so I'm assuming it's not
correct).
-------BEGIN-------
<?php
if($submit) {
if(!$db = mysql_connect("xxxx", "xxxx", "lxxxx"))
die("<font color=\"#FF0000\">Error, I could not
connect to the database at $dbserver. Using username
$dbuser and password $dbpass.<BR>Please go back and try
again.");
$x = mysql_select_db("lcdb", $db);
flush();
$sql="Select * FROM selected WHERE
(( start_time < $start_time) && ( end_time < $end_time ) &&
( start_time < $end_time ) && ( end_time < $start_time )) ||
(( start_time > $start_time) && ( end_time > $end_time ) &&
( start_time > $end_time ) && ( end_time > $start_time ))";
$r = mysql_query($sql, $db);
if ($row = mysql_num_rows($r))
{
$sql = "INSERT INTO selected (time_start, time_end, date,
month, year, class, special_request) VALUES
('$start_time', '$end_time', '$day', '$month', '$year','$cla
ss','$special_needs')";
if(!mysql_query($sql, $db)) {
echo $sql . " : " . mysql_error() . "<br>";
die("$!");
}
echo "<br><TABLE BORDER=\"0\" CELLPADDING=\"1\"
CELLSPACEING=\"0\" ALIGN=\"CENTER\" VALIGN=\"TOP\"
WIDTH=\"100%\">";
echo "<TR><TD BGCOLOR=\"$table_bgcolor\"><TABLE
BORDER=\"0\" CALLPADDING=\"1\" CELLSPACEING=\"1\"
WIDTH=\"100%\">";
echo "<TR BGCOLOR=\"FFFFFF\" ALIGN=\"LEFT\"><TD><font
face=\"Verdana\" size=\"2\"><P>";
echo "<P><BR><center>Your Reservation has been
made.<P>Click here to go back to the listing.</a></font>";
echo "</TD></TR></TABLE></TD></TR></TABLE><br>";
}
else
die("Error!");
} else {
---------END--------
So... If any of you could help me out, I would GREATLY
appreciate it.
Thanks in advance,
Ion
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
