Working with Databases | CodeIgniter 2 Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

CodeIgniter 2 Cookbook

By : Robert Foster

3.8 (6)

CodeIgniter 2 Cookbook

3.8 (6)

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.

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

CodeIgniter Basics

CodeIgniter Basics

Introduction

Downloading and installing CodeIgniter

Basic configuration options

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

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

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

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

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

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

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

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

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

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

Configuring CodeIgniter for databases

If you have already configured CodeIgniter to connect with a database, you can skip this part, as all we're going to do is make sure we can connect to a database; to do this, we're going to amend the following two files:

/path/to/codeigniter/application/config/database.php
/path/to/codeigniter/application/config/autoload.php

How to do it...

In the database.php config file, look for the following lines and amend them accordingly:
```
$db['default']['hostname'] = 'localhost'; 
$db['default']['username'] = 'Replace with database username'; 
$db['default']['password'] = 'Replace with database password'; 
$db['default']['database'] = 'Replace with database name'; 
```
The chances are that you'll not need to change $db['default']['hostname'] from the 'localhost', and replace other values (username, password, and database) with the specific values for your environment.
In the autoload.php config file, look for the following line (around line 55):
```
$autoload['libraries'...
```

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

CodeIgniter 2 Cookbook

Search

Your notes and bookmarks