3.7. Filters

Table-level filter capability (if set) is included in the WHERE clause of any generated SELECT statement. This gives you ability to work with a subset of data from table.

$opts['filters'] = 'column1 like "%11%" AND column2 < 17';

$opts['filters'] = 'section_id = 9';

$opts['filters'] = 'PMEtable0.sessions_count > 200';

You can also pass an array to this option. If you do so, than array items are put together with "AND" SQL statement.

When generating a query, phpMyEdit redefines/aliases the table names for easy accessing of particular table fields in the main table and in the tables used in JOIN clauses as well. The main table name is changed to PMEtable0, tables used in JOIN clauses have their name like PMEjoinN where N is JOIN table order.

We recommend that you look at the generated SQL queries in your MySQL log file in order to know how database the table was aliased. Finally, the described approach is needed only if you are accessing a field name which occurs in more than one table of SQL query (thus MySQL cannot exactly determine what is meant by "field_name").

For future development is planned an initialization like the following one.

$opts['filters'] = array(
	'col_name_1' => 'value_1',
	'col_name_2' => 'value_2'
);