DMXzone Database Connector PHP Manual Support
Connect to your database
Access any well known database without any SQL and PHP knowledge in Dreamweaver! This is what the DMXzone Database Connector is all about! Fully integrated visual tools and server code generation are available at your disposal! The extension features a built-in connection wizard where you can define and manage your connections to all well known databases. Choose from ready to go connections for MySQL, Microsoft SQL Server and many others!
The DMXzone Database Connector includes also an amazing Database Source Query Builder that will allow you to build fully visual an advanced query on your database source without any SQL knowledge! It even supports advanced filtering and joins options and lets you directly view and test your database!
The built-in Pagination uses native paging techniques specific for each database so you don't need to do any SQL magic by yourself. It also has dynamic Ajax alike paging, dynamic page navigation links and show/hide regions, which allow you to make a special conditional region of any data repeating element.
This extension requires PHP 5.3+ and PHP PDO. It allows you to connect to any database with PHP PDO without any programming or PHP/PDO knowledge.
NOTE: There is a new version of this extension available: DMXzone Database Connector 2
Highlights
 | No coding requiredIntegrated visual tools and server code generation |
 | Connect to your databaseAccess any well known database without SQL and PHP knowledge |
 | Database source query builderBuild an advanced query fully visually |
 | Built-in pagination pagingNative paging techniques, specific for each database |
Features
Full integration within DMXzone Server Connect
You can use the DMXzone Database Connector's built-in connection wizard directly in DMXzone Server Connect to define and manage your connections to all well-known databases.
Built-in connection wizard
The built-in connection wizard allows you to connect to your database easily and get your data the Ajax way. It comes with full support for wide range of well-known databases and uses specific adapters for each type database so that it can use the native power of the database without bothering you with weird SQL syntax!
Support for standard PHP server types database
The extension comes in PHP, ASP and ASP.NET versions. If you have all three installed in your Dreamweaver you can choose between PHP, ASP and ASP.NET server technology otherwise the field will only display the installed one.
Database source query builder
The integrated Database Source Query Builder comes with full database schema reading support, automatic SQL generator, automatic data types conversion, full data type validation and enforcement and easy table and column pickup.
Table joins
SQL joins are used to combine rows from two or more tables. The Database Connector features inner, left and right joins where you can add more than one table to the Database Source Query Builder.
Powerful built-in pagination
The DMXzone Database Connector has a native pagination built-in! No need to do any weird, database specific SQL magic here, the Database Connector covers your back. It knows all the various SQL Databases and uses a specific paging technique specific to that database. So you always get the most powerful solution without the need of any SQL programming.
George Petrov
George Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. The most popular for its over high-quality Dreamweaver extensions and templates.
George is also the founder of Wappler.io - the most Advanced Web & App Builder