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

Building our CRUD controller, model, and views


We will start with the controller, so we can load the views from it and see exactly what are we doing. We are going to create the sites controller; if you remember, we have a table like the following one:

CREATE TABLE `sites` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`url` varchar(100) NOT NULL,
`un` varchar(50) NOT NULL,
`pw` varchar(50) NOT NULL,
`client1` int(10) NOT NULL default '0',
`client2` int(10) NOT NULL default '0',
`admin1` int(10) NOT NULL default '0',
`admin2` int(10) NOT NULL default '0',
`domainid` int(10) NOT NULL default '0',
`hostid` int(10) NOT NULL default '0',
`webroot` varchar(50) NOT NULL,
`files` text NOT NULL,
`filesdate` int(11) NOT NULL default '0',
`lastupdate` int(11) NOT NULL default '0',
`submit` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

The first function we will build inside our controller will be the index function. This function...