Examples

Display

This example shows how to display only some columns.

I used the following sql query to get 4 fileds (id,rating,title,votes):

$params['sql_query'] = 'SELECT id,rating,title,votes FROM imdbtop250';

And added column 1 for a list of checkboxes, and column 6 for doing the actions of editing and delete an item.

So now the total is 6 columns (CHECKBOXES + ID + RATING + TITLE + VOTES + ACTIONS)

But now i hide the 2nd column (ID):

$params['display_cols'] = 'tftttt'  // t - shows; f - hide;

And still use the ID value (#COL2#) in the checkbox column and in the actions column, despite being hidden.

IMDb Top 250

Search...
RatingTitleVotesActions
9.1The Shawshank Redemption (1994)489048
9.1The Godfather (1972)392126
9.0The Godfather: Part II (1974)232161
8.9Il buono, il brutto, il cattivo. (1966)148969
8.9Pulp Fiction (1994)396749
8.8Schindler's List (1993)262551
8.812 Angry Men (1957)109861
8.8One Flew Over the Cuckoo's Nest (1975)202689
8.8Star Wars: Episode V - The Empire Strikes Back (1980)265556
8.8The Dark Knight (2008)436120
Total: 250Page: 1 of 25