What is Lazy Mofo (LM)?

• renders a datagrid of database results from a table name or SQL statement; grid features include pagination, sorting, search, and inline editing.
• renders forms for inputing and editing data
• updates, inserts and deletes data
• handles file uploads and image resizing and cropping. (images are not stored in the database, only filename)

What's Different & Better From other Grids

• open source and free (as in beer and speech)
• upload files, resizes and crops images; just define form_input_control array --image or --document
• lightweight; a single class

What Lazy Mofo is useful for

Requirements

Built-In Controller

This class has a built-in controller method to call its methods. Usage of the contoller is optional. form(), grid(), sql_insert(), sql_update(), sql_update_grid(), sql_delete() can all be called manually.

 Example: $lm->run();

Example 1 - Basic Usage

// create LM object, pass in PDO connection
$lm = new lazy_mofo($dbh); 

// table name for updates, inserts and deletes
$lm->table = 'market';

// identity / primary key column name
$lm->identity_name = 'market_id';

// use the lm controller 
$lm->run();

Example 2 - Define Forms and Grid with SQL

// create LM object, pass in PDO connection
$lm = new lazy_mofo($dbh); 


// table name for updates, inserts and deletes
$lm->table = 'market';


// identity / primary key column name
$lm->identity_name = 'market_id';


// make friendly names
$lm->rename = array('country_id' => 'Country');


// define input controls on the form
$lm->form_input_control = array('photo' => '--image', 'is_active' => '--checkbox', 'country_id' => 'select country_id as val, country_name as opt from country; --select');


// define editable input controls on the grid
$lm->grid_input_control = array('is_active' => '--checkbox');


// define output control on the grid; make email clickable and the photo a clickable link
$lm->grid_output_control = array('contact_email' => '--email', 'photo' => '--image');


// query for grid(). if the last column selected is the primary key identity, then the [edit] and [delete] links are displayed
$lm->grid_sql = "select m.market_name, m.photo, m.contact_email, c.country_name, m.is_active, m.create_date, m.notes, market_id from market m left join country c on m.country_id = c.country_id";


// query for form()
$lm->form_sql = 'select * from market where market_id = :market_id';
$lm->form_sql_param = array(':market_id' => intval($_REQUEST['market_id']));


// use the lm controller
$lm->run();

Input and Output Controls - define how a field in rendered

Input and Output Controls are associative arrays used to define how to render input or output for a field. Inputs render form inputs like: text, checkbox, radio, etc. Outputs render: text, links, and images.

• Define Inputs on form()   $lm->form_input_control = array('field_name_1' => '[sql ]--command','field_name_2' => '[sql ]--command', ...);
• Define Inputs on grid()   $lm->grid_input_control = array('field_name_1' => '[sql ]--command','field_name_2' => '[sql ]--command', ...);
• Define Output on grid()   $lm->grid_output_control = array('field_name_1' => '--command','field_name_2' => '--command', ...);

Example: $lm->form_input_control = array('client_pic' => '--image','pdf' => '--document', 'weird_data' => '--my_user_function', 'will_you_attend' => "select 1 as key, 'Yes' as val union select 0, 'No' union select 3, 'Maybe'; --radio");

Auto Populated Controls

Input Commands Preceeded by SQL to Populate Data: --select, --checkbox, --radio

Example: $lm->form_input_control = array('country_id' => 'select country_id, country_name from country; --select');

Commands for Input Controls - form_input_control and grid_input_control arrays

Commands for Output Control - grid_output_control arrays

Adding server-side validation

Example: 

$lm->insert_user_function = 'my_validate';
$lm->update_user_function = 'my_validate';

function my_validate(){

    if($_POST['email'] == '')
        return 'Email is Required';
}

Cross Site Request Forgery - csrf