To create new records, click on the icon in the menu on the top-right of the grid. To edit, click on

See also Example 320 for an alternative editing interface with a Child Editor in the Details Grid.

PHPLens
User ID Name email   1 123456 124345 12345 test@test.com		User ID 123456 First Name 124345 12345 Last Name   12345 email test@test.com   Address  Address Line 1 123 Address Line 2 123 Postcode 123 City   123 State 123 Country 123   Misc  Age 12 Created 30-Jan-2012 06:40:42 PM
PHPLens (Page 1/1)

Notes

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.