From Delphi for PHP Documentation Wiki

View Data Explorer

Use the Data Explorer to add a new database connection, modify, delete, or rename your database connections. You can browse database server-specific schema objects including tables, fields, stored procedure definitions, triggers, and indexes. Additionally, you can drag and drop data from a data source to a project to build your database application quickly.

Dragging elements such as databases, tables and fields from the Data Explorer to the designers (VCL and HTML) creates a basic database application:

• Databases: Dragging a database to the visual design surface creates a Database component and sets the properties of this component according to the properties set on the connection
• Tables: Dragging a table to the visual design surface creates a Database (or reuses an existing one), a Datasource, a Table and a DBGrid (or the control set in the datasets combo, see below) and all the properties for all the components are set to the right values
• Fields: Dragging a field to the visual design surface creates a Database (or reuses an existing one), a Datasource (or reuses an existing one), a Table (or reuses an existing) and an Edit control (or the control set in the fields combo, see blow) and all the properties for all the components are set to the right values

Use the Datasets combo box at the top of the Data Explorer to select which type of control you would like created when dropping Datasets. A DBGrid is selected by default.

Use the Fields combo box at the top of the Data Explorer to select which type of control you would like created when dropping a field onto the visual designer. An Edit field is selected by default.

[edit] Commands

The following commands are available when right-click in the "Data Explorer":

Item	Description
Register Datatabase	Opens the "Register Database" dialog box where you can enter the information about your database server, connection information, and database name. This also adds the new connection to the "Data Explorer".
Refresh	Refreshes the database information in the Data Explorer
Close Database	Collapses the selected database in the "Data Explorer" tree.
Unregister Database	Unregisters the selected database and removes it from the "Data Explorer".
Modify Database	Opens the Register Database dialog box so you can modify information related to your database connection.