Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Jonathan Oakes: "This is a lovely application. It's easy to hook into my own bespoke applications. It's very powerful, yet really quite simple to use. Thanks for this".
Charles Phillips: "Just want to take a second to really thank you for all the great support you give – I think that’s by far the best feature you offer".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

OnPreparePage

This piece of code is a method of the Page class that is called at the end of the constructor. It allows you to customize all members of the class.

 

Signature:

function OnPreparePage()

 

Parameters:

This method has no parameters.

 

Example

The following code hides the update_date_time column from the data grid and Single Record View form as well as the status column from Edit and Insert forms from all users except ones who have the Admin privilege for the current page.

 

if (!GetApplication()->IsLoggedInAsAdmin()) {

    $updateDateTimeColumnName = 'update_date_time';

    $column = $this->GetGrid()->getSingleRecordViewColumn($updateDateTimeColumnName);

    if ($column) {

        $column->setVisible(false);

    }

    $column = $this->GetGrid()->getViewColumn($updateDateTimeColumnName);

    if ($column) {

        $column->setVisible(false);

    }

 

    $statusColumnName = 'status';

    $column = $this->GetGrid()->getEditColumn($statusColumnName);

    if ($column) {

        $column->setVisible(false);

    }

    $column = $this->GetGrid()->getInsertColumn($statusColumnName);

    if ($column) {

        $column->setVisible(false);

    }

}

 

See also: OnPageLoaded.



Prev Return to chapter overview Next