PHP Generator for MySQL FAQ
You are welcome to look through the following Frequently Asked Questions list for getting to know the answers to the most commonly asked questions about PHP Generator for MySQL.
If you want to ask a question which is not in the list you may apply to our support team.
What is PHP Generator for MySQL?
PHP Generator for MySQL is a powerful MySQL GUI frontend that allows you to generate PHP scripts for working with tables, views and queries through the web. The final scripts provide all the features you would expect from a professional web database application: data navigation, data editing, sorting, filtering, exporting, etc.
What is the difference between Freeware and Professional versions of the PHP Generator for MySQL?
How can I create a template with PHP Generator for MySQL?
It is easy to create the template using the wizard. Just click the More button at the last wizard step and select the Save Template item to save the current configuration.
Is it possible to create web pages with html logos and navigation menus using your software?
Yes, you can generate web pages designed according to your needs using the Header&Footer tab at the Customizing HTML appearance step of PHP Generator for MySQL.
Is it possible to edit php code generated by PHP Generator for MySQL?
Of course you can modify the generated code but we do not provide any support on this.
I installed PHP Generator for MySQL and generated a first script, but it produces just a blank page.
Add the following lines into the generated .php file (immediatelly after <?php):
Listing 1.
error_reporting(E_ALL ^ E_NOTICE);
ini_set('display_errors', 'On');
Then run your script again to see a more useful error message.
When I try to access a generated PHP script file via my browser, I get the following error message: Warning: include(templates_c\%%56^567^567072C6%%page.tpl.php) [function.include]: failed to open stream: No such file or directory in \libs\smartylibs\Smarty.class.php on line 1152.
Make sure that both templates_c folder and PHP temporary folder (session.save_path directive in php.ini) are writable by the web server user.
To determine which user account is used by Internet Information Services (IIS), follow these steps:
- In the Windows Start Menu choose "Run:", type "inetmgr" and click "OK";
- Expand the list of web sites under the "Web Sites" node in the tree view, right-click on a web site that is being used and select "Properties";
- Click the "Directory Security" tab;
- Take note of a "User name:" field in the "Authentication Methods" dialog.
Does your software support lookup options?
Yes, it does. Moreover, lookup menus are generated automatically if your database contains the appropriate foreign key constraints.
How can I determine the total number of records in the table/view/query using a PHP script created with your product?
Use the mouse hint for the page numbering area:

Does PHP Generator for MySQL support the new authentication protocol implemented in MySQL 4.1/5.x?
Yes, it does. PHP Generator for MySQL supports all the latest versions of MySQL.
What should I enter as 'host' when connecting to a MySQL server?
You may enter a domain name or an IP address as well.
To get your own IP, use the ipconfig utility. Examples are:
localhost, 245.139.237.146, www.yoursite.com.
What are system requirements for installing your software?
- Pentium PC or higher;
- Windows 9x/ME/NT4/2000/XP/Vista/Windows 7;
- 64 MB RAM (128 MB recommended);
- 15 MB of free hard disk space;
- SVGA-compatible video adapter.
- PHP version 5.0 or greater
How can I find out the date of my current product version release?
What is about data security during the server connections with your product?
With connection to intermediate SSH server (when all MySQL commands are forwarded through the secure tunnel) support implemented, PHP Generator for MySQL is an attractive variant for those who consider security seriously.
I want to connect to the server via SSH tunnel and I have a public-private key pair that works fine with PuTTY. However when I test the connection, I get an error message "Key is broken".
PuTTY uses its own format to store private keys while our products support private keys stored either in OpenSSH or ssh.com formats. To convert keys from one format to another, use the PuTTYgen utility that can be freely downloaded from the PuTTY website.