PHP - "Fat Free Framework" Find Methods and Showing Results in Template
        Posted  
        
            by 
                user1672808
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user1672808
        
        
        
        Published on 2012-09-15T03:36:25Z
        Indexed on 
            2012/09/15
            3:37 UTC
        
        
        Read the original article
        Hit count: 394
        
Just started trying the "Fat Free Framework"
- I'm building a site using a MySQL DB with 265 fields, and 5000+ rows in the DB;
- I can load() a specific record easily, no problems.
- When using find(), afind(), and even "select()", template will show blank lines or lines with "filler" text, with the correct number of rows for the query results, but no text/data from the DB itself;
- Same problem whether using objects or simply arrays from result (afind() and find()). I've copied/pasted the code verbatim from examples and from documentation, with only the DB specific items changed. Still, no luck.
CODE IN PHP FILE (function from CLASS):
static function home() {
    $featured=new Axon('boats');
    $F3::set('boatlist',$featured->afind('D_CustomerID=173'));
    F3::set('content',TEMPLATE_DIR .'/home.html');
    echo Template::serve(TEMPLATE_DIR .'/layout.html');
}
TEMPLATE home.html:
<div class="span8">
<h3>
    Featured Boats
</h3>
<F3:repeat group="{{@boatlist}}" value="{{@boat}}">
<div style="margin-left: 2em" class="thumbnails">
    <p>
        <a href="boat/{{@boat['D_BoatNum']}}">{{trim(@boat['D_Description'])}}</a> by {{@boat['D_CustomerID']}}
    </p>
    <p>
        {{@boat['D_Price']}}
    </p>
</div>
</F3:repeat>
</div>
The number of rows this produces coincides with the correct number of rows in the DB. However, the actual data from each field does not show.
Any ideas?
© Stack Overflow or respective owner