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

Subscribe to our news:
Partners
Testimonials
Tony Broadbent: "Such a great product! I have been struggling to hand craft pages which, with your PHP Generator, I created beautifully within 5 minutes of downloading it".
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".

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