Changeset 17551 for schedule

Timestamp:

02/13/14 14:25:25 (11 years ago)

Author:

tose

Message:

Modify implementation for loading previous data

File:

• schedule/Transaction/PreviousData.php (modified) (1 diff)

schedule/Transaction/PreviousData.php

@@ -1 +1 @@
  <?php
 //connect to the mysql
-        include '../include/dbcon.php';
-        $day=$_POST['SelectedDay'];
-        
+        $db = mysql_connect("localhost","scheduletest","t3stsched");
+        mysql_select_db('sandboxschedule', $db) or die("Could not select database");
+
+        $day=$_POST['SelectedDay'];
         $date = Date('Y-m-d', strtotime($day));
-        $prev = mysql_query("SELECT Date(fStart) AS PrevDate FROM schedule WHERE (date(fStart) < $date) ORDER BY Date(fStart) DESC LIMIT 1");
-        $prevdate = mysql_fetch_array($prev);
-        if(mysql_num_rows($prevdate) > 0) {
-      $prevday = date('Y-m-d', $prevdate['PrevDate']);
-        } 
+
+        $prev = mysql_query("SELECT Date(fStart) AS PrevDate FROM schedule WHERE (Date(fStart) < '$date') ORDER BY Date(fStart) DESC LIMIT 1");
+        $prevdate = mysql_fetch_array($prev);
+
+        if(mysql_num_rows($prev) > 0) {
+                $prevday = date('Y-m-d', strtotime($prevdate['PrevDate']));
+        }
         else {
-      $prevday = date ('Y-m-d');
+                $prevday = date('Y-m-d');
         }
-        echo $prevday;
+        echo json_encode($prevday);
 ?>