Book Image

CodeIgniter 1.7 Professional Development

By : Adam Griffiths
Book Image

CodeIgniter 1.7 Professional Development

By: Adam Griffiths

Overview of this book

<p>CodeIgniter is an open source PHP framework with a small footprint and exceptional performance. It gives you a rich set of libraries for common tasks, with a simple interface to access them. There are several unexplored aspects of CodeIgniter that can help developers build applications more easily and quickly. In this book, you will learn the intricacies of the framework and explore some of its hidden gems.<br /><br />If you want to get the most out of CodeIgniter, this book is for you. It teaches you what you need to know to use CodeIgniter on a daily basis. You will create mini-applications that teach a specific technique and let you build on top of the base. <br /><br />This book will take you through developing applications with CodeIgniter. You will learn how to make your CodeIgniter application more secure than a default installation, how to build large-scale applications and web services, how to release code to the community, and much more. You will be able to authenticate users, validate forms, and also build libraries to complete different tasks and functions.<br /><br />The book starts off introducing the framework and how to install it on your web server or a local machine. You are introduced to the Model-View-Controller design pattern and how it will affect your development. Some important parts of the CodeIgniter Style Guide are included to keep CodeIgniter development as standardized as possible; this helps greatly when working as part of a team or taking on an old CodeIgniter project. You will quickly move on to how CodeIgniter URLs work and learn about CodeIgniter-specific files such as helpers and plugins. By the time you finish this book, you will be able to create a CodeIgniter application of any size with confidence, ease, and speed.</p>

Related Content you might be interested in

Current Title:

Small book image
CodeIgniter 1.7 Professional Development
Adam Griffiths
Apr, 2010 | 300 pages
No titles found
Table of Contents (16 chapters)
CodeIgniter 1.7 Professional Development
CodeIgniter 1.7 Professional Development
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
Preface
Preface
Free Chapter
1
Getting Started with CodeIgniter
Getting Started with CodeIgniter
Upgrading from older versions of CodeIgniter
Downloading and installing CodeIgniter
Introducing Model View Controller (MVC)
Controllers: The business logic
Models: Data abstraction layer
Views: Your template files
Autoloading resources
Formatting your code—PHP Style Guide
CodeIgniter URLs
CodeIgniter specific files
Summary
2
Learning the Libraries
Learning the Libraries
What is a library?
What do libraries do?
Benchmarking Class
Input and Security Class
Email Class
File Uploading Class
Image Manipulation Library
Pagination Class
Session Class
Unit testing a class
Summary
3
Form Validation and Database Interaction
Form Validation and Database Interaction
Why should I validate my forms?
Using the Form Validation Library
Saving sets of validation rules to a config file
Using callbacks
Database interaction
Performing simple queries
Returning values
Result helper functions
Active Record
Active Record caching
Method chaining
Manipulating databases with Database Forge
Summary
4
User Authentication 1
User Authentication 1
Defining our goals
Creating and connecting to the database
Front end code
Model code
Addressing some issues
The Authentication Library
Summary
5
User Authentication 2
User Authentication 2
Using Twitter oAuth
Using Facebook Connect
Summary
6
Application Security
Application Security
CodeIgniter's defenses
Strong password policies
Storing passwords securely
Database security
Cross-site scripting (XSS)
Changing the default file structure
Staying up-to-date
Summary
7
Building a Large-Scale Application
Building a Large-Scale Application
Running benchmarks
Caching
Optimize SQL queries
Avoid disk activity
Run multiple application instances
Summary
8
Web Services
Web Services
What is a web service?
Types of web service
RESTful web service
Create a new post
Update a post
Delete a post
Get a blog post
Summary
9
Extending CodeIgniter
Extending CodeIgniter
Hooks
Extended controllers
Extended libraries
Custom libraries
Helpers
CodeIgniter's hidden gems
Summary
10
Developing and Releasing Code to the Community
Developing and Releasing Code to the Community
Find a need in the community (or fill your own need)
Search for existing solutions
Create a plan
Writing the library
Write a user guide
Release options
Handling database tables
Supporting the code
Summary
Index
Index

Active Record

The Active Record in CodeIgniter is quite different to the AR you may find in Rails or other frameworks. The way that Active Record in CodeIgniter works is that you build up your queries using different functions. For simple queries, you might only need to use one or two functions, but for some you may need to use more—for example, if you have to look for certain conditionals, such as where a username and password are the same.

Selecting data

All of the functions in this section will build SQL SELECT queries. All of the SQL in this section is MySQL; other database systems may differ slightly.

$this->db->get();

The simplest query that you can do with Active Record is to select a full database table. This is done with one single function:

$this->db->get();

This would create the SQL query:

SELECT * FROM `table_name`

This function has three parameters. The first is the name of the database table. The second lets you set a limit, and the third lets you set an offset.

$query...
Previous Section
End of Section 10
Next Section