CodeIgniter 2 Cookbook

CodeIgniter 2 Cookbook

By : Robert Foster

Buy this Book

CodeIgniter 2 Cookbook

By: Robert Foster

Buy this Book

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.

CodeIgniter 2 Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

CodeIgniter Basics

Introduction

Downloading and installing CodeIgniter

Basic configuration options

User Management

Generating passwords with CodeIgniter

Generating passwords with CodeIgniter – the bare bones

Forgot password? – resetting passwords with CodeIgniter

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

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

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

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

Creating a Secure User Environment

Introduction

Escaping user input

Preventing cross-site request forgery

Escaping data – for a database

Using HTTPS with CodeIgniter

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

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

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

SEO, Caching, and Logging

Introduction

Using SEO-friendly URLs in CodeIgniter

Using CodeIgniter caching

Logging errors with CodeIgniter

Benchmarking your application

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Finding the last database query

Sometimes, it is useful to know about the last query that was run against the database, either for debugging purposes or for reasons where you wish to have an audit trail of every interaction with the database—you'll be surprised at the number of times you'll need to do this. CodeIgniter comes with a really handy function that you can use to write out the most recent query that CodeIgniter sent to the database.

How to do it...

Add or adapt the following line of code into your controller or model:
```
$this->db->last_query();
```

How it works...

Quite simply, this function will return the last query to be sent to the database; you can place it in the controller or model (even the view if you wish, but it's better to keep it at the logical side of your application rather than the view). It will return the query that you can use as an audit in the form of a string; for example, consider the following line of code:

log_message('level', $this->db->last_query())

The...

CodeIgniter 2 Cookbook

By : Robert Foster

CodeIgniter 2 Cookbook

By: Robert Foster

Overview of this book

Related Content you might be interested in

Current Title:

CodeIgniter 2 Cookbook

Finding the last database query

How to do it...

How it works...