		PHP Generator Modified v 2.6

This version adds support for Informix and Microsoft SQL Server. Also automatic generations history tables in PosgreSQL and "detail" mode in pop-up windows were implemented. An option to do non-editable tables has been added. 



The purpose of this project is creating a universal program working with databases by means of Web.

PHPGem is a program which permits to accelerate creating PHP-scripts for working with tables. PHPGem is also PHP-script. It works with different SQL-servers:

    * PostgreSQL
    * Informix
    * Sybase SQL Server
    * Interbase
    * MySQL
    * Adabas
    * mSQL
    * ODBC

As input values you have to point out the description and parameters of your tables fields (field's name, on/off searching in the field, etc.). The result of the program is another PHP-script which will work with this tables (view table, view/add/edit/delete/duplicate entries, search in the table). PHPGem can work with multi-level tables. A table can be a parent-table with several child-tables.

PHPGem supports the following "permissions": you can specify a level of permission for each table and for each field for each user. Permission levels for tables are: NONE (min level), SELECT, INSERT, UPDATE, DELETE (max level). Permission levels for fields are: NONE (min level), SELECT, UPDATE (max level).

PHPGem also supports images. As binary data depend on your SQL-server, images store in a directory. You can see a small (scale) image in "view table" and "view entry" modes. You can also see the image of original size and scale images (from 4:1 to 1:4).

PHPGem supports sessions (PHP4 only) and SSL.


Installation

1. You have to have Web-server with PHP. It can be Apache of Thttpd.

2. Untar the distribution file somewhere in your HTML-tree of your Web-server.

3. Check that the user of your Web-server run has write-permissions in the newly created directory.

4. You have to edit themes/ *.global files manual (insert all information about your host and SQL-server in it).

5. You have to do manual editing of *.table files (insert all information about your tables in it ) and work with them in phpgem.php3 (in browser go to http://localhost/path/phpgem.php3 and choose necessary file). Possibilities of PHPGem are shown in the examples: ?

For generating of final PHP-scripts choose necessary table-file from phpgem.php3. Also you should choose host and theme information files from phpgem.php3 (they are in theme directory). Files for creating tables on SQL-server will locate in result project directory (.sql file was checked only in PostgreSQL). There is a small description of commands in examples filesand in Table.Description file. Also you should look *.theme and especially jsdemo.theme files for getting more information about all options of PHPGem.

6. About permissions: you can set permissions=on in .table-file. As a result in the result project file there will be added a code which will check user's permissions for all user's operations. All information about user's permissions will be located in permission_tbl for table tbl. PHPGem will generate filename_perm.table and copy it in the root PHPGem directory for working with tables. SQL code for creating it you will get when you select filename_perm.table from phpgem.php3.

7. PHPGem can generate HTML code with images (GD library is required for this). Ibutton.php3 program is used for drawing images. The description of ibutton.php3 is in this program. The font for text drawing is loaded from ttf-file. There is a small utility (ttf/ttf_view.php3) for viewing of ttf-file. Use ttf/view_all_ttf.php3 program for viewing all ttf-files in the current directory.

8. You can specify type of links on the page generated by resulting program. Type of links: href (text), form (html form),image (text image), javascriptimage (2 images with different colors of border), buttonimage (image from file). Also you should look into jsdemo.theme file for getting more information about the types of buttons. You can redefine $demo_mode variable in the result program to see the possibilities of the types of links. $demo_mode can be 0-4.


Support

If you need the features below, a program customized to your specific needs or support on PHPGem, our programmers would be happy to help you at very reasonable prices.


Download PHPGem

You can fetch the latest version of PHPGem via HTTP from http://dbware.net.
