{"id":144,"date":"2009-12-08T02:59:26","date_gmt":"2009-12-08T10:59:26","guid":{"rendered":"http:\/\/www.dhtmlx.com\/blog\/?p=144"},"modified":"2023-05-09T12:29:17","modified_gmt":"2023-05-09T09:29:17","slug":"dhx-quick-tables-pilot","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/dhx-quick-tables-pilot\/","title":{"rendered":"DHX Quick Tables. Pilot"},"content":{"rendered":"

Update: DHX Quick Tables were deprecated. Now you can use DHTMLX JavaScript spreadsheet<\/a> instead.<\/strong><\/strong><\/p>\n

The latest version of Quick Tables was released on November 5, 2010. To learn more, read this post<\/a> or just download the latest package: Single PHP file installation<\/a> or PHP\/JavaScript sources<\/a>.<\/em><\/p>\n

It\u2019s a first step in our attempt to get the DHTMLX library closer to people who do not want or do not know how to write the code, but need to have something for showing\/updating the data they store in the database. Even programmers sometimes need this to minimize the time spent on routine tasks.<\/p>\n

Wanna Get a Data Table Quickly? <\/strong><\/p>\n

It is based on dhtmlxGrid Standard Edition, dhtmlxLayout, and dhtmlxConnector. The tool is distributed under GNU GPL for free. We call it\u2026 Well, we’re still choosing the name for the “baby”. I\u2019ll call it DHX Quick Tables. After all, it creates tables really quickly…<\/p>\n

So what can it be used for, and how does it work? Let’s say, for example, that you need a back end for your site, which is built on a database. Or maybe you want to show your price list on the site, or any other information stored in the database. You can spend some time building forms and linking them to the database. This is the usual way, but not always necessary. Our solution offers a simpler and faster alternative.<\/p>\n

With Quick Tables, you get the necessary number of web pages with tables linked to the database records. Two access modes are available: for guests (just view the tables) and for the administrator (view, edit, add\/delete pages). Thus, you can put Quick Tables on the back end of your database-driven site and be able to access and update data. Or you can show the resulting table on your website, if tabulated data is what you need. <\/p>\n

Visitors will be able to navigate through a huge number of records (as we\u2019ve added smart rendering to the page), then sort and filter the information. In the next build of the tool, we\u2019ll also add printing and other nice features.<\/p>\n

First Run<\/strong><\/p>\n

OK, first you need to download the installation file and unpack install.php. This is the only file you need. Then upload it onto your site into some folder (PHP support is required, of course). The name of my folder is EH65DBN09G1DF100 (yes, it’s quite complicated), but you can choose any other name for the folder. It doesn\u2019t matter. So put install.php there, and load it through the browser – like this:
\nhttp:\/\/www.yoursite.com\/EH65DBN09G1DF100\/install.php<\/p>\n

The tool will be installed, and the wizard will be loaded right away.<\/p>\n

Wizard Steps:<\/strong><\/p>\n

1. You need to connect the tool to your database. If you have the database, you definitely have connection parameters. So just enter them here:<\/p>\n

\"Quick

Quick Tables - Grid Installation<\/p><\/div>\n

 
\n2. If connection is successful, you\u2019ll get the following screen:<\/p>\n

\"Quick

Quick Tables - Installation<\/p><\/div>\n

 
\nWhen you continue, you\u2019ll need to choose the name for the page and select the database table. Headers and footers are also allowed, but we\u2019ll skip them for now. Also I\u2019ll leave the checkbox not checked to choose the necessary table fields in the next step.<\/p>\n

\"Quick

Quick Tables - Installation<\/p><\/div>\n

 
\nNow choose what fields to show in the table. I choose all, since I don’t have so many to choose from\u2026<\/p>\n

\"Quick

Quick Tables - Installation<\/p><\/div>\n

 
\nNow you define the title for each field, its position, sorting, filtering, and type (editable, read only, checkbox, etc.).<\/p>\n

\"Quick

Quick Tables - Configuration<\/p><\/div>\n

 
\nGenerally, that is all you need to create a page. Click Save and Finish!, and you\u2019ll get this:<\/p>\n

\"Quick

Quick Tables - Application Created<\/p><\/div>\n

 
\nThe first link is for guests. Visitors can look, but not edit. You can use it for your site’s public side, for example. To enter\/update data, use the second link. Here is what you get:<\/p>\n

\"Quick

Quick Tables - GridView<\/p><\/div>\n

 
\nBack to The Beginning<\/strong><\/p>\n

You can access pages through the tool’s control panel. Just browse to the directory you started at. In my example it is http:\/\/localhost\/EH65DBN09G1DF100\/). The control panel works in two modes: Guest (just view the data) and Admin (everything else):<\/p>\n

\"Quick

Quick Tables - Control Panel<\/p><\/div>\n

 
\nTo enter Admin mode, you\u2019ll need to put the code into the text field. The code was shown in the second step. You can see it in conf\/db_config.ini as well. So I entered the code, and now I\u2019m in Admin mode:<\/p>\n

\"Quick

Quick Tables - Admin Mode<\/p><\/div>\n

 
\nAs you can see, here we can add\/delete pages, edit configuration file, or return to the Guest mode. And of course, we can open pages in Admin mode (add\/delete\/update records).<\/p>\n

And again, the goal is to offer a way to build simple applications without needing to be a JavaScript guru or even a professional programmer.\u00a0And this is the first step to the goal.<\/p>\n

Posted by Inga Kravtsova<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"

Update: DHX Quick Tables were deprecated. Now you can use DHTMLX JavaScript spreadsheet instead. The latest version of Quick Tables was released on November 5, 2010. To learn more, …<\/p>\n","protected":false},"author":1,"featured_media":3440,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,71,1],"tags":[33,6,14,26],"class_list":["post-144","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-posts-for-codeproject-com","category-tutorials","category-uncategorized","tag-all-posts","tag-dhtmlxgrid","tag-tips","tag-quick-tables"],"_links":{"self":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/comments?post=144"}],"version-history":[{"count":1,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":10849,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/posts\/144\/revisions\/10849"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media\/3440"}],"wp:attachment":[{"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/media?parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/categories?post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dhtmlx.com\/blog\/wp-json\/wp\/v2\/tags?post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}