Agan2 langsung aja ya ane lg butuh bantuan untuk aplikasi yg lagi ane buat.
Yaitu, ane mau menampilkan data booking (check-in check-out). ke dalam bentuk calendar HTML.

Table Booking di dalam MySQL ane seperti ini gan :


nah, ane mau buat tampilannya seperti ini gan :

itu ane screenshoot dari ane buat di excel..

ane udah buat view nya di web yg lg dibangun kaya gini :


ane bingung gan mau bikin gmn supaya di range tanggal property yg sudah di booking itu, table nya ada background highlight + nama yg booking. persis seperti gambar yg ane buat dari excel itu..

ane sih kefikiran mau pake colspan, cuman bingung implementasi ke codingnya gimana gaan.. help please..

ini coding PHP ane.. maaf klo berantakan ya gan

<?php



 $real_date = date("Y-m-d h:i:s");

 $month_get = $_GET['month'];

 $year_get = $_GET['year'];

 if($month_get=='') {

 $month_now_label = date('M');

 $month_now_number = date('m');

 }else{

 $month_now_label = $month_get;

 $month_now_number = alld_getBulan_number($month_get);

 }

 

 if($year_get=="") {

 $year_now = date('Y');

 }else{

 $year_now = $year_get;

 }

 

 $day_now = date('d');

 $tot_days = cal_days_in_month(CAL_GREGORIAN, $month_now_number, $year_now); 

 

 ?>

 <link href="css/style-cal.css" type="text/css" rel="stylesheet" />

 <table class="calendar">

 <tr>

 <td rowspan="3" valign=top style="text-align: center; padding: 5px;">

 <form method="GET">

 <div class="form-group">

 <select name="month" class="form-control">

 <?php echo option_bln($month_now_label); ?>

 </select>

 <select name="year" class="form-control">

 <?php echo option_thn($year_now); ?>

 </select>

 <input type="submit" name="change" class="btn btn-primary btn-block" value="Change" />

 </div>

 </form>

 </td>

 <td colspan="31" class="month_label"><?php echo $month_now_label." ".$year_now; ?></td>

 </tr>

 <tr>

 

 <?php for($i=1;$i<=$tot_days;$i++) {

 echo "<td class='day'>"; printf("d\n", $i); echo "</td>";

 } ?>

 </tr>

 <tr>

 

 <?php for($i=1;$i<=$tot_days;$i++) {

 echo "<td class='day'>". getDays(date('Y-m') ."-$i") ."</td>";

 } ?>

 </tr>

 <!-- List Property Start here -->

 <?php

 $rsGetProperty = alld_query("SELECT prop_name, prop_id, owner_id FROM property ORDER BY prop_name ASC");

 while($a_prop=mysql_fetch_array($rsGetProperty)) {

 $rs_book = alld_query("SELECT check_in, check_out FROM booking WHERE prop_id = '$a_prop[prop_id]'");

 ?>

 <tr class="item_lists">

 <td class="property_label"><?php echo $a_prop['prop_name']; ?></td>

 <?php for($i=1;$i<=$tot_days;$i++) {

 

 $daylabel = sprintf("d", $i);

 if(cekmasa("$year_now-$month_now_number-$daylabel")=='kemarin') {

 $class_day = "day_disabled";

 }elseif(cekmasa("$year_now-$month_now_number-$daylabel")=='masadepan'){

 $class_day = "day_hover";

 }

 

 echo "<td class='day $class_day ajax-popup' title='$daylabel $month_now_label $year_now'></td>";

 } ?>

 </tr>

 <?php } ?>

 </table>

Help agan2 untuk solving problem ane.. untuk yg bisa berhasil ane bisa kasih cendol ke agan make prime ane..

makasih ya.. thanks kaskus.. maaf kalau ada salah2 kata...