Book Image

Learning Joomla! 1.5 Extension Development

Book Image

Learning Joomla! 1.5 Extension Development

Overview of this book

Table of Contents (17 chapters)
Learning Joomla! 1.5 Extension Development
Credits
About the Author
About the Reviewer
Preface

Chapter 3. Backend Development

Creating and managing restaurant reviews is our component's largest task. We will add forms and database functions to take care of this so that we can start adding reviews. The backend forms will be built according to the Model-View-Controller (MVC) design pattern, to keep our source code clean and organized. Developing the backend now will give us the chance to gather feedback from our restaurant reviewers. Designing this interface will carry us through the following topics:

  • Creating a database table to hold the reviews

  • Coding with MVC

  • Setting up a basic form for data entry

  • Processing the data and adding it to the database

  • Listing the existing reviews

  • Editing records

Creating the database table

Before we set up an interface for entering reviews, we need to create a place in the database where they will go. We will start with a table where one row will represent one review. Assuming that your database prefix is jos_ (check Site | Global Configuration | Server if you...