Database

Edit your SQL queries in PHPEdit's code editor and benefit from its advanced tools:

Syntax highlighting
Code completion for your tables, fields
Code competion for the standard SQL functions

You can add connections to your database very simply with PHPEdit's intuitive "Add connection" dialog. If you need advanced parameters, the advanced dialog allows you to define them.

PHPEdit supports many database systems:

MySQL
PostrgreSQL
SQLServer
SQLite
Firebird
Oracle
ODBC

You can quickly display the content of any of your tables as well as the result of your own queries.

Browse the objects from your database in the Database explorer:

Tables
Fields
Views
Procedures

Design your queries visually by using the Query Builder.

All you need to do a query is to drag and drop your tables, and the links between them, to get the corresponding SQL code generated automatically.

Select SQL queries from PHP code to execute them. PHPEdit will automatically ask you for the test values for dynamic content, like inline variables, or concatenations.