006. Using the database in the backend

In this chapter we will ...

Now, we want to set up a database table.

Newly created or Modified files

Newly created files

administrator/components/com_foos/Model/FoosModel.php

administrator/components/com_foos/sql/install.mysql.utf8.sql

administrator/components/com_foos/sql/uninstall.mysql.utf8.sql

Modified files

changelog.xml

foo_update.xml

administrator/components/com_foos/View/Foos/HtmlView.php

administrator/components/com_foos/foos.xml

administrator/components/com_foos/services/provider.php

administrator/components/com_foos/tmpl/foos/default.php

All changes at a glance

https://github.com/astridx/boilerplate/compare/t5...t6

More detailed explanations

File Structure

Example in Joomla 4

Side Note

Test your component

Now you can zip all files and install them via Joomla Extension Manager. After that you can see a link to your component in the left side menu. Clicking on this link will open the basic back end view.

Concluding Remark

Now our component has a database table where it can store data. In this chapter we have seen, how we can display this data in the back end. In the next chapter we will go on an check, how we can use the data in the front end.

Now we have . Up to now we have no . We are going to work on this in the next chapter.

Overview of all files