This example script demonstrates Javascript validation when creating or editing records. To try it, click on the New record button in the applet below.

If the firstname is filled, then we validate that the lastname is also filled. If the firstname is empty, then we do not validate the lastname.

First we setup the following property:

$lens->validation = 'FIRSTNAME^%validatename( )^';

Then we define the javascript:

<script defer>
// if first name is set, then lastname must be set
function validatename()
{
   if (document.phplens_ex309_edit.lens_FC_FIRSTNAME.value) 
      if (! document.phplens_ex309_edit.lens_FC_LASTNAME.value) {
        alert('Both first and last name must be filled');
        return '';
      }

   return 1;

}
</script>

If the javascript function returns:

• 0 or false, then the default error message will appear.
• '' then we hide the default error message, so you can define your own error message.
• 1 or true, then the data is validated correctly.

  This is a Demo. You can not change anything for security reasons. Back to Grid     phpLens Settings  Column Settings   Choose Grid ColumnsDetail ColumnsFilter/Search Columns* New Record Columns* Edit Columns* Must Fill Columns- Read Only Columns- Columns to Sum- Columns to Average* Columns to Export* Sortable Columns- Graph Columns- Filter Compulsory Columns   Generate PHP Code   Remove All Settings   ?     Cancel Field PASSWORD   Type: string[48]   Change Type Char (C)Long Text (X)Integer (I)Numeric (N)Integer>=0 (J)Number>0 (P)Logical (L)Date (D)Datetime (T)Picture Blob (B) Default Title Password Grid Title Edit Title  2 Fields in Row New Title  2 Fields in Row Edit Notes Use {KEY} to incorporate primary key, and prefix ?EDIT? or ?NEW? to display note only in EDIT or NEW state Detail Title  2 Fields in Row Filter Title Input Dimensions (suggested size: 48 x 1) Columns:   Rows: Power Lens Lookup Values Input Type Text/Popup   ReadOnly     Enter a lookup to allow check boxes and radio buttons # check/radio columns Overlib Text Search Lookup when editing Matching above sql with fields Minimum character length   Search mode Only in New RecordSwitch from New to Edit  Hide key code Validation X: 0-9 A-Z x: 0-9 A-Z optional Z: 0-9 A-Z _ z: 0-9 A-Z _ optional #: 0-9 9: 0-9 optional +: positive numbers only &: any character ?: any character optional \: escape character >: to uppercase <: to lowercase =EMAIL: email validation Validation Error Msg Default New Value Prefix value with = to execute PHP code and % for SQL function Optional Editable Column Enabled when Column ADDRESS1ADDRESS2AGECITYCOUNTRYCREATEDEMAILFIRSTNAMELASTMODLASTNAMEPOSTCODESTATEUSERID   has value Enter A^B^C, or * for any non-empty value Power Edit Lens Grid TD Attributes   (nowrap, width=30%, align=center etc.) Cell Color grid^title^input   Color Reference opens in a new window Section Break Title Back color   CSS class WYSIWYG Editor for fields that accept HTML Do not convert Special Chars This Field supports Double-Byte (eg Chinese, Japanese) and HTML tags Must Fill Yes   * Must Fill Columns Read Only Yes   - Read Only Columns Visible in Grid No   Grid Columns Visible in Details No   Detail Columns Visible in New Record Yes   * New Record Columns Visible in Edit Record Yes   * Edit Columns   Cancel PHPLens: 4.9.2   Data: 0.02   DB: mysql   adodb: 4.62   Compat: 2   PHP: 5.2.17   OS: Linux License Type: Enterprise   ID: (Natsoft;John Lim;jlim@natsoft.com)   Valid Till: Never Expires

  Notes

  When editing or creating new records, userid and password are set as must fill fields. Age only accepts numbers (this is automatic, no programming required), and email addresses are validated.

  See Example 302 and Example 303 which uses the same data.

  Table schema

    create table lensusers (
        USERID char(16) not null,
      PASSWORD char(16) not null,
        FIRSTNAME char(24) ,
      LASTNAME char(24) not null,
      EMAIL char(48) not null,
      ADDRESS1 char(48) not null,
      ADDRESS2 char(48) ,
      POSTCODE char(12) ,
      CITY char(24) ,
      STATE char(24) ,
      COUNTRY char(24) not null,
      AGE integer,
      CREATED datetime not null,
      LASTMOD datetime not null,
      primary key (userid)
    );
    

  This demo also shows you Google style scrolling. In this case, this is enabled by setting

    $lens->scrollLinks = 9
    

  which sets the number of scrolling links to 9.

  sameRowLens

  Also notice that the fields FirstName/LastName and PostCode/City are on the same line in the Details Grid, and New/Edit record forms. This is configured by checking "2 Fields in 1 Row" in the column settings for PostCode.

  sectionLens

  We also have section breaks with "Misc" and "Address" using the sectionLens property.