SQL Query

Alexey Ilyin

SQL Query Module

mod_aiixql

This very simple module is for very simple purpose — to display data query results.

What for would you need it? Just imagine, you need to display a contact phone at your site's home page, but you hate (quite reasonably) to duplicate things and would like the phone automatically changes when you change it in the main contact component data. And you know, there is a plenty of similar tasks in site development; they could be done by many different ways, and mod_aiixql is one of them.

You just specify a query and how it has to be echoed to the output buffer. Basically that's all. The output is performed as usual by the two view templates; you can also design your own if you prefer. Please find some help and guidance right in the module admin interface.

In current version SQL Query features:

  • direct programming — no interface overloading;
  • sharing data and handling code among grouped instances — do not do the same twice;
  • the data record class overriding — use your own methods;
  • access level control — specify who can view that;
  • great results with [DOM Master] Plugin.

The module requires a good knowlege of SQL, XHTML and PHP, so it's for experienced users only. Note as well that it accesses the database directly, so it's your own responsibility to configure proper user access levels for each its instance in Module Manager not to disclose any information accidentally.

If you use SQL Query module, please post a rating and a review at the Joomla! Extensions Directory.

How Do I


Related

Discussion: Solution Exchange
Discussion: Need some HELP
Home: DOM Master
Home: Home
Home: SQL Query Advanced
Home: Share Database Request
Home: Use It Generally

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.