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

Subscribe to our news:
Partners
Testimonials
Peter Robinson: "As a tech savvy company director, I wanted an inexpensive web based database application to manage all aspects of my business. As with most humans I find developing purely by CLI very hard and do not have the will or time to invest in improving my skills. I was looking to find a nice human friendly GUI to design and build my application, which is when I came across PHP Generator for MySQL.

Whilst you still need a great understanding of logic and a small amount of programming ability to get the specific results you require, I am very happy with the speed of progress I have been making with this invaluable tool.

With all the standard libraries included, this product makes normal requirements such as JavaScript form validation, lookup selectors, on click events, auto complete, detailed searches, multiformat exports, rss feeds and username security straight forward and quick.

Having any changes made via the GUI written to the web server at the click of a button makes testing out ideas quick and easy without fear of breaking your application.

To conclude, I couldn't find any other product on the market that came close to offering the amount of options this does, and I do hope that more products like this come out in the future, with the hope of eventually eradicating the need to program all together".

Patrick Biegel: "Thanks a lot for your fast reply and the great solution! It works now and that's really important! The PHP Generator for MySQL is a great software".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Dynamic Combobox

Select this control to create a combination of a single-line editable textbox and a drop-down list filtered according to values entered in the textbox. It is recommended to use this editor type as lookup editor to work with a big number of records. Live Demo.

 

 

Related editors

In Dynamic Combobox items are filled on-the-fly, so this control is the best choice when you have a sufficiently large number of items. If number of items is not exceed 10-15, consider to use "classic" Combobox as it works slightly faster.

 

To allow user to select the value step-by-step (for example, first select a country, then a city in the selected country), use Cascading Combobox or Dynamic Cascading Combobox editors.

 

Max width

Use this property to restrict the maximum width of the editor (this means that in any screen resolution editor's width will be less or equal then the property value). Can be specified in any units supported by web browsers e.g. 300px, 25em, 50%, etc.

 

Allow clear

Turn it ON to allow end users to clear the selected value using special button.

 

Minimum input length

Use this option to specify minimal amount of symbols to start the search (useful for large lookup datasets where short search terms are not very useful).

 

Number of values to display

Defines the number of lookup values to be displayed in the drop-down list.

 

Item caption template

This option allows you to populate the combobox with values of several columns. For this purpose, specify a template to be used for each item in the list.

 

Inline styles

Use this field to set formatting options to be used inside the style attribute of the element. For example, to set the font color and the background color for a control, place the following string to Inline styles:

 

color: red; background-color: yellow;

 

Custom attributes

This property allows you to add simple metadata to individual elements, largely for the purpose of providing information to make JavaScript functions easier. Such attributes can be later handled in client-side events. For example, to add several custom attributes to an editor, enter the following string into the Custom attributes edit box:

 

data-city="Boston" data-lang="js" data-food="Bacon"

 

It is recommended to prefix all custom attributes with data- to keep the result document compatible with the HTML5 requirements.

 

Formatting functions

Use these functions to format search results and the selection. For example, it is possible to use fonts, colors, images, and so on. All you need is to specify two functions in JavaScript each of which accepts the current item as a parameter and returns the HTML code to represent search results and the selected item accordingly. In the example below search results are displayed in italic and the selected item is displayed in bold.

formatResult function:

return '<i>' + item.text + '</i>';

 

formatSelection function:

return '<b>' + item.text + '</b>';

 

The editor now looks as follows:



Prev Return to chapter overview Next