Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Charles Phillips: "I very much like the program and all of its functionality! Would be happy to give you an endorsement or recommend it to others - saves me a ton of time".
Craig Cordell: "The simplicity of your code generator is fantastic. We've evaluated dozens of others over the past few years but have yet to find one that is as easy to use as yours".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

OnGetSelectionFilters

This event allows you to specify a set of pre-defined options for record selection.

 

Signature:

function OnGetSelectionFilters(FixedKeysArray $columns, &$result)

 

Parameters:

$columns

An associative array of columns available for filtering.

$result

An associative array of selection options (caption => filter)

 

Example

 

This example adds "Americas", "Asia+Africa", and "Europe" selection options. Clicking an option selects the corresponding countries.

 

$result = array(

    'Americas' => new FilterCondition(

        $columns['continent'],

        FilterConditionOperator::ENDS_WITH,

        array('America')

    ),

    'Asia+Africa' => new FilterGroup(FilterGroupOperator::OPERATOR_OR,

        array(

            new FilterCondition($columns['continent'], 

                       FilterConditionOperator::EQUALS, array('Asia')),

            new FilterCondition($columns['continent'],

                       FilterConditionOperator::EQUALS, array('Africa'))

        )

    ),

    'Europe' => new FilterCondition(

        $columns['continent'],

        FilterConditionOperator::EQUALS,

        array('Europe')

    ),

);



Prev Return to chapter overview Next