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

Subscribe to our news:
Partners
Testimonials
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

Ran / Cole: "We bought the tool last week and want to say how much we love it. We've found it not only powerful, but very user friendly. We have used the tool to create an interface that manages our MySQL DB for different types of users".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Edit controls

The Edit options define the way the column data is represented on Edit and Insert pages.

 

 

Edit properties

Use this drop-down list to select a control to be used for this column on Edit and Insert pages. Available controls are:

 

Text
Time

 

To set additional control properties such as captions, formatting options, element attributes, and so on, use the dialog opened by the ellipsis button.

 

Read only

Use this option to make the control readonly. A readonly input field cannot be modified (however, a user can tab to it, highlight it, and copy the text from it). Readonly form elements will get passed to the form processor.

 

Visible

This option defines whether the control will be visible on the generated page. An invisible element stays in its original position and size.

 

Enabled

Use this option to specify whether the control will be enabled on the generated page. Turn it OFF to disable the control. Disabled input elements in a form will not be submitted.

 

Required

Check the Required box if the field is mandatory. Required columns are marked by red asterisk. When a user tries to submit a form with an empty required field, data will not be submitted and an error message will be shown.

 

 

PHP Generator for MySQL allows you to check for correctness of input data on the client side on two scopes:

 

The input value is validated when a user leaves the control. For this purpose, specify the suitable Client validator.

Range

The generated script validates if number is between the largest and smallest values.

Length range

The script validates if the length of text is between the min length and the max length.

Email

The script makes the element require a valid email.

Credit card

The script makes the element require a credit card number.

Number

The script makes the element require a decimal number.

URL

The script makes the element require a valid URL.

Digits

The script makes the element require digits only.

Regular expression

You can also specify your regular expression for data validation. Such expression is a pattern and every character entered in a form field is matched against that pattern – the form can only be submitted if the pattern and the user-input matches.

The input values are validated when a user clicks the Save button. This may be useful to check the compatibility of input data. For this purpose, use the OnInsertFormValidate and OnEditFormValidate client side events. These events occur before submitting of an insert and edit forms and allow you to detect errors on the client side before the form is submitted to the server to avoid the round trip of information necessary for server-side validation.

 

Default value

This option allows you to set the expected value of an input field with string templates. You can use such environment variables as %CURRENT_DATETIME%, %CURRENT_DATE%, %CURRENT_TIME%, %CURRENT_USER_ID%, and %CURRENT_USER_NAME%.



Prev Return to chapter overview Next