book

CodeIgniter 2 Cookbook

Name: CodeIgniter 2 Cookbook
Author: Robert Foster
ISBN: 9781782162308

by Robert Foster

December 2013

Intermediate to advanced

306 pages

6h 26m

English

Packt Publishing

Read now

Unlock full access

CodeIgniter 2 Cookbook
Table of Contents
CodeIgniter 2 Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers and moreWhy Subscribe?Free Access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for

Conventions
Reader feedback
Customer support
Downloading the example codeErrataPiracyQuestions
1. CodeIgniter Basics
Introduction
Downloading and installing CodeIgniter
How to do it...
Basic configuration options
How to do it...How it works...Managing CodeIgniter on different environmentsHow to do it...How it works...Managing database settings on different environmentsHow to do it...How it works...Common valuesOther valuesSecuring the system filesHow to do it...How it works...Removing index.php from the address bar using .htaccessHow to do it...How it works...Installing and using SparksHow to do it...How it works...
2. User Management
IntroductionDatabase schema
Viewing users
How to do it...How it works...
Creating users
How to do it...How it works...
Editing users
How to do it...How it works...
Deleting users
How to do it…How it works...
Generating passwords with CodeIgniter
Getting readyHow to do it...How it works...
Generating passwords with CodeIgniter – the bare bones
How to do it...Generating a hashComparing hashed valuesHow it works...
Forgot password? – resetting passwords with CodeIgniter
Getting readyHow to do it...How it works...
3. Creating E-commerce Features
Introduction
Amending configuration settings to run sessions in a database
Getting readyHow to do it...How it works…Categories tableProducts table
Creating a basic cart
How to do it...How it works...User browses the catalogueUser adds an item to the cartUser updates or removes items in the cart
Adding and searching by product categories
Getting readyHow to do it...How it works...
Saving the cart to the database
How to do it...How it works...
4. Email, HTML Table, and Text Libraries
Introduction
Sending plain e-mails with CodeIgniter Email
How to do it...How it works...
Sending HTML e-mails with CodeIgniter Email
How to do it...How it works...
Sending attachments with CodeIgniter Email
How to do it...How it works...
Sending bulk e-mails with CodeIgniter Email
Getting readyHow to do it...How it works...
Using an HTML table with DataTable
Getting readyHow to do it...How it works...
Using an HTML table with DataTable and a database
Getting readyHow to do it...How it works...
Using word_limiter() for table output
Getting readyHow to do it...How it works...
Using word_censor() for cleaning input
Getting readyHow to do it...How it works...
5. Managing Data In and Out
Introduction
Sending different data to multiple views
Getting readyHow to do it...How it works...
Validating user input
Getting readyHow to do it...How it works...
Preparing user input
How to do it...
Sticky form elements in CodeIgniter
Getting readyHow to do it...How it works...
Displaying errors next to form items
How to do it...How it works...
Reading files from the filesystem
Getting readyHow to do it...How it works...
Writing files to the filesystem
How to do it...How it works...
Creating and downloading ZIP files
How to do it...How it works...
Uploading files with CodeIgniter
Getting readyHow to do it...How it works...There's more...
Creating and using validation callbacks
How to do it...How it works...
Using the language class
Getting readyHow to do it...How it works...
Confirming cookie acceptance from the user
Getting readyHow to do it...How it works...There’s more...
6. Working with Databases
Introduction
Configuring CodeIgniter for databases
How to do it...How it works...
Connecting to multiple databases
Getting readyHow to do it...How it works...
Active Record – create (insert)
Getting readyHow to do it...How it works...The public function create()The public function create_batch()
Active Record – read (select)
Getting readyHow to do it...How it works...
Active Record – update
Getting readyHow to do it...How it works...
ActiveRecord – delete
Getting readyHow to do it...How it works...
Looping through the database results
Getting readyHow to do it...How it works...
Counting the number of returned results with num_rows()
How to do it...How it works...
Counting the number of returned results with count_all_results()
How to do it...
Query binding
Getting readyHow to do it...How it works
Finding the last insert id
How to do it...How it works...
Finding the number of affected rows
How to do it...How it works...
Finding the last database query
How to do it...How it works...
Using CodeIgniter database migrations
Getting readyHow to do it...
Moving to the current version with current()
Getting readyHow to do it...How it works...
Rolling back/stepping forward with version()
Getting readyHow to do it...How it works...
Generating an XML from a database result
Getting readyHow to do it...How it works...
Generating a CSV from a database result
Getting readyHow to do it...Forcing downloadHow it works...Saving to fileHow it works...There's more...
7. Creating a Secure User Environment
Introduction
Escaping user input
Getting readyHow to do it...GloballyIndividuallyHow it works...
Preventing cross-site request forgery
How to do it...How it works...
Escaping data – for a database
Getting readyHow to do it...How it works...There's more...
Using HTTPS with CodeIgniter
Getting readyHow to do it...How it works...There's more...Setting up HTTPS on localhost
8. Calendaring, Right Place, and Right Time
Introduction
Building a CodeIgniter Calendar helper with database results
Getting readyHow to do it…How it works…
Building an appointment manager with Calendar Library
Getting readyHow to do it…How it works…The public function create()The public function delete()
Creating a helper to work with a person's date of birth
How to do it…How it works…
Working with fuzzy dates in CodeIgniter
How to do it…How it works…
9. Extending the Core
Introduction
Using CodeIgniter Sparks
Getting readyHow to do it...How it works...
Creating PDFs with the DOMPDF Spark
Getting readyHow to do it...How it works...
Creating Hooks in CodeIgniter
Getting readyHow to do it...
Clearing dead sessions from the database
Getting readyHow to do it...How it works...
Extending your controllers
How to do it...How it works...
Uploading a file with FTP
Getting readyHow to do it...How it works...
Creating libraries and giving them access to CodeIgniter resources
Getting readyHow to do it...How it works...
Making your own configuration files and using the settings
How to do it...How it works...
Using the language class – switching language on the go
Getting readyHow to do it...How it works...
10. Working with Images
Introduction
Installing ImageMagick on MAC with Cactuslab
How to do it...How it works...
Uploading images with CodeIgniter
How to do it...How it works...
Generating thumbnails – resizing
Getting readyHow to do it...How it works...
Rotating images
Getting readyHow to do it...How it works...
Cropping images
Getting readyHow to do it...How it works...Potential errors
Adding watermarks with text
Getting readyHow to do it...How it works...
Adding watermarks with image overlays
Getting readyHow to do it...How it works...
Submitting a form with CodeIgniter CAPTCHA
Getting readyHow to do it...How it works...
11. SEO, Caching, and Logging
Introduction
Using SEO-friendly URLs in CodeIgniter
How to do it...How it works...
Using CodeIgniter caching
How to do it...How it works...Problems you may encounter
Logging errors with CodeIgniter
Getting readyHow to do it...How it works...Logging style
Benchmarking your application
Getting readyHow to do it...How it works...
Index

Content preview from CodeIgniter 2 Cookbook

Looping through the database results

In any application with database connectivity, you'll probably need to display records from a database; looping through rows of data returned from a query is one of the most common tasks you'll perform in programming. CodeIgniter handles looping through database results using PHP for each statement. In this recipe, we will loop through each record at a time, echoing out the relevant information.

Getting ready

To support this recipe, we are going to create a database table and write some data to it. If you already have the data, you can skip this recipe; if not, copy the following code into your database:

CREATE TABLE IF NOT EXISTS `loop_table` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(255) NOT ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9781782162308Other

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

CodeIgniter 2 Cookbook

by Robert Foster

Looping through the database results

Getting ready

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.