Menu

1. Requirement
2. Installation
3. Rules
4. Themes
5. Plugins
        1. Backend Plugins
        2. Frontend Plugins
6. Variables
7. Commands
8. Ajax
9. Component Dbug
10. Component Query builder
11. Extend Backend


View the Project on GitHub

Component Query builder

This component helps you to create sql query faster

<?php

$logs = Query::factory()->select("FirstName, Action, Resume")
                        ->from('NutsLog, NutsUser')
                        ->whereJoin() # auto join
                        ->order_by("NutsLog.ID DESC")
                        ->limit(5)
                        ->executeAndGetAll();

foreach($logs as $log)
{
    echo "ID: {$log['ID']}<br>";
    echo "Action: {$log['Action']}<br>";
    echo "Resume: {$log['Resume']}<br>";
    echo "<hr>";
}