Oracle PHP Generator FAQ

To send a bug report, click the More button at the bottom of the main window, then select the appropriate command from the menu, describe the issue and press the Send report button in the dialog window to send the prepared report with your default email client.

If you have any problem sending the report directly from Oracle PHP Generator, you can save it to a file and then send that file to support@sqlmaestro.com as an email attachment.

Add the following lines into the generated .php file (immediatelly after <?php):

error_reporting(E_ALL ^ E_NOTICE);
ini_set('display_errors', 'On');

To execute a query that does not return results:

$this->GetConnection()->ExecSQL('INSERT INTO ...');

To execute a query that returns a single value:

$one = $this->GetConnection()->ExecScalarSQL('SELECT 1');

To execute a query that returns a result set:

$values = array();
$this->GetConnection()->ExecQueryToArray('SELECT 1 as a UNION SELECT 2 as a', $values);
// $values[0]['a'] == 1;
// $values[1]['a'] == 2;

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:

1. In the Windows Start Menu choose "Run:", type "inetmgr" and click "OK";
2. 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";
3. Click the "Directory Security" tab;
4. Take note of a "User name:" field in the "Authentication Methods" dialog.

Yes, it does. Moreover, lookup menus are generated automatically if your database contains the appropriate foreign key constraints.

Use the mouse hint for the page numbering area:

The current version of MS SQL PHP Generator doesn't support such feature directly, but there is a simple workaround: you can replace the original content of an existing data column with the required link or button using the OnCustomRenderColumn event. For example, to display the "Do something" link referencing to the dosomething.php script file instead of the original data stored in the 'data_field' column, specify the event body as follows:

if ($fieldName == 'data_field')
{
   $customText = '<a href="dosomething.php?id=' .$rowData['id'] .'">Do something</a>';
   $handled = true;
}

In case your table has no column to replace, create a custom query based on this table with an additional stub column.

Probably more convenient support for command buttons will be implemented within one of the next releases.

• Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
• Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.
• Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.
• Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.

First of all, please make sure that you have installed an Oracle client software. Next, you can either copy Oracle libraries from ORAHOME folder to ORAHOME\bin one as described here or specify the OCI.dll location in the command line (for example, changing a desktop shortcut) as follows:

OracleMaestro.exe OCIDLL=<full_path_to_oci.dll>

Example:
OracleMaestro.exe OCIDLL=C:\oraclexe\app\oracle\product\10.2.0\server\BIN\oci.dll

To work with prepared PHP scripts, you need to have the installed OCI8 PHP extension. It is not necessary to be an expert on PHP to enable the extension; moreover, you will not be able to run any Oracle PHP application without this procedure (not only ones produced by PHP Generator). Some useful information is available at the Oracle FAQ and, of course, at the OCI8 Installation Guide. There is also a free book from Oracle. As soon as you get worked the first example, you will also get worked the apps generated by our software.

You can create a new user that can access only tables from certain schemas and connect to the database under that user. We're going to provide a more comfortable way in one of the next versions of the software.