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 ...