source: schedule/Transaction/PreviousData.php@ 17689

Last change on this file since 17689 was 17551, checked in by tose, 11 years ago
Modify implementation for loading previous data
File size: 644 bytes
Line 
1 <?php
2//connect to the mysql
3 $db = mysql_connect("localhost","scheduletest","t3stsched");
4 mysql_select_db('sandboxschedule', $db) or die("Could not select database");
5
6 $day=$_POST['SelectedDay'];
7 $date = Date('Y-m-d', strtotime($day));
8
9 $prev = mysql_query("SELECT Date(fStart) AS PrevDate FROM schedule WHERE (Date(fStart) < '$date') ORDER BY Date(fStart) DESC LIMIT 1");
10 $prevdate = mysql_fetch_array($prev);
11
12 if(mysql_num_rows($prev) > 0) {
13 $prevday = date('Y-m-d', strtotime($prevdate['PrevDate']));
14 }
15 else {
16 $prevday = date('Y-m-d');
17 }
18 echo json_encode($prevday);
19?>
Note: See TracBrowser for help on using the repository browser.