O'Reilly logo

Mastering Joomla! 1.5 Extension and Framework Development by Chuck Lanham, James Kennard

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database naming conventions

When we are working with the Joomla! database, we need be aware of and follow certain naming conventions. If we are creating an extension that will store data in the database, it is important to extend the database correctly. More information on extending the database with components is available in Chapter 5, Component Design.

Database Prefix

When we install Joomla!, we configure the database settings which include the Database Prefix. This prefix (the default is jos_ ) is prepended to every table name when the table is created; its purpose is to allow a single database to manage multiple Joomla! installations.

When we write SQL queries, to accommodate the variable table prefix, we must use a symbolic prefix that is substituted ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required