im trying to build an scheduling module, then my problem is ders a lot of drop down list
ex.(imagine this is an dropdown list)
[subject name] [time] [day] [room]
english 7:00-8:00am tuesday 401
math 7:00-8:00am tuesday 401 (supposedly it was 402, same time but not same room)
please help me to avoid the redunduncy in dropdown list in same form :(
15 replies to this topic
#1
Posted 08 September 2011 - 08:15 AM
|
|
|
#2
Posted 08 September 2011 - 08:26 AM
mmm how are you building your dropdown? Php & mysql, javascript, random?...
#3
Posted 08 September 2011 - 08:31 AM
hmm.. php and mysql sir. please help me. is it java scirpt? can you give me a sample sir?
#4
Posted 08 September 2011 - 08:32 AM
Can you provide us with your php & mysql code
#5
Posted 08 September 2011 - 08:36 AM
this is my code in drop down.. i need a code that avoids redunduncy in a form
<?php
require_once('auth.php');
?>
<html>
<form method="post" action="insert.php">
<body bgcolor="black" background="nu3.png"> <br><a href="faculty.php"><img src="select.png" height="25"></a><br><br>
<a href="logout.php"><img src="logout.png" height="19"></a>
<br><br> <br>
<table border="2" align="center" cellpadding="2" cellspacing="1" >
<tr>
<td><center><font color="white" face="Arial black" size="2"><b>Name</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Classification</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Subject</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Time</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Day</b></font></center></td>
<td><center><font color="white" face="Arial black"size="2"><b>Room</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Section</b></font></center></td>
</tr>
<tr>
<td><font color="white" face="verdana" size="2"> <strong>Subion, Marco T.</b> </font>
</td><td><Select name="Class1">
<option>
<option>Full Time
<option>Part Time</select>
</td>
<td><Select name="sub1">
<option>
<option>Math
<option>Science
<option>Filipino
<option>English
<option>Quacons</select>
</td><td><Select name="t1">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d1">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r1">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s1">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td></tr><tr><td></td><td></td>
<td><Select name="sub2" >
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t2">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d2">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r2">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s2">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
<tr><td></td><td></td>
<td><Select name="sub3" >
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t3">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d3">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r3">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s3">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select><tr><td></td><td></td>
<td><Select name="sub4">
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t4">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d4">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r4">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s4">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td></tr>
<tr><td></td><td></td>
<td><Select name="sub5">
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t5">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d5">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r5">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s5">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td>
</tr>
</table><br><br>
<center><input type="submit" name="Submit"><input type="reset" name="Reset"></center>
</body>
</html>
<?php
require_once('auth.php');
?>
<html>
<form method="post" action="insert.php">
<body bgcolor="black" background="nu3.png"> <br><a href="faculty.php"><img src="select.png" height="25"></a><br><br>
<a href="logout.php"><img src="logout.png" height="19"></a>
<br><br> <br>
<table border="2" align="center" cellpadding="2" cellspacing="1" >
<tr>
<td><center><font color="white" face="Arial black" size="2"><b>Name</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Classification</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Subject</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Time</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Day</b></font></center></td>
<td><center><font color="white" face="Arial black"size="2"><b>Room</b></font></center></td>
<td><center><font color="white" face="Arial black" size="2"><b>Section</b></font></center></td>
</tr>
<tr>
<td><font color="white" face="verdana" size="2"> <strong>Subion, Marco T.</b> </font>
</td><td><Select name="Class1">
<option>
<option>Full Time
<option>Part Time</select>
</td>
<td><Select name="sub1">
<option>
<option>Math
<option>Science
<option>Filipino
<option>English
<option>Quacons</select>
</td><td><Select name="t1">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d1">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r1">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s1">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td></tr><tr><td></td><td></td>
<td><Select name="sub2" >
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t2">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d2">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r2">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s2">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
<tr><td></td><td></td>
<td><Select name="sub3" >
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t3">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d3">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r3">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s3">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select><tr><td></td><td></td>
<td><Select name="sub4">
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t4">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d4">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r4">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s4">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td></tr>
<tr><td></td><td></td>
<td><Select name="sub5">
<option>
<option>Math
<option>Science
<option>FIlipino
<option>English
<option>Quacons</select>
</td><td><Select name="t5">
<option>
<option>1:00 - 2:00 pm
<option>2:00 - 3:00 pm
<option>3:00 - 4:00 pm
<option>4:00 - 5:00 pm
<option>5:00 - 6:00 pm</select>
</td>
<td><Select name="d5">
<option>
<option>Monday
<option>Tuesday
<option>Wednesday
<option>Thursday
<option>Friday
<option>Saturday</select>
</td><td><Select name="r5">
<option>
<option>401
<option>402
<option>403
<option>404
<option>405</select>
</td><td><Select name="s5">
<option>
<option>INF-101
<option>Com-091
<option>INF-102
<option>INF-103
<option>INF-104</select>
</td>
</tr>
</table><br><br>
<center><input type="submit" name="Submit"><input type="reset" name="Reset"></center>
</body>
</html>
#6
Posted 08 September 2011 - 08:42 AM
The user have multiple select in the same form, and you want to remove the redunduncy of the time between each of them?
I thought it was remove redunduncy against other data from a databases (other student or whatever)
I thought it was remove redunduncy against other data from a databases (other student or whatever)
#7
Posted 08 September 2011 - 08:57 AM
[ATTACH=CONFIG]4226[/ATTACH] sir this is my problem
#8
Posted 08 September 2011 - 08:58 AM
Sorry the attachment is invalid
#9
Posted 08 September 2011 - 08:59 AM
[ATTACH=CONFIG]4227[/ATTACH]
#10
Posted 08 September 2011 - 09:02 AM
Same, try hosting it somewhere else
#11
Posted 08 September 2011 - 09:13 AM

Uploaded with ImageShack.us
ImageShack® - Online Photo and Video Hosting
---------- Post added at 01:13 AM ---------- Previous post was at 01:10 AM ----------
ImageShack® - Online Photo and Video Hosting
#12
Posted 08 September 2011 - 09:24 AM
OK I see it,
You will have to compare each value to each value
You will have to compare the first select with the seconde, the third, the fourth and the fifth
Than the second with third, fourth, fifth
Than third with fourth, fifh
than fourth and fifth
You will have to compare each value to each value
if ((document.getElementById('FirstDayId').options[document.getElementById('FirstDayId').selectedIndex].text == document.getElementById('SecondDayId').options[document.getElementById('SecondDayId').selectedIndex].text &&
document.getElementById('FirstTimeId').options[document.getElementById('FirstTimeId').selectedIndex].text == document.getElementById('SecondTimeId').options[document.getElementById('SecondTimeId').selectedIndex].text
) || document. .....)
{
alert('same data!');
}
You will have to compare the first select with the seconde, the third, the fourth and the fifth
Than the second with third, fourth, fifth
Than third with fourth, fifh
than fourth and fifth
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users


Sign In
Create Account


Back to top









