awaiskhalid

Untitled

Jan 21st, 2018
38
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1.     if (isset($_POST['daterange'])) {
  2.         $sql = "SELECT * FROM `data` WHERE TimestampLocalTime BETWEEN  ' ".$start_date." ' AND ' ".$end_date." ' ";
  3.     } elseif (isset($_POST['daterange']) && isset($_POST['device']) ) {
  4.         $device = $_POST['device'];
  5.         $sql = "SELECT * FROM `data` WHERE DeviceName = ' ".$device." '  AND TimestampLocalTime BETWEEN  ' ".$start_date." ' AND ' ".$end_date." ' ";
  6.     } elseif (isset($_POST['daterange']) && isset($_POST['device']) && isset($_POST['experience']) ) {
  7.         $experience = $_POST['experience'];
  8.         $sql = "SELECT * FROM `data` WHERE DeviceName = ' ".$device." '  AND ExperienceName = ' ".$experience." ' AND TimestampLocalTime BETWEEN  ' ".$start_date." ' AND ' ".$end_date." ' ";
  9.     } else {
  10.         $sql = "SELECT * FROM `data` WHERE TimestampLocalTime BETWEEN  ' ".$start_date." ' AND ' ".$end_date." ' ";
  11.     }
Add Comment
Please, Sign In to add comment