If in content.php
I do not fill the table with the data, then I can see properly formatted jquery data table. However, if I fill it with the data (I tried both DB data and manual input of some random numbers), it is not formatted anymore and looks like a hell. Could it happen that $.get(..)
(used in test.php
) does not work properly in this example?
test.php
$(document).ready(function() {
loadContent();
});
function loadContent() {
$.get('modules/mod_scheduler/content.php', function(data) {
$('#table').html(data);
});
}
<div id="table"></div>
content.php
<?php
include_once '../../include/connect_db.php';
$query = "SELECT * FROM `TestTable`";
$result=execute_query($query);
?>
<table id="newspaper-b" border="0" cellspacing="2" cellpadding="2" width = "100%">
<thead>
<tr>
<th scope="col">Flight Num</th>
<th scope="col">Appearance Time</th>
<th scope="col">Target Time</th>
<th scope="col"></th>
</tr>
</thead>
<tbody>
<?php while($row=mysql_fetch_assoc($result)) {
$flightNum=$row['flightNum'];
$appearanceTime=$row['appearanceTime'];
$targetTime=$row['targetTime'];
?>
<tr>
<td><?php echo $flightNum; ?></td>
<td>
<?php echo $appearanceTime;?>
</td>
<td>
<?php echo $targetTime;?>
</td>
<td id="<?php echo $flightNum; ?>">
<div>
<img src='modules/images/edit.png' alt='Edit' />
</div>
</td>
</tr>
<?php }?>
</tbody>
</table>
Of course, I have also defined the following:
<link type="text/css" rel="stylesheet" href="modules/mod_scheduler/css/demo_table.css"/>
<link type="text/css" rel="stylesheet" href="modules/mod_scheduler/css/demo_page.css"/>
<link type="text/css" rel="stylesheet" href="modules/mod_scheduler/css/demo_table_jui.css"/>
<script type="text/javascript" src="modules/mod_scheduler/js/dataTable/jquery-ui.js"></script>
<script type="text/javascript" src="modules/mod_scheduler/js/dataTable/jquery.dataTables.js"></script>
<script language="javascript" type="text/javascript" src="modules/mod_scheduler/js/jqplot/plugins/jqplot.pointLabels.js"></script>