O'Reilly logo

Joomla!™ Programming by Louis Landry, Mark Dexter

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

11. Working with Your Database

In this chapter, we discuss the basics of SQL databases and how to work with them in Joomla!. We start with a “crash course” on SQL databases and how to work with a database outside of Joomla using phpMyAdmin. We discuss creating tables and then move on to an overview of SQL queries. Once we understand how SQL queries work outside of Joomla, we look at how queries are built and used inside Joomla. We cover how to use the JDatabaseQuery class to build queries that will work with any supported database. Then we look at how to execute a query and work with the query results inside Joomla.

We will use the MySQL database for our example, but the concepts apply to any SQL database. There are many aspects and subtleties ...

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