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

Subscribe to our news:
Partners
Testimonials
Charles Phillips: "I very much like the program and all of its functionality! Would be happy to give you an endorsement or recommend it to others - saves me a ton of time".
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

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

Custom Password Encryption

PHP Generator for MySQL comes with built-in support of a number of reliable and strong algorithms for password encryption; however, you can define your own functions for encrypting and verifying the passwords. This allows you to use any encryption algorithm API or library you like.

 

To define a custom password encryption algorithm, select "Custom" in the Password Encryption field, then press the ellipsis button and provide two PHP functions for encrypting and verifying the password accordingly.

 

 

function OnEncryptPassword($password, &$result)

 

This function accepts an unencrypted password in the $password parameter and returns the encrypted password in the $result parameter that is passed by reference.

 

function OnVerifyPassword($enteredPassword, $encryptedPassword, &$result)

 

This function accepts an unencrypted password entered by the user and an encrypted password stored in the database. The $result parameter must be set to true if the entered password has been verified successfully and to false otherwise. By default this function encrypts the entered password with the OnEncryptPassword function call (see above) and compares the result with the encrypted password, so you should define the OnVerifyPassword function explicitly only if the default behavior is not suitable for your needs.

 

 

Example

The example below shows how it is possible to use the PHP Native password hashing API for encrypting and verifying the password.

 

The OnEncryptPassword function should be defined as follows:

 

$result = password_hash($password, PASSWORD_DEFAULT);

 

As we need to call a separate function for the password verification, the OnVerifyPassword function should be provided as well:

 

$result = password_verify($enteredPassword, $encryptedPassword);



Prev Return to chapter overview Next