Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Filter or TAB?

phpMyEdit Configuration     Filter or TAB?
Post new topic   Reply to topic    
 
dglp     Joined: 09 Nov 2014   Posts: 2  
Post Posted: 2014-11-09 11:07
Back to top  Reply with quote     

I'm just setting up an instance ot phpMyEdit, and am wondering whether it's simpler to display a subset of columns using a filter, or the TAB functions.

I've got a table (projectdetails) of 30 columns and 200 records I want to show just three columns of the main table (id, name, mapit), as an index of sorts.

I am thinking the filter option requires defining a WHERE clause that includes evey record of the three columns. Not sure how I'd do that.

So perhaps the TAB function would be easier? I'm looking for examples.

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2014-11-09 18:04
Back to top  Reply with quote     

Set 'options' for id, name, mapit to ACPVDFL and set the other columns to ACPVD

http://opensource.platon.sk/projects/doc.php/phpMyEdit/html/configuration.permission-options.html

 
dglp     Joined: 09 Nov 2014   Posts: 2  
Post Posted: 2014-11-09 20:45
Back to top  Reply with quote     

Very nice! Thank You!
So, for example, project_name options look like this:

Code:
$opts['fdd']['project_name'] = array(
  'nowrap' => 'true',
  'name'     => 'Project name',
  'select'   => 'T',
  'options'  => 'ACPVDFL',
  'maxlen'   => 65535,
  'textarea' => array(
    'rows' => 5,
    'cols' => 50),
  'sort'     => true
);


And the main page is clean aside from the columns I want.

*A further question?*
Can the navigation links be assigned to the project name field? So that I can click on the name to view the detail page...

 
Post new topic   Reply to topic    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy