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

Subscribe to our news:
Partners
Testimonials
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".
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".

More

Add your opinion

Customers
Download Buy

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Email-based features

Some security-related features provided by PHP Generator for MySQL like self-registration and password recovering are based on sending email messages to users of generated sites. This chapter explains how these features work and what is required from the site developer for their support.

 

Users table extension

To support email-based features, user table must contain the following columns (besides columns for storing user names, passwords, and IDs that are required to support table-based authentication basically):

 

Default name

Data type

Description

user_email

character varying(255)

Email address of the user

user_token

character varying(255)

Internal data for verification and password recovering

user_status

integer

Status of the user. Possible values are as follows:

0 - registered user

1 - user awaiting verification

2 - user requested password reset

 

 

Enable self-registration

If this option is turned ON, users can register in the generated application.

 

Enable password recovering

If this option is turned ON, users are allowed to reset their passwords.

 

Customizing email messages

Email messages to be sent to the user on the registration and password recovering can be customized with the OnGetCustomTemplate event.

 

Outgoing mail settings

A set of settings to be used to send emails from the generated website. These settings can be also specified in the Project Options dialog. See also Setting up common SMTP servers.

 

 

Events

A number of events help you to control user registration and password recovering processes in the most flexible way possible. The following events are currently available:

 

 



Prev Return to chapter overview Next