Database Query (DBQ) is a popular form and report generator for Joomla 1.0, used to integrate local and remote databases into a Joomla website and to build simple applications.

What makes DBQ special is its ability to integrate SQL statements using variables that one places in an SQL query. Controls over user input ensure that access is controlled and safe. The input accepted by these variables can be restricted by length, character type, and predefined values and default values can be specified.

DBQ offers several features useful to site administrators. It records the input submitted by users for statistical analysis, provides facilities to view errors, and offers a system of templates that can be customized to meet any needs. Look and feel can be customized using style sheets, templates, and a multifold of attributes and parameters that alter the component's behavior.

Database Query can execute any SQL statement, making it a very versatile and powerful component. DBQ supports a number of features that will improve your Joomla website.

• Support for any SQL query;
• Easy setup of database connections and queries using a web interface;
• Ability to connect to most popular SQL and ODBC databases using one of several interfaces;
• Strict control over user input via variables in the SQL query;
• Intuitive frontend screens permitting multiple XHTML input types;
• Ability to populate list inputs with data from the database;
• Support for custom templates and multiple languages.

The newest version of DBQ, 1.4.1, offers a number of new features including the following:

• Improvements to the File Upload variable type that help store files on the webserver;
• An additional variable type, Joomla User, that simplifies access to information about the current website user.

Database Query Professional adds several additional features to the frontend presentation:

• Dynamic checking of input as the user types;
• A JavaScript grid that provides client side sorting and filtering;
• The ability to format data and to generate links to other queries;
• The ability to open a link in a new, unique window.

Database Query Professions comes with a sample application - the Dealership Application. This application allows users to submit and maintain records to be stored in a database. The application is documented in the DBQ Introductory Tutorial and many users have found it to be a great introduction to DBQ's many features.

Visit the Dealership Application demo.

The following screenshots will explain some of the more commonly used DBQ interfaces.

Frontend Form Generation Database Query will generate a form for our query automatically.
Frontend Result Display The results of a query can be displayed in a dynamic grid that can be sorted and filtered on the client.
Query Manager The query manager is used to define queries that will be run on the site. A query can be any SQL statement.
Database Manager Using LQM interfaces it is possible to connect to a wide variety of database systems. By default LQM uses the connection to the Joomla database. In addition you can establish a connection to any MySQL database, even on different computers, and by using the ADOdb interface, you can connect to non-MySQL databases as well.
Variable Manager Variables are the primary means of defining where user input should be inserted into a query and how the result data should be read from the query results.

The current version of Database Query ( DBQ 1.4.1 ) works with the Joomla 1.0 system. It will not work with either Joomla 1.5 or any of the Mambo distributions.

DBQ will run on either PHP4 or PHP5, the latter being preferred.

Some database knowledge is required to use this component - specifically, the knowledge to query a database using the Structured Query Language, or SQL. Knowledge of HTML and PHP will prove helpful for those wanting to exploit the full capabilities of this component.

Database Query Standard

You can download DBQ for free and start building forms today. You should also download the DBQ Users Manual that discusses DBQ's many features.

Download the DBQ Users Manual

Both DBQ Standard and Professional are supported using the forum on the GMITC website. The DBQ Users Manual and Introductory Tutorial offer detailed explanations about how to use both DBQ Standard and Professional.

The DBQ Professional Tutorial is a detailed document that shows you how to use the advanced features of DBQ Pro. Download the DBQ Professional Tutorial.

Download the Database Query Professional Tutorial.

Database Query Professional is a commercial addition that will assist you in creating more advanced applications using the core DBQ component, offering additional options to produce forms or to customize the display of database results. DBQ Pro costs $44 and you can download updates for one year.

DBQ Pro offers several additional features:

1. Send notifications by mail during query execution;
2. Format result columns to be more readable by users;
3. Create links to other DBQ queries using the result data;
4. Execute multiple SQL queries via a single DBQ query;
5. Preload data into the form;
6. Restrict the viewing of specific data fields to users who are members of a specified group;
7. Dynamic checking of input as the user types;
8. A JavaScript grid that provides client side sorting and filtering;
9. The ability to prompt users with a custom message before moving to another query;
10. The ability to open a link in a new, unique window.

To purchase Database Query Profession, please complete the following form.

Support is provided via the site’s forum and there is a forum board dedicated to questions related to DBQ Standard and DBQ Professional. We do not provide support via e-mail.

At the moment we are not offering consulting services for DBQ. We are currently focusing on LQM and the new J!1.5 framework.

What is DBQ Pro?

Database Query Professional (DBQ Pro) is an addition to Database Query Standard, which is freely distributed. The primary task of this extension is to automate many of the common tasks that would typically require customization of the display templates using the standard distribution.

What Is Inside the DBQ Pro distribution?

DBQ Pro is delivered as a zip file and contains the following files:

• professional.class.php – The extension file;
• professional_template.zip - The professional template for use with DBQ 1.4.1;
• dealers_table.sql – SQL code to create the dealers table;
• dealers_queries.sql – SQL code to create the DBQ queries;
• Install.txt – Instructions about how to install these files;
• License.txt – The license.

Do I Need DBQ Pro If I Am Using DBQ Standard?

Technically, everything that DBQ Pro does can also be done by customizing templates. DBQ Pro simply automates many of these common tasks without requiring one to customize any templates.

How Much Does DBQ Pro Cost?

The extension costs $44. This also entitles you to download LQM 1.x for free.

How Do I Purchase DBQ Pro?

You can purchase it using the store using your credit card or PayPal account. Bank and Western Union transfers are not accepted.

Can I Purchase DBQ Pro Using a Credit Card?

Yes. Use the PayPal payment method. When you arrive at the PayPal site, click the Continue button under the text "Don't have a PayPal Account".

Will DBQ Pro 1.4 Work with Joomla 1.0?

Yes. If you want to be certain, install and test DBQ Standard on your system first.

Will DBQ Pro 1.4 Work with Joomla 1.5?

No, it will not work with this new version of Joomla. Use LQM instead. Customers who purchase DBQ Pro can receive LQM 1.x for free.

Once I Purchase DBQ Pro, How Do I Receive It?

After the transaction has been processed, you will receive a download link by mail. Usually this link is mailed to you immediately. If there are any problems, please e-mail us at consulting@gmitc.biz .

Can I upgrade to LQM after I purchase DBQ Pro?

Logos Query Manager 1.x has been made available to those who purchased DBQ Pro. As of March of 2008, however, LQM 1.x is no longer the most recent version. Those wanting to work with the Joomla 1.5 system are recommended to purchase LQM and receive a one-year subscription to LQM updates.

How Do Non-Profit, Charitable Organizations Request a Free Copy of Database Query?

Due to changes in Joomla's attitude towards 3^rd Party Extensions, this service has been suspended.

Database Query Standard is licensed under the GPL and LGPL and is free to download and use.

Database Query Professional is a commercial library and its redistribution and usage, in whole or in part, is restricted by the license agreement. By purchasing, installing, or using this library, you are agreeing that its distribution and usage complies with laws in your country.

Database Query Standard and Professional are provided "as is". Although GMITC has an excellent reputation for helping users on the forum, purchase of this software does not imply any official support obligations. One may request support via the GMITC forum.