Untitled

<?php

      $conditionals = array();

      if (!empty($environment->data->eventID))
         $conditionals[] = "`eventID` = $environment->data->eventID";

      if (!empty($environment->data->entryID))
         $conditionals[] = "`entryID` = $environment->data->entryID";

      if (!empty($environment->data->deviceID))
         $conditionals[] = "`deviceID` = '$environment->data->deviceID'";

      if (!empty($environment->data->timestampStart))
         $conditionals[] = "`timestamp` >= $environment->data->timestampStart";

      if (!empty($environment->data->timestampEnd))
         $conditionals[] = "`timestamp` <= $environment->data->timestampEnd";

      if (count($conditionals))
         $conditional = "WHERE " . implode(" AND ", $conditionals);

      $result = $database->query("SELECT * FROM `entries` %s", $conditional);