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

This extension requires DMXzone Server Connect and DMXzone App Connect
$156.00
- OR -

Highlights

No coding required

Integrated visual tools and server code generation

Connect to your database

Access any well known database without SQL and PHP knowledge

Database source query builder

Build an advanced query fully visually

Built-in pagination paging

Native 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.

Full Feature List

Replace Server Behaviors with DMXzone Extensions (Part 2)

User authentication replaced by DMXzone Sercurity Provider

Replace Server Behaviors with DMXzone Extensions (Part 1)

From the server to the client with DMXzone extensions

Requirements

Type: Data Source
License: External link
Product: Dreamweaver CS6, Dreamweaver CC+
Server Model: PHP 5.3+
Database: SQL Server, MySQL
Platform: Win XP/2000/2003/2008/7, Mac OS X, Mac OS X 10.4+
Used Technologies: jQuery, Ajax
Screen Shot: External link
Tags: database, connector, HTML5, Ajax, SQL, jQuery, PHP

History

Version 1.9.4

  • Removed required dependency of HTML5 Data Bindings. Extension can now be used with DMXzone App COnnect or HTML5 Data Bindings

Version 1.9.3

  • Improved data type handling for PDO and MySQL
  • Improved is not null handling condition

Version 1.9.2

  • Improved handling of complicated database query joins and returning multiple data types for DMXzone Server Connect
  • Improvements for integration with the new DMXzone App Connect

Version 1.9.1

  • Improved conditional expressions in ASP.NET
  • Improved conditional filters in Database Queries in ASP.NET

Version 1.9.0

  • Full compatibility with the new Dreamweaver CC 2017 dark theme
  • Greatly improved for Dreamweaver CS6

Version 1.8.0

  • Improved Connectivity with PDO to SQL Server Native

Version 1.7.2

  • Full support for PHP7
  • Improved connection handling
  • Various minor bug fixes

Version 1.7.1

  • New basic data type: datetime for specific Date and Time storage of both date and time in a databases field. The other types like Date now store date only and time - time only.
  • Fixed some minor connection generation issues in ASP
  • Fixed minor parser issues in the updater
  • Always show linked modules from the current selected site only
  • Improved Mac UI

Version 1.7.0

  • New conditional values! Now you can enter a condition statement for each expression on filters, updates and order by statements so you can conditionally update them as needed!
  • New keyword for date and time field types to populate the value with the current date/time
  • Field types are now also available for all database query statements and are auto-populated based on the database field type
  • Improved UI

Version 1.6.0

  • Improved JSON escaping in database connect generation code
  • Improved PostgreSQL support
  • Improved database joins support

Version 1.5.1

  • Improved JSON escaping in database connect generation code
  • Improved PostgreSQL support in PHP
  • Improved database joins support in PHP

Version 1.5.0

  • Full compatibility with DMXzone Server Connect

Version 1.3.2

  • Improved compatibility with Dreamweaver CC 2015

Version 1.3.1

  • Improved support for LIKE expressions in all database connectors
  • Improved PDO support in PHP as well as fixed bugs in it
  • Improved database data types support

Version 1.3.0

  • Cross site support for connecting mobile apps with dynamic database sites as data sources
  • Improved mobile data bindings support for building dynamic apps with PhoneGap or Cordova
  • Redesigned UI look Update instructions for HTML5 Database Connector:Note you need to reapply all current Database Sources in your site. Just open Site / DMXzone Database Connector / Manage Database Sources ... and then click on "Reapply All". you need to do this for every page and also reapply all behaviors that you're using.

Version 1.2.1

  • Improved database quering
  • Improved for DMXzone Extension Manager
  • Improved for Dreamweaver CC 2014

Version 1.2.0

  • Supports the new include structure for optimal working with HTML5 Data Bindings SEO PHP Update instructions:Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Connector / Manage Database Sources ... and then click on "Reapply All"

Version 1.1.3

  • Full compatibility with HTML5 Data Bindings SEO PHP
  • Database metadata refresh , now also refreshes the views
  • Added version number in the server side source files

Version 1.1.1

  • Improved refreshing of the database structure
  • Fixed database connection generation when custom string is used.

Version 1.1.0

  • Added full support for the new DMXzone Security Provider PHP/ASP for secure database queries
  • Greatly improved storage and caching of database structure info. It is all store now in the connection file so refreshing when database structure changes is really easy.
  • Improved schema refreshing on database query builder dialog
  • Added "Reapply all" buttons to Database Connection and Database Sources Builder
  • Full support for Database Views! Now in the Database Source Query Builder, next to database tables you can also see the database views and use them for your queries.
  • Primary keys in database columns view - Now you can see directly which database columns are used as primary keys on the different icon in front.
  • Fully implemented support for IN and NOT IN operators in Filters working with list of values
  • New Login dialog for providing login information within Dreamweaver when testing secured database sources.
  • Latest jQuery 1.10.2 included Update instructions:Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Connector / Manage Database Sources ... and then click on "Reapply All"

Version 1.0.2

  • Full compatibility with the new DMXzone Database Updater PHP/ASP extension
  • Improvements on the date type fields handling
  • Build-in file updater on page open in Dreamweaver
  • Fully Handle JSONP requests to allow cross domain data exchange

Version 1.0.1

  • Improved error checking on various databases
  • Improved Database structure querying
  • Various minor improvements
  • Fixed SQLite databases connection string

George Petrov

George PetrovGeorge 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

See All Postings From George Petrov >>

Reviews

Be the first to write a review

You must me logged in to write a review.