Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if (isset($_POST['daterange'])) {
- $sql = "SELECT * FROM `data` WHERE TimestampLocalTime BETWEEN ' ".$start_date." ' AND ' ".$end_date." ' ";
- } elseif (isset($_POST['daterange']) && isset($_POST['device']) ) {
- $device = $_POST['device'];
- $sql = "SELECT * FROM `data` WHERE DeviceName = ' ".$device." ' AND TimestampLocalTime BETWEEN ' ".$start_date." ' AND ' ".$end_date." ' ";
- } elseif (isset($_POST['daterange']) && isset($_POST['device']) && isset($_POST['experience']) ) {
- $experience = $_POST['experience'];
- $sql = "SELECT * FROM `data` WHERE DeviceName = ' ".$device." ' AND ExperienceName = ' ".$experience." ' AND TimestampLocalTime BETWEEN ' ".$start_date." ' AND ' ".$end_date." ' ";
- } else {
- $sql = "SELECT * FROM `data` WHERE TimestampLocalTime BETWEEN ' ".$start_date." ' AND ' ".$end_date." ' ";
- }
Add Comment
Please, Sign In to add comment