Dynamic Editing with Global phpLens Settings
Table of Contents
Dynamic Editing with Global phpLens Settings
The Dynamic editor allows you to modify global phpLens settings such as the colors
and the SQL statement to use. From the top left of the phpLens grid, click the
red  Edit phpLens Settings icon
to run the Dynamic Editor. This will bring you to the page shown below. At the
top of the page is the menu bar which allows you to move to different dynamic
editing screens.
The Choose dropdown menu that is currently selected in the picture above allows you to define settings that affect multiple columns. For example, selecting Grid Columns allows you to choose which columns are shown in the grid.
Just below the menu are a series of tabs that allow you to control different parts of phpLens.
Note that you can make changes on multiple tabs before saving.
| Tab Name |
Description |
| Colors |
The first tab allows you to define the colors used by phpLens. You can also define your own color styles by adding new array entries
to the Javascript array PHPLENS_styles in phplens/img/phplens-js.styles.js.
|
| General |
Allows you to set the first state of phpLens, debugging options, SQL, table to save to, and primary key. |
| Editing |
Configure edit/insert/delete permissions, and record locking. |
| Display |
Manage number of rows to display, table sizing, and other display options. |
| Formats |
Date formating and captions to display when editing, inserting and searching. |
| Templates |
Smarty template names to use. |
| Titles |
Allows you to create multiple-level titles. |
| Menus |
Menu display. |
The General tab
is shown below:
Online help on each feature is available by clicking on the associated caption. Note that you can change settings in multiple tabs without having to save, and only when you are satisfied with your changes, do you click on Save Settings.
Cascading Style-Sheets
Since version 2.5, PhpLens comes with a default style sheet in phplens/img/phplens.css.
You can use your own style-sheet by setting the css property:
$lens->css = '/css/myphplens.css';
Then you can define styles for different parts of phpLens. For example, to
configure the background of field titles, you could define in myphplens.css:
.lens-title {background:lightyellow}
and in your source code:
$lens->colorTitle = 'lightyellow class=lens-title'
For non-CSS compliant browsers, the field title will be lightyellow,
which for CSS compliant ones, the lens-title class will be used. Note
that the default non-CSS color must be defined first, before the CSS class
selector is defined.
Tips
You can configure the following things when creating records:
| How
Do I... |
Solution |
Properties
modified |
| Create scrolling links like google? |
Enter the number of Scroll Links in global settings.
Or set $lens->scrollLinks to the number of scroll links you want
to see. An odd number is recommended. |
scrollLinks |
| How do i debug phpLens |
You can turn on debugging by setting $lens->debug =
1 (or 2 for more info), or selecting Debug from the global
settings. This will output the SQL generated, any error messages,
the current internal state of phpLens, and other useful information, |
debug |
| Allow editing in the detail grid |
Set the Child Editor in Detail Grid setting.
|
childLens |
| How do I enable editing? |
Go to the Editing tab and define the Table data is
saved to, and the Primary Key of Table. Then click on
Save Settings. The next time you open global settings, you will be
able to enable editing, creating new records and deleting. |
keyCol, keyTable, canEdit, canDelete, canNew
|
| How do i start phpLens in search mode |
Set Start phpLens to "Search Form showing
Records", or if you want to only show the search form when no
search is running, select "Search Form". |
firstState |
| Perform editing within the grid |
Check the Edit Multiple Records checkbox, or
set $lens->editMultiple = true. |
editMultiple |
| I want to define my SQL dynamically |
The SQL and Key Table fields support PHP global variables if the first character
in the field is =. For example, suppose you have multiple tables that hold postcodes for specific countries, eg:
usacodes, japancodes, ukcodes, malaysiacodes. You can store the country in a PHP global variable $COUNTRY and
set the sql property to:
=SELECT * FROM {$COUNTRY}CODES
|
sql |
| I want to edit multiple records at one time |
Define the table to save to, and the primary key of the table. Then set Edit Multiple
Records in the Editing tab |
editMultiple |
| I want the phpLens grid width to expand to 100%. |
Set the Table Width 100% checkbox in the Display tab. This modifies the layoutTableHeader,
gridTableHeader and detailTableHeader
properties dynamically. |
|
| Exporting to Excel |
Click on the Choose dropdown menu at the top of the form. Select Columns to Export. The following properties are affected: exportLens and
exportOptions. |
exportLens |
This documentation system is maintained using phpLens
|
