CodeIgniter Full Outer Join Example

Introduction In this tutorial I will show CodeIgniter full outer join example. I will build full outer join or full join query using MySQL’s UNION for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which combines the specified rows of tables. If…

Codeigniter Right Outer Join Example

Introduction Here I am going to show CodeIgniter right outer join example. I will use CodeIgniter’s Query Builder Class to build right outer or right join queries for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which combines the specified rows of…

Codeigniter Left Outer Join Example

Introduction Here I am going to show CodeIgniter left outer join example. I will use CodeIgniter’s Query Builder Class to build left outer or left join queries for fetching data from multiple tables. The purpose of a join is to combine the data across tables. A join is actually performed by the where clause which combines the specified rows of…

Codeigniter Join Example

Introduction In this tutorial I will show you CodeIgniter join example. I will use CodeIgniter’s Query Builder Class to build join queries for fetching data from multiple tables. The SQL Join clause is used to combine records together from two or more tables in a database. A Join locates related column values in two or more tables. This will display…

Codeigniter Pagination Example

This tutorial will show you how to generate pagination using Codeigniter. pagination is recommended when you have lots of data coming from database or external sources and you want to show data which do not fit into a single page because it looks ugly and irritating to scroll down the page at bottom. CodeIgniter’s Pagination class is very easy to…

Prevent SQL Injection in Codeigniter

Introduction This tutorial will show you how to prevent SQL injection in Codeigniter application. It is very important to escape the variable you pass to the database query because, in web application security, SQL injections play an important role. SQL injection is: a malicious code injection technique that may destroy your database. one of the most common web hacking techniques….

Upload and Play Video using Codeigniter

Introduction This tutorial will show you how to upload and play video using Codeigniter. The uploaded video may or may not start playing automatically. CodeIgniter’s File Uploading Class permits files to be uploaded. You can set various preferences, restricting the type and size of the files.

Adding Captcha to Database using Codeigniter

Introduction This tutorial will show you how to generate captcha image using Codeigniter Captcha Helper and store captcha characters into database. We have seen how to generate and use captcha in CodeIgniter earlier. The CAPTCHA Helper file contains functions that assist in creating CAPTCHA images.

Captcha using Codeigniter

Introduction This tutorial will show you how to generate captcha image using Codeigniter Captcha Helper. We will also see how to use captcha using CodeIgniter framework. Captcha helps to prevent automatic submission of forms on the web pages. Captcha would not have been there then some users would have filled your site with spams. Here we will build a simple…

Upload and Watermark(Overlay) Image using Codeigniter

Introduction This tutorial will show you how to upload and watermark image using Codeigniter. CodeIgniter’s File Uploading Class permits files to be uploaded. Codeigniter’s Image Library class allows us to process images, such as, crop, resize, rotate, watermark etc. You can set various preferences, restricting the type and size of the files. So here we will upload the image first…