eDToolbox 2.0

eDToolbox is the toolbox gathering the PHP scripts needed by any PHP developer. All are documented (in English) in the code and the heading of each one include information necessary to their use.

The toolbox contains various PHP classes:

eDUtilities
A class to ease the debugging of your PHP class, providing easy to use trace and introspection functions for a complete overview of your object and its structure as an HTML table.

eDQuery
A multifunctional class allowing you to build and execute MySQL queries: Externalise and automate your requests for a simplified development of your scripts. Once executed, the results of your request are available in an array of associative arrays, easy to use in your code. A search function also makes it possible to quickly find the value of a field 1 based on a search key (the value of a field 2 for example).

eDMySQLMS
Builds a complete description of the databases, tables and fields on the MySQL server of the host machine. This description is available as two associative arrays, one listing the databases and linking them with the list of their tables, the second list doing the same for the tables and their fields. A search function also makes it possible to check that a database, a table or field exists on the server and in which database and/or table it belongs.

eDGetters
Dynamically builds requests allowing to recover a list of records from a master table and from its associated child tables (linked by foreign keys). This script was built in order to not have to write a line of PHP-MySQL code or SQL in your scripts PHP even when retrieving complex records. Thanks to eDGetters, you can recover in only one go a list of complex records in order to feed a list of choice or an HTML table. It requires the use of precise rules for the construction and the naming of the fields of your tables.

eDObject
The first brick of a database logical abstraction layer. From eDObject, generic scripts will make it possible to automatically generate HTML forms for the creation, the edition of objects and to generate HTML tables for the listing of objects. eDObject will replace eDGetters and remove the need to manipulate your database to handle your objects and records.