 |
|
Code (PHP)
<?php
header("content-type:text/html;charset=utf-8");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
include "connect.php";
$con_db=mysql_connect($host,$user,$pw) or die("Cannot connect db server");
$select_db=mysql_select_db($dbname);
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client='utf8'");
mysql_query("SET character_set_connection='utf8'");
mysql_query("collation_connection = utf8");
mysql_query("collation_database = utf8");
mysql_query("collation_server = utf8");
if($_GET['gData']){
$event_array=array();
$i_event=0;
$q="SELECT * FROM car WHERE date(timego)>='".date("Y-m-d",$_GET['start'])."' ";
$q.=" AND date(timeback)<='".date("Y-m-d",$_GET['end'])."'";
if($q.=" AND Active = 'YES' " ) {
echo "<td bgcolor='#00ff00'></td>";
}else if($q.=" AND Active = 'NO' "){
echo "<td bgcolor='#00ff00'></td>";
}
$qr=mysql_query($q);
while($rs=mysql_fetch_array($qr)){
$event_array[$i_event]['id']=$rs['id'];
$event_array[$i_event]['title']=$rs['name'].",".$rs['locate'].",".$rs['driver'].",".$rs['typecar'];
$event_array[$i_event]['start']=$rs['timego'];
$event_array[$i_event]['end']=$rs['timeback'];
$event_array[$i_event]['url']='show2.php?id='.$rs['id'];
$i_event++;
}
echo json_encode($event_array);
exit;
}
?>
นี้คือโค้ด Get data จาก calendar มาจาก db ครับ
|
 |
 |
 |
 |
| Date :
2013-03-19 09:51:51 |
By :
boyzathailand |
|
 |
 |
 |
 |
|
|
 |
