showing the change between original timetable n proposed timetable

[chaos]

HELLO !!!
i doing timetable system using php. i now stuck in part whereby showing the
change between Original TimeTable and Proposed TimeTable in chart so that the user will know the change he has make.

[Purple]

Hi chaos and welcome to TSDN !

I am not sure I totally understand your question but how about highlighting the changes using a different colour ?

Purple

[pbmods]

Changed thread title: removed superfluous '???' that might actually have resulted in *fewer* responses.

[chaos]

Hi chaos and welcome to TSDN !

I am not sure I totally understand your question but how about highlighting the changes using a different colour ?

Purple

My qn is how to show the original time slot and also show the proposed time slot
in the the timetable chart using php. wt do i need to do ?
As this is timetable system to let staff n other to arrange their timetable.

[Purple]

Hi Chaos,

I find it difficult to make any suggestion with so little to go on - I understand your headline requirement, have you go the code which generates the current timetable ? Is the timetabling data held within a database ?

Regards Purple

[pbmods]

Heya Chaos.

Let me see if I understand what you're trying to accomplish. You want to display a set of time blocks for a particular date, and you want a User to be able to select one of them. You want to display all the time blocks that are already taken, as well as the time block that the User wants to reserve.

Is this correct?

[chaos]

Hi Chaos,

I find it difficult to make any suggestion with so little to go on - I understand your headline requirement, have you go the code which generates the current timetable ? Is the timetabling data held within a database ?

Regards Purple

Yes , the timetabling data is held within a database
wt code need to do in order u see my old time slot in the timetable highlighted n see the new time slot .

[chaos]

Heya Chaos.

Let me see if I understand what you're trying to accomplish. You want to display a set of time blocks for a particular date, and you want a User to be able to select one of them. You want to display all the time blocks that are already taken, as well as the time block that the User wants to reserve.

Is this correct?

Something similar but i want to show the user wt changes he has make in the timetable such as showing the old time slot n new time slot

[chaos]

Someone Pls Help Me!

[MMcCarthy]

Someone Pls Help Me!

chaos

Please use full and clear english when posting in this forum. Using abreviated text means the experts have to take the time to interpret what you are trying to say. It can be difficult enough trying to discuss technical problems this way as it is.

ADMIN

[pbmods]

Heya, Chaos.

Alright. So you're saying that you want the User to be presented with the time slot he had previously as well as the new timeslot that he wants. Is this correct?

Easiest way to do this is to store both time slots in $_SESSION when the User picks a new timeslot, then output them on the next page to let the User confirm his selection.

[chaos]

Heya, Chaos.

Alright. So you're saying that you want the User to be presented with the time slot he had previously as well as the new timeslot that he wants. Is this correct?

Easiest way to do this is to store both time slots in $_SESSION when the User picks a new timeslot, then output them on the next page to let the User confirm his selection.

Yes pbmods.The old time slot and new time slot will show in the timetable chart when the user view their own timetable.

[pbmods]

Heya, Chaos.

Alrightey. If the User's proposed time slot isn't stored in the database, you'll most likely want to store that information in the User's session.

Which part are you having trouble with? What is your script doing? What is it supposed to do? Do you have a screenshot or a link you can post?

[chaos]

Heya, Chaos.

Alrightey. If the User's proposed time slot isn't stored in the database, you'll most likely want to store that information in the User's session.

Which part are you having trouble with? What is your script doing? What is it supposed to do? Do you have a screenshot or a link you can post?

I doing a online timetable system whereby user change their own time slot.
wt are the code in order to show the old time slot n new time slot in the timetable (img1)

This is the area where user proposed the time slot (img2)

[pbmods]

Heya, chaos.

Let's look at some code. Where do you display the timetable data? Or are those images comps?

[chaos]

this is e coding for viewing the timetable record

<?php session_start(); ?>
<?php require_once('Connections/conn.php'); ?>
<?php
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
$ht =90;

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;

// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "index.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
mysql_select_db($database_conn, $conn);
$query_Recordset1 = "SELECT venue FROM facilities";
$Recordset1 = mysql_query($query_Recordset1, $conn) or die(mysql_error());
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
$colname_staff_rs = "1";

if (isset($_SESSION['MM_Username'])) {
$colname_staff_rs = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}

mysql_select_db($database_conn, $conn);

if(!isset($_GET['viewByStudent']) && !isset($_GET['viewByFacility']))
$query = sprintf("SELECT * FROM staff WHERE staff_1 = '%s'", $colname_staff_rs);
elseif(isset($_GET['viewByStudent']))
$query = sprintf("SELECT * FROM students WHERE group_1= '%s'", $_GET['viewByStudent']);
elseif(isset($_GET['viewByFacility']))
$query = sprintf("SELECT * FROM facilities WHERE venue = '%s'", $_GET['viewByFacility']);

$rs = mysql_query($query, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
$totalRows_rs = mysql_num_rows($rs);

mysql_select_db($database_conn, $conn);
$query_student_rs = "SELECT * FROM students";
$student_rs = mysql_query($query_student_rs, $conn) or die(mysql_error());
$row_student_rs = mysql_fetch_assoc($student_rs);
$totalRows_student_rs = mysql_num_rows($student_rs);

mysql_select_db($database_conn, $conn);
$query_facilities_rs = "SELECT venue FROM facilities";
$facilities_rs = mysql_query($query_facilities_rs, $conn) or die(mysql_error());
$row_facilities_rs = mysql_fetch_assoc($facilities_rs);
$totalRows_facilities_rs = mysql_num_rows($facilities_rs);

mysql_select_db($database_conn, $conn);
$query_userid_rs = "SELECT user_id FROM user_profile";
$userid_rs = mysql_query($query_userid_rs, $conn) or die(mysql_error());
$row_userid_rs = mysql_fetch_assoc($userid_rs);
$totalRows_userid_rs = mysql_num_rows($userid_rs);

mysql_select_db($database_conn, $conn);
$query_Temp_RS = "SELECT * FROM modules WHERE moduleID = 1";
$Temp_RS = mysql_query($query_Temp_RS, $conn) or die(mysql_error());
$row_Temp_RS = mysql_fetch_assoc($Temp_RS);
$totalRows_Temp_RS = mysql_num_rows($Temp_RS);

$colname_RetrieveStaff = "1";
if (isset($_SESSION['MM_Username'])) {
$colname_RetrieveStaff = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_conn, $conn);
$query_RetrieveStaff = sprintf("SELECT * FROM staff WHERE staff_1 = '%s'", $colname_RetrieveStaff);
$RetrieveStaff = mysql_query($query_RetrieveStaff, $conn) or die(mysql_error());
$totalRows_RetrieveStaff = mysql_num_rows($RetrieveStaff);
?>

<input type=hidden <?php echo $_SESSION['MM_Username'];?>>

<?php
$colname_username = "1";
if (isset($_SESSION['MM_Username'])) {
$colname_username = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_conn, $conn);
$query_username = sprintf("SELECT full_name FROM user_profile WHERE user_id = '%s'", $colname_username);

$username = mysql_query($query_username, $conn) or die(mysql_error());
$row_username = mysql_fetch_assoc($username);
$totalRows_username = mysql_num_rows($username);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<?php
function student()
{
?>
<table width="750" height="300" border="1">
<tr>
<?php
for ($i = 0; $i<55; $i++)
{
if ($i >0 && $i%10 == 0)
{
echo "</tr><tr>";
}
?>
<td width="75" height="46">
<div align="center" class="style9">
<?php
if($row_student_rs["_".$i]==0)
echo "&nbsp;";

if($row_student_rs["_".$i]=='BLOCK')
echo "Block";
else
{
$query_Temp_RSS = "SELECT * FROM students WHERE group1 = ".$s;
$Temp_RSS = mysql_query($query_Temp_RSS, $conn) or die(mysql_error());
$row_Temp_RSS = mysql_fetch_assoc($Temp_RSS);
echo $row_Temp_RSS['group_1'];
}
echo "</td>";
}
?>
</tr>
</table>
<?php
}
?>
<title>QUALTY MANAGEMENT SYSTEM</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {
font-size: 12px;
font-weight: bold;
}
.style7 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; color: #9F7800; }
.style8 {
font-size: 24px;
font-weight: bold;
}

#Display {
float: left;
width: auto;
}
#Day {
float: left;
width: 30px;
font-size: 9px;
}
.style9 {
color: #000000;
font-weight: bold;
}
-->
</style>
</head>

<body>
<table width="1000" border="0" align="center">
<tr>
<td width="178" height="80" background="image_add_staff/add_staff_r1_c1.gif">&nbsp; </td>
<td width="812" background="image_add_staff/add_staff_r1_c3.gif"><span class="bannertitle">Timetable Management System</span></td>
</tr>
<tr>
<td height="114" colspan="2"><table width="978" border="0">
<tr>
<td colspan="5"><span class="style2">View By </span></td>
</tr>
<tr>
<td width="47" height="50"><p><strong>Student:</strong></p></td>
<td width="196" height="50" valign="baseline">
<form name="stud" action="view_records.php" method="get">
<select name="viewByStudent" id="viewByStudent">
<?php
mysql_select_db($database_conn, $conn);
$sql = mysql_query("SELECT group_1 FROM students");
while($row = mysql_fetch_array($sql))
{
?>
<option name>
<?php echo $row['group_1'];
?>
</option>
<?php
}
?>
</select>
<input name="stud" type="submit" value="Student">
</form>
</td>
<td width="49" height="50"><strong>Facility:</strong></td>
<td width="197" height="50" valign="baseline">
<form name="venue" action="view_records.php" method="get">
<select name="viewByFacility" id="viewByFacility">
<?php while($row_Recordset1 = mysql_fetch_array($Recordset1))
{
?>
<option><?php echo $row_Recordset1['venue']; ?></option>
<?php }
?>
</select>
<input name="venue" type="submit" value="Facilities">
</form> </td>
<td width="467" height="50"><p><img src="image_add_staff/edit copy.jpg"></p>
</td>
</tr>
<tr>
<td height="31" colspan="5"><hr noshade>
<span class="style8">
<?php
if (isset($_GET['viewByStudent']))
{
echo $_GET['viewByStudent'];
$mode = "stud";
}
elseif (isset($_GET['viewByFacility']))
{
echo $_GET['viewByFacility'];
$mode = "fac";
}
else
{
echo $row_username['full_name'];
$mode = "staff";
}
?> TimeTable
</span> <hr noshade></td>
</tr>
</table> </td>
</tr>
<tr>
<td><table width="154" height="99" border="0" align="center">
<tr>
<td width="158" height="88" valign="top" background="image_add_staff/add_staff2.jpg">&nbsp;</td>
</tr>
</table>
<p>
</p>
<?php
$access_type = $_SESSION['MM_UserGroup'];
?>
<table width="121" height="132" border="0" align="center">
<tr>
<td><span class="style7">
Hi
<?php echo $row_username['full_name']; ?> </span></td>
</tr>
<tr>
<td>
<?php if(isset($_SESSION['MM_Username']))
{
?>
<a href="main.php"><strong>&gt;Home</strong></a>
<?php
}
?>
</td>
</tr>
<tr>
<td>
<?php if(isset($_SESSION['MM_Username']))
{
?>
<a href="view_records.php"><strong>&gt;My Timetable</strong></a>
<?php
}
?>
</td>
</tr>
<tr>
<td>
<?php if(isset($_SESSION['MM_Username']))
{
?>
<a href="user/edit_profile.php"><strong>&gt;Edit Profile </strong></a>
<?php
}
?></td>
</tr>
<tr>
<td align="left">
<?php if ($access_type == "Admin")
{
?>
<a href="admin/view_staff_record.php"><strong>&gt;Staff Record </strong></a>
<?php
}
?>
</td>
</tr>
<tr>
<td>
<?php if ($access_type == "Staff" || $access_type == "super_user")
{
?>
<a href="user/feedback.php">&gt;Feedback</a>
<?php
}
?>
</td>
</tr>
<tr>
<td>
<?php if(isset($_SESSION['MM_Username']))
{
?>
<a href="logout.php"><strong>&gt;Logout</strong></a>
<?php
}
?></td>
</tr>
</table>
<p>&nbsp;</p></td>
<td background="images/main30.gif"><div id="Time">
<table border="1" align="center">
<tr align="center">
<td width="77"><p>&nbsp;</p></td>
<td width="70"><p><strong>0800-0900</strong></p></td>
<td width="70"><p><strong>0900-0950</strong></p></td>
<td width="70"><p><strong>1010-1100</strong></p></td>
<td width="70"><p><strong>1110-1200</strong></p></td>
<td width="70"><p><strong>1205-1300</strong></p></td>
<td width="70"><p><strong>1300-1350</strong></p></td>
<td width="70"><p><strong>1400-1450</strong></p></td>
<td width="70"><p><strong>1510-1600</strong></p></td>
<td width="70"><p><strong>1610-1700</strong></p></td>
<td width="70"><p><strong>1710-1800</strong></p></td>
</tr>
</table>
</div>

<div id="Content">
<div id="Day">
<div align="left">
<table width="77" border="1">
<tr height="90">
<td align="center"><strong>Monday</strong></td>
</tr>
<tr height="90">
<td align="center"><strong>Tuesday</strong></td>
</tr>
<tr height="90">
<td align="center"><strong>Wednesday </strong></td>
</tr>
<tr height="90">
<td align="center"><strong>Thursday </strong></td>
</tr>
<tr height="90">
<td align="center"><strong>Friday</strong></td>
</tr>
<tr height="90">
<td align="center"><strong>Saturday </strong></td>
</tr>
</table>
</div>
</div>
<div id="Display">
<div align="left">
<table border="1">
<tr height="90">
<?php
for ($i = 0; $i<55; $i++)
{
if ($i >0 && $i%10 == 0)
{
?>
</tr><tr height="90">
<?php
}
?>

<td align="center" width="70"
<?php if($totalRows_rs>0) { ?>
<?php

$xx =$row_rs["_".$i];
switch ($xx)
{
case '0':
echo ">&nbsp;";
break;

case 'BLOCK':

echo " bgcolor=666666 >&nbsp;";
break;

default:

$query_Temp_RS = "SELECT * FROM modules WHERE moduleID = ".$row_rs["_".$i];
$Temp_RS = mysql_query($query_Temp_RS, $conn) or die(mysql_error());
$row_Temp_RS = mysql_fetch_assoc($Temp_RS);
$num_Temp_RS=mysql_num_rows($Temp_RS);

$query_RS_student = "SELECT group_1 FROM students WHERE _".$i." = ".$row_rs["_".$i];
$RS_student = mysql_query($query_RS_student, $conn) or die(mysql_error());
$num_student=mysql_num_rows($RS_student);

$query_RS_facilities = "SELECT venue FROM facilities WHERE _".$i." = ".$row_rs["_".$i];
$RS_facilities = mysql_query($query_RS_facilities, $conn) or die(mysql_error());
$num_facilities=mysql_num_rows($RS_facilities);

$query_RS_staff = "SELECT staff_1 FROM staff WHERE _".$i." = ".$row_rs["_".$i];
$RS_staff = mysql_query($query_RS_staff, $conn) or die(mysql_error());
$num_staff=mysql_num_rows($RS_staff);

echo " bgcolor = #EEEEEE >";

//Display Module Group
echo $row_Temp_RS['module']."-";
echo $row_Temp_RS['module_type'];
echo $row_Temp_RS['module_group'];
echo "<BR>";
echo $row_Temp_RS['module_abbr'];

//Display Student
if ($row_Temp_RS['module_type'] <> "L" and $mode <> "stud")
{
while ($row_RS_student= mysql_fetch_assoc($RS_student))
{
echo "<BR>";
echo $row_RS_student['group_1'];
}
}
//Display Facility ID
while ($row_RS_facilities= mysql_fetch_assoc($RS_facilities) and $mode <>"fac")
{
echo "<BR>";
$venue=$row_RS_facilities['venue'];
echo $row_RS_facilities['venue'];
}
// Display Staff ID
while ($row_RS_staff= mysql_fetch_assoc($RS_staff) and $mode <> "staff")
{
echo "<BR>";
$staff=$row_RS_staff['staff_1'];
echo $row_RS_staff['staff_1'];
}

if($i<=9)
$day="Monday";
elseif($i<=19)
$day="Tuesday";
elseif($i<=29)
$day="Wednesday";
elseif($i<=39)
$day="Thursday";
elseif($i<=49)
$day="Friday";
elseif($i<=54)
$day="Saturday";

if($i<10)
$time=$i;
else
$time=substr($i,1,1);
echo "<br>";

//Enable Change link for staff view only
if ($mode == "staff")
{
?>
<a href="timetable/timetable.php?
<?php echo "day=$day&&time=$time&&hr=".$row_Temp_RS['hr'].
"&&type=". $row_Temp_RS['module_type'].
"&&venue=$venue".
"&&modCode=".$row_Temp_RS['module'].
"&&modAbbr=".$row_Temp_RS['module_abbr'].
"&&modGrp=".$row_Temp_RS['module_group'].
"&&orgSlot=$i";
?>
">Change</a>
<?php
}
}
echo "</td>";
}
?>
</div>
<?php
}
?>
</tr>
</table>
</div>
</div>
<tr>
<td background="image_add_staff/add_staff_r7_c1.gif" height="30" colspan="2"></td>
</tr>
</table>

</body>
</html>
<?php
mysql_free_result($rs);

mysql_free_result($student_rs);

mysql_free_result($facilities_rs);

mysql_free_result($userid_rs);

mysql_free_result($Temp_RS);

mysql_free_result($RetrieveStaff);

mysql_free_result($username);
?>

[chaos]

Heya, chaos.

Let's look at some code. Where do you display the timetable data? Or are those images comps?

the code i given is to display the timetable which u see in (img1)

[kovik]

You've given far too much code.The majority of that does nothing in relation to the table itself.

You have to save both the old time table and the new time table in the database. That is the *ONLY* way to do it and be able to show the user the previous time table as well. How are your time tables stored in the database? You may need to change your storage method.