Advice on query forms - newbie level about phreeze

[xtrasmal]

I would advice to watch the tutorial video on Models. There is a part that tells you how to use criteria.
You could make a form, which routes to Search. So the form action would be action="search".

So if you want to have the user look though a database table which has Posts, which you want to sort by date
then you would have a route like this:

'GET:search' => array('route' => 'Posts.Search'),

Then in the PostsController.php you could add a function:

public function Search()
{
    require_once 'Model/PostsCriteria.php';

    // From date, that the user selected
    $fromDate =  RequestUtil::Get("FromDate");
    // To date, that the user selected
    $toDate =  RequestUtil::Get("ToDate");

    // use Post criteria, to create a custom Query
    $criteria = new PostsCriteria();
    $criteria->Date_GreaterThanOrEqual = $fromDate;
    $criteria->Date_LessThanOrEqual = $toDate;

    // Then run the Query on the posts db table
    $posts = $this->Phreezer->Query('Posts', $criteria);

    // Then display the search results
    foreach ($posts as $post)
    {
        echo $post->Name . '<br/>';
    }
}

Hope this helps.

[josemalone]

Hey, thank you!

Yes, I have watched the videos which have made MVC much clearer to me. I just couldn't make the jump from static criteria to variable criteria from the web client. Let me see if I can take your lead and make this work.

Thank you, again.

[xtrasmal]

Awesome man, love your attitude. You will love Phreeze, I can smell it. Working with Phreeze opened up my view on MVC also.
I really want you to stick around and keep using Phreeze. It's bleeding edge software and a rough diamond with bad documentation, but it's heart is smart and strong.

[jasonhinkle]

Thanks guys! I started the Phreeze wiki where I hope some documentation might start appearing soon with the help of anybody who wishes. I will try to start working on it little by little as well.

https://github.com/jasonhinkle/phreeze/wiki

-j