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

Subscribe to our news:
Partners
Testimonials
Rickey Steinke: "Folks, I wanted to drop a line and give you a fanatic thank you. I have a project due for my computer application course and without PHP Generator I never would have gotten it done with the professional results your product produced. My sincerest gratitude to each and every team member who brought this program to light".
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

addItem

Adds items to a checkbox group or a multiple select dynamically.

 

Signature:

function addItem(value, caption);

 

Example:

The code below placed in the OnInsertFormEditorValueChanged and OnEditFormEditorValueChanged changes the content of the 'Clothes' checkbox group depending of the selected season.

 

if (sender.getFieldName() == 'season') 

{

 var $item_count = editors['clothes'].getItemCount(); 

 if ($item_count == 6)

   {

    if (sender.getValue() == 'Winter')

       {

       editors['clothes'].removeItem('Shorts');

       editors['clothes'].removeItem('Sandals');

       editors['clothes'].removeItem('Swimsuit');

       }

    else

    {

      editors['clothes'].removeItem('Coat');

      editors['clothes'].removeItem('Boots');

      editors['clothes'].removeItem('Cap');

    }

  }

  else

  {

    editors['clothes'].clear();

    if (sender.getValue() == 'Winter')

       {

       editors['clothes'].addItem('Coat','Coat');

       editors['clothes'].addItem('Boots','Boots');

       editors['clothes'].addItem('Cap','Cap');  

       }

    else

    {

       editors['clothes'].addItem('Shorts','Shorts');

       editors['clothes'].addItem('Sandals','Sandals');

       editors['clothes'].addItem('Swimsuit','Swimsuit');

    }

  }

 

The screenshot demonstrates the result of the fired event.

 

 

See also: removeItem, getItemCount, clear



Prev Return to chapter overview Next