/get_event.php

:::

[1042] XOOPS模組開發進階

4-5 /get_event.php

01<?php
02include "../../mainfile.php";
03 
04$start = date("Y-m-d" , $_REQUEST['start']/1000);
05$end = date("Y-m-d" , $_REQUEST['end']/1000);
06 
07$sql = "select sn, birthday, name from `" . $xoopsDB->prefix("phone_book") . "` where birthday >= '{$start}' and birthday < '{$end}'";
08$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'], 3, mysql_error());
09 
10$i=0;
11while (list($sn ,$birthday ,$name) = $xoopsDB->fetchRow($result)) {
12  $myEvents[$i]['title']     = $name;
13  $myEvents[$i]['start']     = $birthday;
14  $myEvents[$i]['url']       = "index.php?sn={$sn}";
15  $myEvents[$i]['color']     = 'red';
16 
17  $i++;
18}
19 
20 
21// $myEvents[0]['title']     = '開始';
22// $myEvents[0]['start']     = $start;
23 
24// $myEvents[1]['title']     = '今天';
25// $myEvents[1]['start']     = '2015-10-24';
26 
27// $myEvents[2]['title']     = '結束'.$end;
28// $myEvents[2]['start']     = '2015-10-31';
29 
30echo json_encode($myEvents);