DMXzone Database Connector Manual

Before you begin

In our previous tutorial, you learned how to display your database records, inside a repeat region on your page. So if you still don't know how to do that, make sure to check it out. We created an empty details page and we are going to make a filtered database query for this page as we need to display detailed information about a specific product.

Create an action file

Open the details page and right click the folder (1), located in the server connect panel, that we've created in our previous tutorial, to add an action file (2).

Add action file name

Add a name for this action file. We name it product details.

Add a variable

Now, open Globals option (1), under the server action steps, right click on GET (2) and add a variable (3). We will use this variable, in order to filter our database query.

Add variable name

Add a name for this global variable. We name it filter.

Add database connection

Now, right click steps (1) and select database connection (2), under the database actions menu.

Select the database connection

Click the open existing connection button (1) and select the database connection (2), that we've already created in our previous tutorial.

Add database query

Right click the database connection step (1) and add a database query (2) from the database actions menu.

Add a name and access the query options

Add a name for this database query (1) and click the query options button (2).

Define the source

Select the database table (1) that you want to use and add it to the query (2). Choose the database table columns (3) that you want to use and add them too (4).

Add filters

From the filters tab (1), select the column (2) that you want to filter your query by (3).

Add filter condition

For the filter condition we use equals (1). Now, click the HTML5 Data Bindings picker(2) to add the filter value.

Add filter value

We will use the global variable, that we created earlier, so expand globals (1) and you will see the filter variable under get. Choose it (2) and click the select button (3).

Confirm the filters

Click the OK button.

Save your action file

Before we continue to the next step, make sure to save your action file.

Create URL parameter

The next step is to create an URL parameter. We will bind this URL parameter value, to the filter global variable, that we created earlier. Select URL in the HTML5 Data Bindings panel and click the add new button (2). Enter a name for the URL parameter. We enter ID, as we will filter the products by their ID (3). When you're done, click OK.

Create server action executor

Click the server connect action executors in the HTML5 Data Bindings panel and click the add new button (2).

Manage the executor

Add a name for the executor (1), select auto run on DOM ready (2), choose the details action file (3) and the send method should be set to GET (4).

Bind the data on the page

Expand the product details action executor (1), where you'll find the filtered query, inside the data element, in the executor tree. We do not need a repeat region on the details page, as we will only show a single product here. So just select the bindings (2), which you want to place on the page and click insert (3).

Don't insert a repeat region

A notification, asking you if you want to insert a repeat region appears. Select cancel, as we do not need a repeat region now.

Add more bindings

Add as many data bindings, as you need. When you are done adding data bindings on the page, switch to the index page, where all of your products are listed.

Add hyperlink

Here, we will add a dynamic link, which will redirect our users to the details page. Click inside the repeat region (1) and from the insert menu (2), select hyperlink (3).

Customize the hyperlink

We enter - view more, for the hyperlink text (1). Browse for the details page (2) and add the following after the link to the detail page: ?ID=, followed by the data binding, holding the product ID, that you want to send to the details page (3). For our tutorial it should look like this: detail.php?id={{productCode}}. Click OK when you're done.

Save and preview

Clicking on any of the view more buttons, redirects you to the details page, where you can see the details of the selected products. You can see that the data is filtered by the URL parameter, which we pass from the index page. That's how easy it is to create a details page and filter it by an URL parameter.