Book Image

CodeIgniter 2 Cookbook

By : Robert Foster
Book Image

CodeIgniter 2 Cookbook

By: Robert Foster

Overview of this book

As a developer, there are going to be times when you'll need a quick and easy solution to a coding problem. CodeIgniter is a powerful open source PHP framework which allows you to build simple yet powerful full-feature web applications. CodeIgniter 2 Cookbook will give you quick access to practical recipes and useful code snippets which you can add directly into your CodeIgniter application to get the job done. It contains over 80 ready-to-use recipes that you can quickly refer to within your CodeIgniter application or project.This book is your complete guide to creating fully functioning PHP web applications, full of easy-to-follow recipes that will aid you in any aspect of developing with CodeIgniter. CodeIgniter 2 Cookbook takes you from the basics of CodeIgniter, through e-commerce features for your applications, and ends by helping you ensure that your environment is secure for your users and SEO friendly to draw in customers. Starting with installation and setup, CodeIgniter 2 Cookbook provides quick solutions to programming problems that you can directly include in your own projects. You will be moving through databases, EU Cookie Law, caching, and everything else in-between with useful, ready-to-go recipes. You will look at image manipulation using the Image Manipulation library, user management (building a simple CRUD interface), switching languages on the fly according to the user preference, caching content to reduce server load, and much more.

Related Content you might be interested in

Current Title:

Small book image
CodeIgniter 2 Cookbook
Robert Foster
Dec, 2013 | 306 pages
No titles found
Table of Contents (18 chapters)
CodeIgniter 2 Cookbook
CodeIgniter 2 Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
CodeIgniter Basics
CodeIgniter Basics
Introduction
Downloading and installing CodeIgniter
Basic configuration options
2
User Management
User Management
Introduction
Viewing users
Creating users
Editing users
Deleting users
Generating passwords with CodeIgniter
Generating passwords with CodeIgniter – the bare bones
Forgot password? – resetting passwords with CodeIgniter
3
Creating E-commerce Features
Creating E-commerce Features
Introduction
Amending configuration settings to run sessions in a database
Creating a basic cart
Adding and searching by product categories
Saving the cart to the database
4
Email, HTML Table, and Text Libraries
Email, HTML Table, and Text Libraries
Introduction
Sending plain e-mails with CodeIgniter Email
Sending HTML e-mails with CodeIgniter Email
Sending attachments with CodeIgniter Email
Sending bulk e-mails with CodeIgniter Email
Using an HTML table with DataTable
Using an HTML table with DataTable and a database
Using word_limiter() for table output
Using word_censor() for cleaning input
5
Managing Data In and Out
Managing Data In and Out
Introduction
Sending different data to multiple views
Validating user input
Preparing user input
Sticky form elements in CodeIgniter
Displaying errors next to form items
Reading files from the filesystem
Writing files to the filesystem
Creating and downloading ZIP files
Uploading files with CodeIgniter
Creating and using validation callbacks
Using the language class
Confirming cookie acceptance from the user
6
Working with Databases
Working with Databases
Introduction
Configuring CodeIgniter for databases
Connecting to multiple databases
Active Record – create (insert)
Active Record – read (select)
Active Record – update
ActiveRecord – delete
Looping through the database results
Counting the number of returned results with num_rows()
Counting the number of returned results with count_all_results()
Query binding
Finding the last insert id
Finding the number of affected rows
Finding the last database query
Using CodeIgniter database migrations
Moving to the current version with current()
Rolling back/stepping forward with version()
Generating an XML from a database result
Generating a CSV from a database result
7
Creating a Secure User Environment
Creating a Secure User Environment
Introduction
Escaping user input
Preventing cross-site request forgery
Escaping data – for a database
Using HTTPS with CodeIgniter
8
Calendaring, Right Place, and Right Time
Calendaring, Right Place, and Right Time
Introduction
Building a CodeIgniter Calendar helper with database results
Building an appointment manager with Calendar Library
Creating a helper to work with a person's date of birth
Working with fuzzy dates in CodeIgniter
9
Extending the Core
Extending the Core
Introduction
Using CodeIgniter Sparks
Creating PDFs with the DOMPDF Spark
Creating Hooks in CodeIgniter
Clearing dead sessions from the database
Extending your controllers
Uploading a file with FTP
Creating libraries and giving them access to CodeIgniter resources
Making your own configuration files and using the settings
Using the language class – switching language on the go
10
Working with Images
Working with Images
Introduction
Installing ImageMagick on MAC with Cactuslab
Uploading images with CodeIgniter
Generating thumbnails – resizing
Rotating images
Cropping images
Adding watermarks with text
Adding watermarks with image overlays
Submitting a form with CodeIgniter CAPTCHA
11
SEO, Caching, and Logging
SEO, Caching, and Logging
Introduction
Using SEO-friendly URLs in CodeIgniter
Using CodeIgniter caching
Logging errors with CodeIgniter
Benchmarking your application
Index
Index

Generating a CSV from a database result

Perhaps one of the most common things you'll be asked to do, especially if you are building a complex application that may have users, products, orders, and various other metrics is to provide some sort of reporting of that data. Perhaps you'll be asked to generate a CSV file, and the following sections show how you do it.

Getting ready

Firstly, we need to create a table and enter some example data so that you'll see some data in the CSV format, so with that in mind, copy the following code into SQL:

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_first_name` varchar(125) NOT NULL,
  `user_last_name` varchar(125) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_created_date` int(11) NOT NULL COMMENT 'unix timestamp',
  `user_is_active` varchar(3) NOT NULL COMMENT 'yes or no',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

INSERT INTO `users` (`user_first_name`, `user_last_name...
Previous Section
End of Chapter 6
Next Chapter