if ($added == 'Yesterday') { $start -= 60 * 60 * 24; } $end = $start + 60 * 60 * 24; $where = addWhere($where, "(message.added>={$start} AND message.added<{$end})"); } if ($action !== 'All') { $where = addWhere($where, '(message.action=\'' . $action . '\')'); } if ($new !== 'All') { $where = addWhere($where, '(message.showCount' . $new . ')'); } if ($search !== '') { $where = addWhere($where, '(messages.contents MATCH \'' . $search . '\')'); } $where = addWhere($where, '(message.deleted=0)'); //display the contents $sql = 'SELECT messages.contents, message.action, message.id, message.added, message.showCount, message.readCount FROM messages INNER JOIN message on messages.rowId=message.messageId ' . $where . ' ORDER BY message.added DESC'; $result = $db->query($sql); $index = 0; foreach ($result as $row) { //I don't think there's a way to get how many rows are returned from a SQLite query, and I'm too //lazy to find out, so simply only write out the table if we have data to output if (!$index) { echo $resultTableHeader; } $shownIds[$index]['showCount'] = $row['showCount']; $shownIds[$index]['id'] = $row['id']; $index++; $addDate = gmdate("Y-m-d", $row['added']); $addTime = gmdate("H:i:s", $row['added']);
if ($where) { if ($and) { $where .= " AND {$add}"; } else { $where .= " OR {$add}"; } } else { $where = $add; } return $where; } if (!empty($_POST["filter"])) { $where = ""; if ($_POST["price_start"]) { $where = addWhere($where, "`price` >= '" . htmlspecialchars($_POST["price_start"])) . "'"; } if ($_POST["price_end"]) { $where = addWhere($where, "`price` <= '" . htmlspecialchars($_POST["price_end"])) . "'"; } if ($_POST["manufacturers"]) { $where = addWhere($where, "`manufacturer` IN (" . htmlspecialchars(implode(",", $_POST["manufacturers"])) . ")"); } if ($_POST["wifi"]) { $where = addWhere($where, "`wifi` = '1'"); } $sql = "SELECT * FROM `my_table`"; if ($where) { $sql .= " WHERE {$where}"; } echo $sql; }