Posts Tagged ‘Connectors’

DHTMLX Integration with Yii PHP Framework

Tuesday, July 10th, 2012

The DHTMLX component library offers a pure JavaScript/CSS solution for building web interfaces. The advantage of developing with the client-side library is that you can use it with your favorite server-side technology. In this tutorial, we will explain how to use the DHTMLX UI components with one of the most popular PHP frameworks, Yii framework.

The tutorial describes how to integrate dhtmlxGrid and dhtmlxScheduler in a Yii application. You’ll learn how to bind the grid and the scheduler to the database and update data on the server when user makes changes on the client side.

The integration with Yii will be done through the dhtmlxConnector layer, which handles client-server data communication. This tutorial gives step-by-step instructions but it is assumed that you have the basic knowledge of the Yii framework and the DHTMLX library.

Download the files of the final demo and keep reading to learn how to use DHTMLX with the Yii framework.

 
Getting Started

Before continuing, make sure that you have Yii installed on your computer. If you don’t, refer to the installation guide to learn how to do it.

Download the packages:

 
In the root folder of your app, create a sub-folder with the name ‘DHTMLX’. Add the required JS/CSS files of dhtmlxConnector, dhtmlxGrid, dhtmlxScheduler, and dataProcessor (included in both dhtmlxGrid and dhtmlxScheduler packages) to the ‘DHTMLX’ folder, or simply copy the folder with the required files from the final demo package (find the download link above).

Thus, you have two folders in the root folder of your demo app: one with Yii files, and the other one with DHTMLX files:

Required files

In our demo Yii app, we use the events database. You can create a local copy of this database by importing the SQL dump file events.sql (find it in the root folder of the final package) or you can just use any available database. Note that if you use your own database, you will need to adapt the code examples by yourself.
 

Read more »

dhtmlxConnector for PHP, Java, ASP.NET Updated to v.1.5

Tuesday, June 12th, 2012

We would like to introduce the update of dhtmlxConnectors for PHP, Java, and ASP.NET. The connectors were developed to simplify data binding between the client-side DHTMLX components and a database on the server. The new version 1.5 brings better security, flexibility, and improved support for dhtmlxScheduler and DHTMLX Touch.

Learn more and download dhtmlxConnector 1.5

Security Improvements

XSS (Cross Site Scripting) is a known security vulnerability of web pages which load the content dynamically from the server-side database. To protect web pages from injection of malicious scripts, version 1.5 of dhtmlxConnector comes with XSS filtering enabled by default. The update also includes server-side protection techniques that prevent CSRF and XSRF attacks.

More Flexibility

With this update, dhtmlxConnector offers additional methods for data rendering. Introducing support for stored procedures calls, we added the ability to retrieve data form the database using the stored procedure.

Another enhancement in version 1.5 is that the connector now can get content from data arrays, which gives you more freedom when choosing the data source to load data from (you can use the connector with non-database data sources).

dhtmlxConnector v.1.5 provides better support for OOP (Object Oriented Programming) that includes support for data model and data behavior classes.

Scheduler and DHTMLX Touch

Working with dhtmlxScheduler, you can now generate data in JSON format using JSONSchedulerConnector class. We have also improved support for our mobile framework DHTMLX Touch by adding dynamic loading capability and implementing the full existing functionality of the main connectors.

To download the new version of dhtmlxConnectors and watch the updated video tutorial, visit this page.

dhtmlxConnector for ColdFusion v1.0

Wednesday, November 24th, 2010

Today we have great news for those who use ColdFusion on the server side! We have released version 1.0 of dhtmlxConnector for ColdFusion. The Connector library provides the ability to bind client-side DHTMLX components to a server-side data source, offering an effective way of Ajax-enabled data communication between JavaScript API and a server back-end (PHP, .NET, Java, and now ColdFusion).

While the DHTMLX library allows you to build a dynamic front-end for your application, dhtmlxConnector minimizes your effort in linking the content of UI components to the database. It works with the following components that need their data to be loaded from a database and saved back, once a user makes changes in the browser: Tree, Grid, TreeGrid, Combo, DataView, Form, Chart, and Scheduler.

Download version 1.0 for ColdFusion or visit this page to learn more about dhtmlxConnector. The package includes examples for all the components mentioned above.