Generate PHP/JSP Code

SQL4X Manager J generates PHP and JSP code to access your databases and tables with your web browser.

Basic Setup

To create PHP or JSP code you have to define a local root folder and the scripting language for your web site with Tools -> PHP/JSP Code Generator Setup. The Code Generator will create a subdirectory within the root folder to store images and help files needed by the Code Generator. (For details on the PHP/JSP Code Generator Setup see the PHP Code Generator description in the Assistants sections.)

Generate PHP/JSP Code for database lists and input forms

To generate PHP/JSP code to display your table content as a dynamic table in your web page select your table with the Database Navigator and click the PHP/JSP Code Generator icon in the toolbar. You can choose from several options for your lists and input forms as described in the PHP Code Generator documentation in the Assistants section.

View your generated pages

To view your generated pages you need to open them with your web browser. Depending on your setup you need to upload/copy the generated files to your web server or ISP first. The generated pages have to be loaded via a web server or JSP container (not via local file access) to be processed correctly.

Modify the generated pages with Macromedia Dreamweaver MX

The generated pages include the code tags needed by Macromedia's Dreamweaver MX to recognize the database connections, queries, etc. for processing with the Dreamweaver MX graphical tools. This gives you the flexibility for fine-tune the database access and enhance the page layout with Dreamweave MX.

More Information

For a detailed description of the PHP and JSP Code Generator settings and options see the PHP Code Generator description in the Assistants sections.