Can someone help me change to select box to modal

PHP
1 
<?php
	session_start();
	error_reporting(0);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
if($_SESSION['LoginStatus'] == TRUE)
{
	include("database.php");
	include("menu.php");
	if($_POST['btnAdd'])
	{
		for ($i = 0; $i < 11; $i++)
		{
			$AddT ="INSERT INTO tbltimetable(SubId,StaffId,locateId,classT) VALUES ()";
			$AddResult1 = mysql_query($AddT,$Link);
			if($AddResult1)
			{
				echo "<script> alert('New Time Table added successfully. Thank You');location =''</script>";	
			}	
			else 
			{
				echo "<script> alert(' Create Table Unsuccessfully.');location =''</script>";
			}
		}
	}
	else if($_POST['btnSearch'])
	{
?>
<form id="form1" name="form1" method="post" action="">
 <fieldset>
	  <legend>Add Time Table</legend>
	  <table width="200" border="1">
	  <tr>
		<td>Time</td>
		<td><p>07:30</p>
		<td><p>08:00</p>
		<td><p>08:30</p>
		<td><p>09:00</p>
		<td><p>09:30</p>
		<td><p>10:00</p>
		<td><p>10:30</p>
		<td><p>11:00</p>
		<td><p>12:30</p>
		<td><p>13:00</p>
		<td><p>13:30</p>
		
		</tr>
        <tr>
        <td>Monday</td>
        <?php
        	for ($i = 0; $i < 11; $i++)
			{
				if($i == 5)
			{
				echo "<td>".B."</td>";
			}
				else
				{
				$sql = mysql_query("SELECT * FROM tblsubject", $Link);
				$row = mysql_num_rows($sql);
				?>
				<td>
                	<select>
                    <option value=""></option>
                    <?php
                    	for ($j = 0; $j < $row; $j++)
						{
							$data = mysql_fetch_array($sql);
							echo "<option value='".$data['SubId']."'>".$data['SubName']."</option>";
						}
					?>
                    </select>
                </td>
                
			<?php }
			}
		?>
        </tr>
        
        <tr>
        <td>Tuesday</td>
        <?php
        	for ($i = 0; $i < 11; $i++)
			{
				if($i == 5)
			{
				echo "<td>".R."</td>";
			}
				else
				{
				$sql = mysql_query("SELECT * FROM tblsubject", $Link);
				$row = mysql_num_rows($sql);
				?>
				<td>
                	<select>
                    <option value=""></option>
                    <?php
                    	for ($j = 0; $j < $row; $j++)
						{
							$data = mysql_fetch_array($sql);
							echo "<option value='".$data['SubId']."'>".$data['SubName']."</option>";
						}
					?>
                    </select>
                </td>
			<?php }
			}
		?>
        </tr>
        <tr>
        <td>Wednesday</td>
        <?php
        	for ($i = 0; $i < 11; $i++)
			{
				if($i == 5)
			{
				echo "<td>".E."</td>";
			}
				else
				{
				$sql = mysql_query("SELECT * FROM tblsubject", $Link);
				$row = mysql_num_rows($sql);
				?>
				<td>
                	<select>
                    <option value=""></option>
                    <?php
                    	for ($j = 0; $j < $row; $j++)
						{
							$data = mysql_fetch_array($sql);
							echo "<option value='".$data['SubId']."'>".$data['SubName']."</option>";
						}
					?>
                    </select>
                </td>
			<?php }
			}
		?>
        </tr>
        <tr>
        <td>Thursday</td>
        <?php
        	for ($i = 0; $i < 11; $i++)
			{
				if($i == 5)
			{
				echo "<td>".A."</td>";
			}
				else
				{
				$sql = mysql_query("SELECT * FROM tblsubject", $Link);
				$row = mysql_num_rows($sql);
				?>
				<td>
                	<select>
                    <option value=""></option>
                    <?php
                    	for ($j = 0; $j < $row; $j++)
						{
							$data = mysql_fetch_array($sql);
							echo "<option value='".$data['SubId']."'>".$data['SubName']."</option>";
						}
					?>
                    </select>
                </td>
			<?php }
			}
		?>
        </tr>
        <tr>
        <td>Friday</td>
        <?php
        	for ($i = 0; $i < 11; $i++)
			{
				if($i == 5)
			{
				echo "<td>".K."</td>";
			}
				else
				{
				$sql = mysql_query("SELECT * FROM tblsubject", $Link);
				$row = mysql_num_rows($sql);
				?>
				<td>
                	<select>
                    <option value=""></option>
                    <?php
                    	for ($j = 0; $j < $row; $j++)
						{
							$data = mysql_fetch_array($sql);
							echo "<option value='".$data['SubId']."'>".$data['SubName']."</option>";
						}
					?>
                    </select>
                </td>
			<?php }
			}
	}
	else if($_POST['btnSave'])
	{
		
	}
		?>
        </tr>
          <tr>
    <td> <input type="submit" name="btnSave" id="btnSave" value="Save" /></td>
    </tr>
 
 
      </table>
      </fieldset>
      </form>
<form id="form1" name="form1" method="post" action="">
  <table width="700" border="0" align="" cellpadding="0" cellspacing="0">
    <tr>
      <td align="center"><fieldset><legend>Timetable Info</legend>
        <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
           <tr>
					<td align="center">Year </td>
					<td><select name="sYear">
					  <option value="1">1</option>
					  <option value="2">2</option>
					  <option value="3">3</option>
					  <option value="4">4</option>
					  <option value="5">5</option>
					  <option value="6">6</option>
					</select></td>
				  </tr>
         <tr>
					<td align="center">Class </td>
					<td><select name="sClass">
					  <option value="A">A</option>
					  <option value="B">B</option>
                      <option value="C">C</option>
                      <option value="D">D</option>
					</select></td>
				  </tr>
                  <tr>
    <td align="center"> <input type="submit" name="btnSearch" id="btnSearch" value="Search" /></td>
    </tr>
           </table>
      </fieldset> </td>
      </tr>
      </table>
      </form>  
      <?php
}?>
</body>
</html>
2

You can probably start by refactoring all this code, it looks really messy. Also you cannot do a modal with php alone, you’ll need JavaScript aswell. It is nonetheless not exactly clear what you’re trying to achieve. Perhaps you could explain further…

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.