php - timetable for scheduled subjects -

-

i got right though problem how can put style on table row has data inside , better if can put rowspan 1 table row.

here output:

enter image description here

and here code:

<?php  	$db = new mysqli("localhost", "root", "", "bsu_db");  	if($db->connect_errno > 0){  	    die('unable connect database [' . $db->connect_error . ']');  	}	  	$times = ["7:00:00", "7:30:00", "8:00:00", "8:30:00", "9:00:00", "9:30:00", "10:00:00", "10:30:00", "11:00:00", "11:30:00", "12:00:00"];  	$days = ["monday", "tuesday", "wednesday", "thursday", "friday", "saturday"];  	$subjday = array();  	$sqlsubjday = "select * subject_day_tbl";  	$qrysubjday = $db->query($sqlsubjday);  	while($rowsubjday = $qrysubjday->fetch_assoc()){  		//array_push($subjday, $rowsubjday['sub_day'], $rowsubjday['start_time'], $rowsubjday['end_time']);  		$subjday[] = $rowsubjday;  	}  	json_encode($subjday);  ?>  <table class="table table-bordered table-condensed">  	<thead>  		<tr>  			<th></th>  			<?php  				foreach ($days $day ) {  					echo "<th>$day</th>";  				}  			?>  		</tr>  	</thead>  	<tbody>  	<?php	  		foreach ($times $time) {						  	?>  	<tr>	  		<td><?php echo $time; ?></td>  		<?php  			foreach ($days $day) {											  				echo "<td>";  				foreach($subjday $sd){  											  					if($day == $sd['sub_day'] && strtotime($time) >= strtotime($sd['start_time']) && strtotime($time) <= strtotime($sd['end_time'])){  						echo $sd['sub_day'] , " " , $sd['start_time'] , " - " , $sd['end_time'];  					}  											  				}  				echo "</td>";  			}    		?>  	</tr>  	<?php 		  		}   	?>					  	</tbody>  </table>


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more