DevExtreme PHP Data
This library is intended for loading data from a MySQL (mysqlnd is required) database, based on expressions passed from a client by a DevExtreme data source. The library will allow you to implement a data service that supports the protocol described in the following help topics:
If you wish to load data from a MySQL data table based on parameters received from the client side, perform the following steps.
- Copy the DevExtreme folder to your project.
- Include the LoadHelper.php file to your PHP script where you wish to call the DevExtreme PHP Data library API.
- Register the library autoloader by executing the following code:
Since all classes in the library are wrapped in the DevExtreme namespace, use the use operator to get rid of long names in your code. Only two classes are required:
DataSourceLoader. Execute the following code to be ready to use these classes:
use DevExtreme\DbSet; use DevExtreme\DataSourceLoader;
To load data, perform the following steps.
- Create the mysqli instance passing your MySQL server user credentials to its constructor.
- Create the
DbSetinstance passing the
mysqliinstance as a first parameter and a table name from which you wish to load data as a second parameter to the
- Get parameters received from the client side and pass them with the
DbSetinstance to the
Loadmethod of the
DataSourceLoaderclass. This is a static method and you will not need to create an instance of the class. The following code snippet shows how to do this:
$mySQL = new mysqli("serverName", "userName", "password", "databaseName"); $dbSet = new DbSet($mySQL, "tableName"); $result = DataSourceLoader::Load($dbSet, $params);
Note that parameters (
$params) must be passed as an associative array.
That's it. The
$result variable will contain the required results. It will represent an array of items. If you wish to send it to the client to be dislplayed in a DevExtreme widget, convert it to the JSON format. You can use the json_encode function for this task.
The example folder of this repository contains an example that shows how to use the library. To test it:
- copy this folder to your web server folder;
- execute the following command in the example folder;
- Specify user credentials, database name and table name in the php/DataController.php file (see the
DataControllerconstructor) and open the index.html file in a web browser.
DbSet class has the following public methods that you can use without using the
Delete- deletes an item from a data table. It accepts a single parameter that represents a key. The key must be passed as an associative array. For example, if your key is ID and its value is 1, it should be passed to the method in the following manner:
$dbSet->Delete(array("ID" => 1));
The method returns a number of the affected rows.
GetLastError- returns a string representation of the error that was thrown by the last executed SQL query. The method does not accept parameters.
Insert- insert a new row to your data table. It accepts a single parameter that represents an associative array of items. The method returns a number of the affected rows.
Update- updates a certain item in your data table that is identified by a key value. It accepts two parameters. The first parameter represents a key value. It should be specified in the same manner as a key value for the
Deletemethod. The second parameter represents an associative array of values that corresponds to data fields you wish to update. The method returns a number of the affected rows.