 DBQ is a form generator and query manager that works with any database.
DBQ automatically creates forms for selecting, updating, inserting, or deleting data in MySQL, Oracle, DB2, or any other database.
Input submitted using the form is checked and validated before interacting with the database.
A template system allows you to customize the appearance of the form and the presentation of data.
The standard release offers the following features:
* Support for all SQL databases and queries;
* Support for all XHTML input types;
* Generate list inputs based on existing data in the database;
* Validate user input based on input size, character type, and conditionality
* Reuse form elements in multiple queries;
* Custom title, hint, and error messages for all form elements;
* Support for multiple languages.
A professional extension can be purchased to offer additional features:
* Send notifications by mail during query execution;
* Format result columns to be more readable by users;
* Create links to other DBQ queries using the result data;
* Execute multiple SQL queries via a single DBQ query;
* Preload data into the form;
* Restrict the viewing of specific data fields to users who are members of a specified group.
Scenarios – Putting DBQ to Work
- A client wants to search a table within the Joomla database. Create a SELECT query to search this table based on user-defined criteria and present the list of results with navigational aids.
- Your organization uses an external accounting system running on an SQL database. Stakeholders want to be able to view a summary of expenses at any time. Create a SELECT query using SUM and GROUP BY to provide a report via the website.
- A local professional group would like people to complete a survey consisting of select and text boxes. The database is located on a remote machine. Some fields are required but others are not. Additionally, information such as the user’s IP address and, if registered, username and name should be recorded. Create a database connection to the remote database and an INSERT query that will use several DBQ variables to prompt for the user’s input. Write snippets of PHP code to extract the IP and user name so that this information can be recorded as well.
- A company wants an application where a manager selects a list of clients, then clicks on a client’s name to view, edit, or delete the client’s record. Create the required queries and use DBQ Professional to create links between the queries.
Development
The newest release of DBQ provides experimental support for non-XHTML outputs, such as XML. This feature will be fully implemented in Joomla 1.5.
Support & Documentation
This component is extremely flexible, but basic SQL knowledge is required to use this component.
A comprehensive tutorial and new documentation is available for download on the website. Support is provided via the forum.
Joomla 1.5
Users of the new Joomla 1.5 framework will want to look at Logos Query Manager, also listed on the extensions website in the Forms category.
Report this listing
| Great Component by justlovejoomla, April 4, 2008 |
|
It has taken me a little time to get my head around this component, and I previously had no SQL programming experience so I have had to learn on the fly - but this is a great component and well worth the effort. There is a comprehensive tutorial to work through (took me about a day) and an online forum - in which Toby provides prompt answers to questions - I have purchased the professional version and have no regrets.
I am setting up a searchable, in parts editable web interface for an SQL database. In addition, I am planning to program some queries to make various calculations.
There are some limitations with this program - e.g. it appears not all SQL functions are easy to get working / supported and the results layout is a little inflexible - but I believe with a bit of time and effort, you can work around this. Also I am aware that the new version for J1.5 may have improved in some of these areas.
Overall - it's excellent. |
| DBQ Pro by stevsurf, October 27, 2007 |
|
1 of 1 people find this review helpful:
DBQ Pro is used by the Sybil Campbell Library Trust to give their site visitors the opportunity to search the Library's catalogue in a variety of ways. The searches are fast and results are neatly presented. |
| Link in practically any database data by davidmd, July 23, 2007 |
|
1 of 1 people find this review helpful:
I have been using this component for about 3 weeks now and had to take some time to write a review. This is by far the best database linking component for Joomla.
Once you figure out how to link in the backend databases setup your customized templates and add your categories you can put your data anywhere you want!
A mistake I made was linking to a menu directly within the categories - that does not work. You need to manually add the DBQ Manager component as a link on a menu within the Joomla menu manager. Then you customize by opening the menu item.
Overall this one deserves an award for the level of professionalism involved. No negatives unless of course you are shaky on how SQL databases work. Then you may need to spend some time figuring things out.
Excellent work!!!! |
| Great for building a data driven website by cyrusuncc, July 12, 2007 |
|
1 of 1 people find this review helpful:
I was searching around for a good piece of software that would allow me to create an easily manageable data driven site. I found DBQ and gave the free standard version a try. It works well enough, but i needed the extra features of the Professional edition. I've since purchased the professional version and am on my way to completing my project.
Highly recommended! |
| good by akaghzi, June 30, 2007 |
|
good when it works, but sometime it does not.
i tried to enable debugging but then at the end it says:
"Query executed but a false return status was returned for query "
and Unable to execute your query .
now that does not help, does it?
and i using very simpe sql:
SELECT firstname AS first_name,
lastname AS last_name
FROM jos_comprofiler
WHERE approved =1
AND confirmed =1
AND banned =0
I have checked the variables and they are all set. Owner's reply: More specific error information is always reported in the DBQ Error Log. I don't see any reason why the site user needs to know your database structure. :) |
| DBQ Database component by jbacky, June 2, 2007 |
|
This component works as promised. You do need to have a pretty good knowledge of SQL, as it is based on queries. Other than that it is not too difficult to pick up. It works very well within the Joomla framework, and is quite customizable. The documentation is good, and it comes with a good tutorial as well. Tech support is provided through a message board, and I found it to be excellent. The developer was very helpful and responded quickly. I would highly recommend this extension to anyone wanting to put together a database application within the Joomla framework. |
| Fantastic Solid Component by wisdom, April 26, 2007 |
|
1 of 1 people find this review helpful:
I wish every Joomla component worked this way and had such great support.
I started with the free version but very quickly upgraded to the pro version, the cost is well worth the extra features you get.
support from Toby is excellent and he manages to reply to every post you make on the forum.
the only issues i had were server related and i even got support fixing these.
highly recommended
-Dan |
| DBQ review by dbusher, March 25, 2007 |
|
1 of 1 people find this review helpful:
DBQ has allowed us to do rapid site development even though we had very little knowledge of SQL or PHP. We were able to get our site up for user testing within
2 months…1 month earlier then expected. I recommend DBQ for anyone with the need for forms and db query results.
PROs:
Great tutorial to jumpstart your db needs.
Fantastic support by the DBQ developer and engineers. Really couldn’t have done this without them.
DBQ itself is very powerful and intuitive…which is important if you have very little knowledge of SQL or PHP.
CONs:
If you needs exceed the basics outlined in the tutorial it can be done but there is very little documentation on how to do it. The DBQ team do their best to point you in the right direction so expect to do some hacking on your own.
Not many Con’s really. Good product and support for the price. |
| DB Query by Rayo, March 2, 2007 |
|
Good tool. Saved me lots of time formatting and displaying data on a web site. The documentation is well organized and formatted, but I wanted a few more examples. It took me a while to read through all the documentation and play with it, but now that I understand it, it's working well.
I got great support on the developer's forum.
I had to add some php code to get the output formatted the way I needed, but it's very flexible and customizable once you understand the structure. The components are well organized.
Overall it saved me lots of time. |
| A Most Excellent Component by DJHollingworth, February 26, 2007 |
|
1 of 1 people find this review helpful:
Having written a prototype component to produce a single table of data from my MySQL database I then discovered DBQ and found it could do everything for me! As well as querying and displaying the data it will build forms to allow users to enter search or other criteria and so can be used to develop web based applications.
The free component provides most of the features you'd want to use; but for a fee the Professional version provides all the bells and whistles too, like the ability to preload data into the form. It also comes with a professional template that provides a much more attractive rendering of the results as well as enhanced sorting and filtering. Of course you can develop your own display templates if you want; but this just about does it all.
I only had one niggle and that was with the Professional template. When I tried to run this I initially got back a lot of 'Errors' from PHP. TCP (DBQ author) pointed out that these are not 'errors' but are 'Notices' from PHP that there's things like variable type mismatches in the PHP code. Basically this was due to running the template on PHP5, the notices can be disabled from the PHP configuration files. However I spent a long time actually debugging the template code to remove these to avoid having to turn notices off in PHP.
Having said that I still class this an excellent component. Now that it's fully working the features are extensive and most impressive. |
| Bad install by malinusmaximus, January 25, 2007 |
|
0 of 2 people find this review helpful:
Component installed but recieved errors when visiting the component page.
Would not recommend.
These installs should be completely tested before making public and should work. |
| Excellent Component and Excellent Support! by icedewd, December 31, 2006 |
|
4 of 4 people find this review helpful:
So i downloaded this component as i am working on a site called and I was trying to write a component for a Top Dyno Bragging page. What i wanted was a way for the user to be able to submit their own Dyno Charts and be integrated into joomla. I wrote the code in php and did all the db queries by hand but i am not familiar enough with Joomla to grab the userid and the permissions to allow this to happen... So i found something called FacilForms. That wasted about 2 days of my time tying to figure that out. Then i got DBQuery. I printed the documentation and the Dealerships tutorial then within about a hr or so i had my dealership application up and running. I am not too up on all the mysql and php since i am using Joomla and just with following the example i was able to get the dyno chart up and the users submission up and going. This form integrates with Joomla's security so when a user sumbits a dyno entry they have to first be registered then it stores the Joomla User ID in the database. This is excellent and i know that i will be able to use this on so many more projects.
The reason that i wrote this review is not just because the component is so nice but because Toby is all over the forums on his site. He is taking a lot of time to answer the questions on his forum. Without this support there would be a lot of people that may get frustrated and give up... Thanks Toby for the nice tool and the EXCELLENT SUPPORT!!! |
| Very Intuitive by John Tom, December 30, 2006 |
|
1 of 1 people find this review helpful:
I loved reading reviews, but never usually write one. With DB Query I just had to! I'm ok with finding the queries i need to build out of database, so i have no problem there. I use SQLyog to connect to my DB, build the query i need, then just paste it into my DBQuery field(with a little formatting of course)! The Documentation should suffice anyone wanting to know how it works, but you must take the time to read it! In about 15 minutes i build my query and had it displaying on my website the way I want it to, plus i'm playing around with formatting now! What would take me a least a couple of days to figure out(building the query, and formatting the displays using PHP) took me 15 minutes. Talk about ROI (investment in this case is downloading & installing). I will go for the professional version based on what i've seen in this release, and i would recommend you do the same too-if you have the for the extensions description. I've read comments saying one has to be fairly versed in SQL DB's but the ol "SFW" worked for me i.e. SELECT ThisColumn, ThatColumn, AnotherCol,
FROM ThisDatabase WHERE ThisDataHasThisCriterium.
Should be easy enough to do... right? |
| Database Query Pro Amazing by encodi, December 10, 2006 |
|
3 of 3 people find this review helpful:
I was doubtfull about using this component, so i joined the homepage and read some about it, --hmm ok-- i said, --let's try it out-- And i did what i will never regret, i downloaded DBQ for joomla. And WoW!! what a really good component for joomla is this, i even got the Professsional version. It can help you to do a lot of stuff with your joomla databases without even playing around with any code. You just need basic knowledge of MySQL and read the tutorial .pdf on the homepage and you are ready to go!
Really good component. |
| The Best ! by kactds, November 25, 2006 |
|
3 of 3 people find this review helpful:
Just can't rave enough about this excellent tool for database data presentation and manipulation and the exceptional indepth support provided by the developer of the component and forum members! Have yet to come across any Joomla components in this category that provide anything near DBQuery's functionality. The Professional edition is an extremely worthwhile investment and comes with an example application that allows for the viewing,addition and modification of data that is an excellent framework for developing custom applications. |
<< Start < Prev 1 2 3 Next > End >>
Results 1 - 15 of 31
|
component
language
