Medoo SQL database select rows matching a date range

Question

Is it possible to include strtotime date comparison parameters when using medoo to SELECT rows from a database?

I'm using medoo to make database work nice & simple - it's great. However, I'm not sure if I can (but suspect I can) include a date range like parameter when getting rows from my database.

Instead of going through all rows in a foreach routine of what is a large database, I was hoping I could optimise my SELECT/WHERE calls. My loose example/idea is here, but I'm not sure what will work.

$thelogs = $database->select("system_logs", 
    array("date", "category", "description","class"),
    array("date" => .........strtotime('-7 day'))
);

...More information pertaining the way dates are being saved.
Date column is set to datetime in MySQL
Example entry would be: 2014-12-21 05:31:22
In php i'm just using date('Y-m-d H:i:s')

You verified this to work if not going through medoo, didn't you? — Abecee, Dec 21 '14 at 23:00
? Had seen tickets on github related to the subject, but couldn't get my head around it. — feelsickened, Dec 22 '14 at 15:15

score 1 · Accepted Answer · answered Jan 18 '15 at 19:06

I managed to get this to work with the following:

    $log_date_range = date("Y-m-d H:i:s", strtotime("-7 days"));

                        $thelogs = $database->select("logs", array(
                        "date",
                        "category",
                        "description",
                        "class",
                        "ID"), array(
    "date[>]" => $log_date_range
));

score 0 · Answer 2 · answered Dec 22 '14 at 10:30

0

Medoo is supported datetime condition. You can use it like this:

$database->select("system_logs", array(
    "date",
    "category",
    "description",
    "class"
), array(
    "date" => date('Y-m-d H:i:s', strtotime("-7 days"))
));

answered Dec 22 '14 at 10:30

Angolao

986
1
15
27

This isn't returning anything from my database. Should this return only rows with dates specifically 7 days difference - or all rows where the dates are > 7 days ? – feelsickened Dec 24 '14 at 14:57
@feelsickened Check your datetime format in database row. The `xxx` in `date('xxx')` should match the format while you inserting the datetime data into database. – Angolao Dec 24 '14 at 18:11
Sorry, the above doesn't work. Have updated original question with more information about the datetime format if that helps clarify or reveal the issue. – feelsickened Jan 10 '15 at 19:08

score 0 · Answer 3 · answered Jan 02 '15 at 05:39

0

 $database->select("system_logs", array(
    "date",
    "category",
    "description",
    "class"
), array(
    "date[>]" => strtotime("-7 days")
));

answered Jan 02 '15 at 05:39

Deror

51
3

This solution appears to return all rows no matter the date. Have updated the original question with saved datetime format info for clarification. – feelsickened Jan 10 '15 at 19:13

Medoo SQL database select rows matching a date range

3 Answers3