Book Image

CodeIgniter 1.7

Book Image

CodeIgniter 1.7

Overview of this book

CodeIgniter (CI) is a powerful open-source PHP framework with a very small footprint, built for PHP coders who need a simple and elegant toolkit to create full-featured web applications. CodeIgniter is an MVC framework, similar in some ways to the Rails framework for Ruby, and is designed to enable, not overwhelm. This book explains how to work with CodeIgniter in a clear logical way. It is not a detailed guide to the syntax of CodeIgniter, but makes an ideal complement to the existing online CodeIgniter user guide, helping you grasp the bigger picture and bringing together many ideas to get your application development started as smoothly as possible. This book will start you from the basics, installing CodeIgniter, understanding its structure and the MVC pattern. You will also learn how to use some of the most important CodeIgniter libraries and helpers, upload it to a shared server, and take care of the most common problems. If you are new to CodeIgniter, this book will guide you from bottom to top. If you are an experienced developer or already know about CodeIgniter, here you will find ideas and code examples to compare to your own.
Table of Contents (21 chapters)
CodeIgniter 1.7
Credits
About the Authors
About the Reviewer
Preface

Chapter 13. CRUD—or Putting It All Together

The most essential and repetitive part of designing any dynamic site is the CRUD. You have one or more database tables; you need to be able to Create, Read, Update, and Delete entries on each of these. Later, you'll do clever things with the data, but until there is some user-friendly way to put it there and maintain it, your site isn't viable.

This involves writing CRUD functions and though conceptually quite easy, they are fairly complex and time-consuming. But CI will help us make them faster and more reusable. For this example we are going to take our sites table and make some functions to read, insert, edit, and delete. This is a good way of summing up and using many of the lessons that we've learned in the previous chapters.

So we are writing code for:

  • A controller for our sites table, with some functions to read, insert, edit, delete

  • Some views to present the data

  • A model to work with the data

We will also take a look at pagination and ordering...