php - Excel timetable from MySQL database to Bootstrap table -
i'm trying make timetable website job, , can't figure out, boss makes excel table showing date , times people work.
e.g.
date ---- john ---- marcus
01.04 --- 08-12 --- 12-18
and on...
and i'm trying do, excel file in mysql, , print out website, thing is, whenever try, kind of works, prints text sideways.
e.g.
date ---- john ---- marcus
01.04 --- 02.04 --- 03.04
and put date sideways , not downwards, show dates of month sideways..
this have.
<table class= "table table-striped table-bordered table-hover"> <thead> <tr> <th colspan="1" rowspan="1" style="width: 180px;" tabindex="0">date</th> <th colspan="1" rowspan="1" style="width: 220px;" tabindex="0">john</th> <th colspan="1" rowspan="1" style="width: 288px;" tabindex="0">marcus</th> </tr> </thead> <tbody> <?php $query = mysql_query("select * information"); $i=0; while($fetch = mysql_fetch_array($query)) { if($i%2==0) $class = 'even'; else $class = 'odd'; echo'<tr class="'.$class.'"> <td><span class="xedit" id="'.$fetch['id'].'">'.$fetch['date'].'</span></td> <td>'.$fetch['name'].'</td> <td>'.$fetch['time'].'</td> </tr>'; } ?> </tbody> </table>
Comments
Post a Comment