Codeigniter

Sample Contact Form with validation, Captcha & Notification

Snippets

Contact Controller

<?php defined('BASEPATH') OR exit('No direct script access allowed');

class Contact extends Public_Controller {

    /**
     * Constructor
     */
    function __construct()
    {
        parent::__construct();

        // load the model file
        $this->load->model('contact_model');
        $this->load->model('notifications_model');

        // load the captcha helper
        $this->load->helper('captcha');
    }


    /**************************************************************************************
     * PUBLIC FUNCTIONS
     **************************************************************************************/


    /**
     * Default
     */
    public function index()
    {
        // validators
        $this->form_validation->set_error_delimiters($this->config->item('error_delimeter_left'), $this->config->item('error_delimeter_right'));
        $this->form_validation->set_rules('name', lang('contacts_name'), 'required|trim|max_length[64]');
        $this->form_validation->set_rules('email', lang('contacts_email'), 'required|trim|valid_email|min_length[10]|max_length[256]');
        $this->form_validation->set_rules('title', lang('common_title'), 'required|trim|max_length[128]');
        $this->form_validation->set_rules('message', lang('contacts_message'), 'required|trim|min_length[10]');
        $this->form_validation->set_rules('captcha', lang('contacts_captcha'), 'required|trim|callback__check_captcha');

        if ($this->form_validation->run() == TRUE)
        {
            // attempt to save and send the message
            $post_data = $this->security->xss_clean($this->input->post());
            $saved_and_sent = $this->contact_model->save_and_send_message($post_data, $this->settings);

            if ($saved_and_sent)
            {
                $notification   = array(
                    'users_id'  => 1,
                    'n_type'    => 'contacts',
                    'n_content' => 'noti_new_message',
                    'n_url'     => site_url('admin/contacts'),
                );
                $this->notifications_model->save_notifications($notification);

                // redirect to home page
                $this->session->set_flashdata('message', sprintf(lang('contacts_send_success'), $this->input->post('name', TRUE)));
                redirect(site_url('contact'));
            }
            else
            {
                // stay on contact page
                $this->error = sprintf(lang('contacts_error_send_failed'), $this->input->post('name', TRUE));
            }
        }

        // create captcha image
        $captcha = create_captcha(array(
            'img_path'   => "./captcha/",
            'img_url'    => base_url('/captcha') . "/",
            'font_path'  => FCPATH . "themes/core/fonts/bromine/Bromine.ttf",
            'img_width'	 => 300,
            'img_height' => 100
        ));

        $captcha_data = array(
            'captcha_time' => $captcha['time'],
            'ip_address'   => $this->input->ip_address(),
            'word'	       => $captcha['word']
        );

        // store captcha image
        $this->contact_model->save_captcha($captcha_data);

        // setup page header data
        $this
        ->add_js_theme( "pages/contact/index.js")
        ->set_title( lang('menu_contact') );

        $data = $this->includes;

        // set content data
        $content_data = array(
            'captcha_image' => $captcha['image']
        );

        // load views
        $data['content'] = $this->load->view('contact_form', $content_data, TRUE);
        $this->load->view($this->template, $data);
    }


    /**************************************************************************************
     * PRIVATE VALIDATION CALLBACK FUNCTIONS
     **************************************************************************************/


    /**
     * Verifies correct CAPTCHA value
     *
     * @param  string $captcha
     * @return string|boolean
     */
    function _check_captcha($captcha)
    {
        $verified = $this->contact_model->verify_captcha($captcha);

        if ($verified == FALSE)
        {
            $this->form_validation->set_message('_check_captcha', lang('contacts_error_captcha'));
            return FALSE;
        }
        else
        {
            return $captcha;
        }
    }

}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

<?php defined('BASEPATH') OR exit('No direct script access allowed');

class Contact extends Public_Controller {

/**

* Constructor

function __construct()

{

parent::__construct();

// load the model file

$this->load->model('contact_model');

$this->load->model('notifications_model');

// load the captcha helper

$this->load->helper('captcha');

}

/**************************************************************************************

* PUBLIC FUNCTIONS

**************************************************************************************/

/**

* Default

public function index()

{

// validators

$this->form_validation->set_error_delimiters($this->config->item('error_delimeter_left'), $this->config->item('error_delimeter_right'));

$this->form_validation->set_rules('name', lang('contacts_name'), 'required|trim|max_length[64]');

$this->form_validation->set_rules('email', lang('contacts_email'), 'required|trim|valid_email|min_length[10]|max_length[256]');

$this->form_validation->set_rules('title', lang('common_title'), 'required|trim|max_length[128]');

$this->form_validation->set_rules('message', lang('contacts_message'), 'required|trim|min_length[10]');

$this->form_validation->set_rules('captcha', lang('contacts_captcha'), 'required|trim|callback__check_captcha');

if ($this->form_validation->run() == TRUE)

{

// attempt to save and send the message

$post_data = $this->security->xss_clean($this->input->post());

$saved_and_sent = $this->contact_model->save_and_send_message($post_data, $this->settings);

if ($saved_and_sent)

{

$notification = array(

'users_id' => 1,

'n_type' => 'contacts',

'n_content' => 'noti_new_message',

'n_url' => site_url('admin/contacts'),

);

$this->notifications_model->save_notifications($notification);

// redirect to home page

$this->session->set_flashdata('message', sprintf(lang('contacts_send_success'), $this->input->post('name', TRUE)));

redirect(site_url('contact'));

}

else

{

// stay on contact page

$this->error = sprintf(lang('contacts_error_send_failed'), $this->input->post('name', TRUE));

}

// create captcha image

$captcha = create_captcha(array(

'img_path' => "./captcha/",

'img_url' => base_url('/captcha') . "/",

'font_path' => FCPATH . "themes/core/fonts/bromine/Bromine.ttf",

'img_width' => 300,

'img_height' => 100

));

$captcha_data = array(

'captcha_time' => $captcha['time'],

'ip_address' => $this->input->ip_address(),

'word' => $captcha['word']

);

// store captcha image

$this->contact_model->save_captcha($captcha_data);

// setup page header data

$this

->add_js_theme( "pages/contact/index.js")

->set_title( lang('menu_contact') );

$data = $this->includes;

// set content data

$content_data = array(

'captcha_image' => $captcha['image']

);

// load views

$data['content'] = $this->load->view('contact_form', $content_data, TRUE);

$this->load->view($this->template, $data);

}

/**************************************************************************************

* PRIVATE VALIDATION CALLBACK FUNCTIONS

**************************************************************************************/

/**

* Verifies correct CAPTCHA value

* @param string $captcha

* @return string|boolean

function _check_captcha($captcha)

{

$verified = $this->contact_model->verify_captcha($captcha);

if ($verified == FALSE)

{

$this->form_validation->set_message('_check_captcha', lang('contacts_error_captcha'));

return FALSE;

}

else

{

return $captcha;

}

Contact_form.php – view

<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

<!-- Section -->
<section class="bg-lgrey">  
    <div class="container">
        <div class="row">
            <div class="col-sm-offset-1 col-sm-4">
                <!-- Title -->
                <div class="title-container sm text-left">
                    <div class="title-wrap">
                        <h5 class="title"><?php echo lang('menu_contact') ?></h5>
                        <span class="separator line-separator"></span>
                    </div>
                </div><!-- Title -->
                <div class="contact-info">
                    <div class="info-icon bg-dark">
                        <i class="uni-map2"></i>
                    </div>
                    <h5 class="title"><?php echo lang('contacts_office') ?></h5>
                    <p><?php echo $this->settings->institute_name ?></p>
                    <p><?php echo $this->settings->institute_address ?></p>
                </div><!-- Contact Info -->
                
                <div class="contact-info margin-top-30">
                    <div class="info-icon bg-dark">
                        <i class="uni-mail"></i>
                    </div>
                    <h5 class="title"><?php echo lang('menu_contact') ?></h5>
                    <p><a href="mailto:<?php echo $this->settings->site_email ?>"><?php echo $this->settings->site_email ?></a></p>
                    <p><a href="tel:<?php echo $this->settings->institute_phone ?>"><?php echo $this->settings->institute_phone ?></a></p>
                </div><!-- Contact Info -->
                
            </div><!-- Column -->
            
            <div class="col-sm-6">
                <!-- Title -->
                <div class="title-container sm text-left">
                    <div class="title-wrap">
                        <h5 class="title"><?php echo lang('contacts_get_in_touch') ?></h5>
                        <span class="separator line-separator"></span>
                    </div>
                </div><!-- Title -->
                <div class="contact-info">
                    <div class="info-icon bg-dark">
                        <i class="uni-fountain-pen"></i>
                    </div>
                    <?php echo form_open('', array('role'=>'form', 'id'=>'form-create')); ?>
                    <div class="input-text form-group<?php echo form_error('name') ? ' has-error' : ''; ?>">
                        <?php echo form_label(lang('contacts_name'), 'name', array('class'=>'control-label')); ?>
                        <span class="required">*</span>
                        <?php echo form_input(array('name'=>'name', 'value'=>set_value('name'), 'class'=>'form-control input-name')); ?>
                    </div>
                    <div class="input-email form-group <?php echo form_error('email') ? ' has-error' : ''; ?>">
                        <?php echo form_label(lang('contacts_email'), 'email', array('class'=>'control-label')); ?>
                        <span class="required">*</span>
                        <?php echo form_input(array('name'=>'email', 'value'=>set_value('email'), 'class'=>'form-control input-email')); ?>
                    </div>
                    <div class="input-text form-group <?php echo form_error('title') ? ' has-error' : ''; ?>">
                        <?php echo form_label(lang('common_title'), 'title', array('class'=>'control-label')); ?>
                        <span class="required">*</span>
                        <?php echo form_input(array('name'=>'title', 'value'=>set_value('title'), 'class'=>'form-control input-text ')); ?>
                    </div>
                    <div class="textarea-message form-group <?php echo form_error('message') ? ' has-error' : ''; ?>">
                        <?php echo form_label(lang('contacts_message'), 'message', array('class'=>'control-label')); ?>
                        <span class="required">*</span>
                        <?php echo form_textarea(array('name'=>'message', 'value'=>set_value('message'), 'class'=>'form-control textarea-message')); ?>
                    </div>
                    <div class="form-group textarea-message <?php echo form_error('captcha') ? ' has-error' : ''; ?>">
                        <?php echo form_label(lang('contacts_captcha'), 'captcha', array('class'=>'control-label')); ?>
                        <br />
                        <?php echo $captcha_image; ?>
                        <?php echo form_input(array('name'=>'captcha', 'id'=>'captcha', 'value'=>"", 'class'=>'form-control textarea-message')); ?>
                    </div>
                    <button type="submit" name="submit" class="btn"><i class="fa fa-send"></i> <?php echo lang('contacts_send_message') ?></button>
                    <span id="submit-loader"></span>
                    <?php echo form_close(); ?>
                </div><!-- Contact Info -->
            </div><!-- Column -->
        </div><!-- Row -->
    </div><!-- Container -->    
</section><!-- Section -->

<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

</div>

</div>

</div>

<p><?php echo $this->settings->institute_name ?></p>

<p><?php echo $this->settings->institute_address ?></p>

</div>

</div>

<p><a href="mailto:<?php echo $this->settings->site_email ?>"><?php echo $this->settings->site_email ?></a></p>

<p><a href="tel:<?php echo $this->settings->institute_phone ?>"><?php echo $this->settings->institute_phone ?></a></p>

</div>

</div>

</div>

</div>

</div>

<?php echo form_open('', array('role'=>'form', 'id'=>'form-create')); ?>

<?php echo form_label(lang('contacts_name'), 'name', array('class'=>'control-label')); ?>

<?php echo form_input(array('name'=>'name', 'value'=>set_value('name'), 'class'=>'form-control input-name')); ?>

</div>

<?php echo form_label(lang('contacts_email'), 'email', array('class'=>'control-label')); ?>

<?php echo form_input(array('name'=>'email', 'value'=>set_value('email'), 'class'=>'form-control input-email')); ?>

</div>

<?php echo form_label(lang('common_title'), 'title', array('class'=>'control-label')); ?>

<?php echo form_input(array('name'=>'title', 'value'=>set_value('title'), 'class'=>'form-control input-text ')); ?>

</div>

<?php echo form_label(lang('contacts_message'), 'message', array('class'=>'control-label')); ?>

<?php echo form_textarea(array('name'=>'message', 'value'=>set_value('message'), 'class'=>'form-control textarea-message')); ?>

</div>

<?php echo form_label(lang('contacts_captcha'), 'captcha', array('class'=>'control-label')); ?>

<br />

<?php echo $captcha_image; ?>

<?php echo form_input(array('name'=>'captcha', 'id'=>'captcha', 'value'=>"", 'class'=>'form-control textarea-message')); ?>

</div>

<?php echo form_close(); ?>

</div>

</div>

</div>

</div>

</section>

Contact_model

<?php defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * Contact Model
 *
 * This model handles contacts module data
 *

*/

class Contact_model extends CI_Model {

    /**
     * @vars
     */
    private $_db;


    /**
     * Constructor
     */
    function __construct()
    {
        parent::__construct();

        // define primary table
        $this->_db = 'emails';
    }


    /**
     * Save generated CAPTCHA to database
     *
     * @param  array $data
     * @return boolean
     */
    public function save_captcha($data = array())
    {
        // CAPTCHA data required
        if ($data)
        {
            // insert CAPTCHA
            $query = $this->db->insert_string('captcha', $data);
            $this->db->query($query);

            // return
            return TRUE;
        }

        return FALSE;
    }


    /**
     * Verify CAPTCHA
     *
     * @param  string $captcha
     * @return boolean
     */
    public function verify_captcha($captcha = NULL)
    {
        // CAPTCHA string required
        if ($captcha)
        {
            // remove old CAPTCHA
            $expiration = time() - 7200; // 2-hour limit
            $this->db->query("DELETE FROM captcha WHERE captcha_time < {$expiration}");

            // build query
            $sql = "
                SELECT
                    COUNT(*) AS count
                FROM captcha
                WHERE word = " . $this->db->escape($captcha) . "
                    AND ip_address = '" . $this->input->ip_address() . "'
                    AND captcha_time > '{$expiration}'
            ";

            // execute query
            $query = $this->db->query($sql);

            // return results
            if ($query->row()->count > 0)
            {
                return TRUE;
            }
        }

        return FALSE;
    }


    /**
     * Save and email contact message
     *
     * @param  array $data
     * @param  array $settings
     * @return boolean
     */
    public function save_and_send_message($data=array(), $settings=array())
    {
        // post data and settings required
        if ($data && $settings)
        {
            // build query
            $sql = "
                INSERT INTO {$this->_db} (
                    name, email, title, message, created
                ) VALUES (
                    " . $this->db->escape($data['name']) . ",
                    " . $this->db->escape($data['email']) . ",
                    " . $this->db->escape($data['title']) . ",
                    " . $this->db->escape($data['message']) . ",
                    '" . date('Y-m-d H:i:s') . "'
                )
            ";

            // execute query
            $this->db->query($sql);

            if ($id = $this->db->insert_id() && $_SERVER['HTTP_HOST'] !== 'localhost')
            {
                try
                {
                    // send email
                    $this->email->from($data['email'], $data['name']);
                    $this->email->to($settings->site_email);
                    $this->email->subject($data['title']);
                    $this->email->message($data['message']);
                    $send_mail = @$this->email->send();
                    #echo $this->email->print_debugger();

                    if ($send_mail)
                    {
                        return TRUE;
                    }
                    else
                    {
                        // send mail failed - remove message from database
                        $this->db->query("DELETE FROM {$this->_db} WHERE id = {$id}");
                    }
                }
                catch (Exception $e)
                {
                    // send mail failed - remove message from database
                    $this->db->query("DELETE FROM {$this->_db} WHERE id = {$id}");
                }
            }
            else
            {
                return TRUE;
            }
        }

        return FALSE;
    }


    /**
     * Get list of non-deleted users
     *
     * @param  int $limit
     * @param  int $offset
     * @param  array $filters
     * @param  string $sort
     * @param  string $dir
     * @return array|boolean
     */
    function get_all($limit = 0, $offset = 0, $filters = array(), $sort = 'created', $dir = 'DESC')
    {
        // start building query
        $sql = "
            SELECT SQL_CALC_FOUND_ROWS *
            FROM {$this->_db}
            WHERE 1 = 1
        ";

        // apply filters
        if ( ! empty($filters))
        {
            foreach ($filters as $key=>$value)
            {
                $value = $this->db->escape('%' . $value . '%');
                $sql .= " AND {$key} LIKE {$value}";
            }
        }

        // continue building query
        $sql .= " ORDER BY {$sort} {$dir}";

        // add limit and offset
        if ($limit)
        {
            $sql .= " LIMIT {$offset}, {$limit}";
        }

        // execute query
        $query = $this->db->query($sql);

        // define results
        if ($query->num_rows() > 0)
        {
            $results['results'] = $query->result_array();
        }
        else
        {
            $results['results'] = NULL;
        }

        // get total count
        $sql = "SELECT FOUND_ROWS() AS total";
        $query = $this->db->query($sql);
        $results['total'] = $query->row()->total;

        // return results
        return $results;
    }


    /**
     * Set email message as read
     *
     * @param  int $id
     * @param  int $read_by
     * @return boolean
     */
    public function read($id = NULL, $read_by = NULL)
    {
        // data required
        if ($id and $read_by)
        {
            // build query string
            $sql = "
                UPDATE {$this->_db}
                SET `read` = '" . date('Y-m-d H:i:s') . "',
                    read_by = {$read_by}
                WHERE id = {$id}
            ";

            // execute query
            $this->db->query($sql);

           // return results
            if ($this->db->affected_rows())
            {
                return TRUE;
            }
        }

        return FALSE;
    }

}

/*Contact model ends*/

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

<?php defined('BASEPATH') OR exit('No direct script access allowed');

/**

* Contact Model

* This model handles contacts module data

class Contact_model extends CI_Model {

/**

* @vars

private $_db;

/**

* Constructor

function __construct()

{

parent::__construct();

// define primary table

$this->_db = 'emails';

}

/**

* Save generated CAPTCHA to database

* @param array $data

* @return boolean

public function save_captcha($data = array())

{

// CAPTCHA data required

if ($data)

{

// insert CAPTCHA

$query = $this->db->insert_string('captcha', $data);

$this->db->query($query);

// return

return TRUE;

}

return FALSE;

}

/**

* Verify CAPTCHA

* @param string $captcha

* @return boolean

public function verify_captcha($captcha = NULL)

{

// CAPTCHA string required

if ($captcha)

{

// remove old CAPTCHA

$expiration = time() - 7200; // 2-hour limit

$this->db->query("DELETE FROM captcha WHERE captcha_time < {$expiration}");

// build query

$sql = "

SELECT

COUNT(*) AS count

FROM captcha

WHERE word = " . $this->db->escape($captcha) . "

AND ip_address = '" . $this->input->ip_address() . "'

AND captcha_time > '{$expiration}'

// execute query

$query = $this->db->query($sql);

// return results

if ($query->row()->count > 0)

{

return TRUE;

}

return FALSE;

}

/**

* Save and email contact message

* @param array $data

* @param array $settings

* @return boolean

public function save_and_send_message($data=array(), $settings=array())

{

// post data and settings required

if ($data && $settings)

{

// build query

$sql = "

INSERT INTO {$this->_db} (

name, email, title, message, created

) VALUES (

" . $this->db->escape($data['name']) . ",

" . $this->db->escape($data['email']) . ",

" . $this->db->escape($data['title']) . ",

" . $this->db->escape($data['message']) . ",

'" . date('Y-m-d H:i:s') . "'

)

// execute query

$this->db->query($sql);

if ($id = $this->db->insert_id() && $_SERVER['HTTP_HOST'] !== 'localhost')

{

try

{

// send email

$this->email->from($data['email'], $data['name']);

$this->email->to($settings->site_email);

$this->email->subject($data['title']);

$this->email->message($data['message']);

$send_mail = @$this->email->send();

#echo $this->email->print_debugger();

if ($send_mail)

{

return TRUE;

}

else

{

// send mail failed - remove message from database

$this->db->query("DELETE FROM {$this->_db} WHERE id = {$id}");

}

catch (Exception $e)

{

// send mail failed - remove message from database

$this->db->query("DELETE FROM {$this->_db} WHERE id = {$id}");

}

else

{

return TRUE;

}

return FALSE;

}

/**

* Get list of non-deleted users

* @param int $limit

* @param int $offset

* @param array $filters

* @param string $sort

* @param string $dir

* @return array|boolean

function get_all($limit = 0, $offset = 0, $filters = array(), $sort = 'created', $dir = 'DESC')

{

// start building query

$sql = "

SELECT SQL_CALC_FOUND_ROWS *

FROM {$this->_db}

WHERE 1 = 1

// apply filters

if ( ! empty($filters))

{

foreach ($filters as $key=>$value)

{

$value = $this->db->escape('%' . $value . '%');

$sql .= " AND {$key} LIKE {$value}";

}

// continue building query

$sql .= " ORDER BY {$sort} {$dir}";

// add limit and offset

if ($limit)

{

$sql .= " LIMIT {$offset}, {$limit}";

}

// execute query

$query = $this->db->query($sql);

// define results

if ($query->num_rows() > 0)

{

$results['results'] = $query->result_array();

}

else

{

$results['results'] = NULL;

}

// get total count

$sql = "SELECT FOUND_ROWS() AS total";

$query = $this->db->query($sql);

$results['total'] = $query->row()->total;

// return results

return $results;

}

/**

* Set email message as read

* @param int $id

* @param int $read_by

* @return boolean

public function read($id = NULL, $read_by = NULL)

{

// data required

if ($id and $read_by)

{

// build query string

$sql = "

UPDATE {$this->_db}

SET `read` = '" . date('Y-m-d H:i:s') . "',

read_by = {$read_by}

WHERE id = {$id}

// execute query

$this->db->query($sql);

// return results

if ($this->db->affected_rows())

{

return TRUE;

}

return FALSE;

}

/*Contact model ends*/

Captcha Helper

<?php
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP
 *
 * This content is released under the MIT License (MIT)
 *
 * Copyright (c) 2014 - 2018, British Columbia Institute of Technology
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 *
 * @package	CodeIgniter
 * @author	EllisLab Dev Team
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
 * @copyright	Copyright (c) 2014 - 2018, British Columbia Institute of Technology (http://bcit.ca/)
 * @license	http://opensource.org/licenses/MIT	MIT License
 * @link	https://codeigniter.com
 * @since	Version 1.0.0
 * @filesource
 */
defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * CodeIgniter CAPTCHA Helper
 *
 * @package		CodeIgniter
 * @subpackage	Helpers
 * @category	Helpers
 * @author		EllisLab Dev Team
 * @link		https://codeigniter.com/user_guide/helpers/captcha_helper.html
 */

// ------------------------------------------------------------------------

if ( ! function_exists('create_captcha'))
{
	/**
	 * Create CAPTCHA
	 *
	 * @param	array	$data		Data for the CAPTCHA
	 * @param	string	$img_path	Path to create the image in (deprecated)
	 * @param	string	$img_url	URL to the CAPTCHA image folder (deprecated)
	 * @param	string	$font_path	Server path to font (deprecated)
	 * @return	string
	 */
	function create_captcha($data = '', $img_path = '', $img_url = '', $font_path = '')
	{
		$defaults = array(
			'word'		=> '',
			'img_path'	=> '',
			'img_url'	=> '',
			'img_width'	=> '150',
			'img_height'	=> '30',
			'font_path'	=> '',
			'expiration'	=> 7200,
			'word_length'	=> 8,
			'font_size'	=> 16,
			'img_id'	=> '',
			'pool'		=> '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
			'colors'	=> array(
				'background'	=> array(255,255,255),
				'border'	=> array(153,102,102),
				'text'		=> array(204,153,153),
				'grid'		=> array(255,182,182)
			)
		);

		foreach ($defaults as $key => $val)
		{
			if ( ! is_array($data) && empty($$key))
			{
				$$key = $val;
			}
			else
			{
				$$key = isset($data[$key]) ? $data[$key] : $val;
			}
		}

		if ($img_path === '' OR $img_url === ''
			OR ! is_dir($img_path) OR ! is_really_writable($img_path)
			OR ! extension_loaded('gd'))
		{
			return FALSE;
		}

		// -----------------------------------
		// Remove old images
		// -----------------------------------

		$now = microtime(TRUE);

		$current_dir = @opendir($img_path);
		while ($filename = @readdir($current_dir))
		{
			if (in_array(substr($filename, -4), array('.jpg', '.png'))
				&& (str_replace(array('.jpg', '.png'), '', $filename) + $expiration) < $now)
			{
				@unlink($img_path.$filename);
			}
		}

		@closedir($current_dir);

		// -----------------------------------
		// Do we have a "word" yet?
		// -----------------------------------

		if (empty($word))
		{
			$word = '';
			$pool_length = strlen($pool);
			$rand_max = $pool_length - 1;

			// PHP7 or a suitable polyfill
			if (function_exists('random_int'))
			{
				try
				{
					for ($i = 0; $i < $word_length; $i++)
					{
						$word .= $pool[random_int(0, $rand_max)];
					}
				}
				catch (Exception $e)
				{
					// This means fallback to the next possible
					// alternative to random_int()
					$word = '';
				}
			}
		}

		if (empty($word))
		{
			// Nobody will have a larger character pool than
			// 256 characters, but let's handle it just in case ...
			//
			// No, I do not care that the fallback to mt_rand() can
			// handle it; if you trigger this, you're very obviously
			// trying to break it. -- Narf
			if ($pool_length > 256)
			{
				return FALSE;
			}

			// We'll try using the operating system's PRNG first,
			// which we can access through CI_Security::get_random_bytes()
			$security = get_instance()->security;

			// To avoid numerous get_random_bytes() calls, we'll
			// just try fetching as much bytes as we need at once.
			if (($bytes = $security->get_random_bytes($pool_length)) !== FALSE)
			{
				$byte_index = $word_index = 0;
				while ($word_index < $word_length)
				{
					// Do we have more random data to use?
					// It could be exhausted by previous iterations
					// ignoring bytes higher than $rand_max.
					if ($byte_index === $pool_length)
					{
						// No failures should be possible if the
						// first get_random_bytes() call didn't
						// return FALSE, but still ...
						for ($i = 0; $i < 5; $i++)
						{
							if (($bytes = $security->get_random_bytes($pool_length)) === FALSE)
							{
								continue;
							}

							$byte_index = 0;
							break;
						}

						if ($bytes === FALSE)
						{
							// Sadly, this means fallback to mt_rand()
							$word = '';
							break;
						}
					}

					list(, $rand_index) = unpack('C', $bytes[$byte_index++]);
					if ($rand_index > $rand_max)
					{
						continue;
					}

					$word .= $pool[$rand_index];
					$word_index++;
				}
			}
		}

		if (empty($word))
		{
			for ($i = 0; $i < $word_length; $i++)
			{
				$word .= $pool[mt_rand(0, $rand_max)];
			}
		}
		elseif ( ! is_string($word))
		{
			$word = (string) $word;
		}

		// -----------------------------------
		// Determine angle and position
		// -----------------------------------
		$length	= strlen($word);
		$angle	= ($length >= 6) ? mt_rand(-($length-6), ($length-6)) : 0;
		$x_axis	= mt_rand(6, (360/$length)-16);
		$y_axis = ($angle >= 0) ? mt_rand($img_height, $img_width) : mt_rand(6, $img_height);

		// Create image
		// PHP.net recommends imagecreatetruecolor(), but it isn't always available
		$im = function_exists('imagecreatetruecolor')
			? imagecreatetruecolor($img_width, $img_height)
			: imagecreate($img_width, $img_height);

		// -----------------------------------
		//  Assign colors
		// ----------------------------------

		is_array($colors) OR $colors = $defaults['colors'];

		foreach (array_keys($defaults['colors']) as $key)
		{
			// Check for a possible missing value
			is_array($colors[$key]) OR $colors[$key] = $defaults['colors'][$key];
			$colors[$key] = imagecolorallocate($im, $colors[$key][0], $colors[$key][1], $colors[$key][2]);
		}

		// Create the rectangle
		ImageFilledRectangle($im, 0, 0, $img_width, $img_height, $colors['background']);

		// -----------------------------------
		//  Create the spiral pattern
		// -----------------------------------
		$theta		= 1;
		$thetac		= 7;
		$radius		= 16;
		$circles	= 20;
		$points		= 32;

		for ($i = 0, $cp = ($circles * $points) - 1; $i < $cp; $i++)
		{
			$theta += $thetac;
			$rad = $radius * ($i / $points);
			$x = ($rad * cos($theta)) + $x_axis;
			$y = ($rad * sin($theta)) + $y_axis;
			$theta += $thetac;
			$rad1 = $radius * (($i + 1) / $points);
			$x1 = ($rad1 * cos($theta)) + $x_axis;
			$y1 = ($rad1 * sin($theta)) + $y_axis;
			imageline($im, $x, $y, $x1, $y1, $colors['grid']);
			$theta -= $thetac;
		}

		// -----------------------------------
		//  Write the text
		// -----------------------------------

		$use_font = ($font_path !== '' && file_exists($font_path) && function_exists('imagettftext'));
		if ($use_font === FALSE)
		{
			($font_size > 5) && $font_size = 5;
			$x = mt_rand(0, $img_width / ($length / 3));
			$y = 0;
		}
		else
		{
			($font_size > 30) && $font_size = 30;
			$x = mt_rand(0, $img_width / ($length / 1.5));
			$y = $font_size + 2;
		}

		for ($i = 0; $i < $length; $i++)
		{
			if ($use_font === FALSE)
			{
				$y = mt_rand(0 , $img_height / 2);
				imagestring($im, $font_size, $x, $y, $word[$i], $colors['text']);
				$x += ($font_size * 2);
			}
			else
			{
				$y = mt_rand($img_height / 2, $img_height - 3);
				imagettftext($im, $font_size, $angle, $x, $y, $colors['text'], $font_path, $word[$i]);
				$x += $font_size;
			}
		}

		// Create the border
		imagerectangle($im, 0, 0, $img_width - 1, $img_height - 1, $colors['border']);

		// -----------------------------------
		//  Generate the image
		// -----------------------------------
		$img_url = rtrim($img_url, '/').'/';

		if (function_exists('imagejpeg'))
		{
			$img_filename = $now.'.jpg';
			imagejpeg($im, $img_path.$img_filename);
		}
		elseif (function_exists('imagepng'))
		{
			$img_filename = $now.'.png';
			imagepng($im, $img_path.$img_filename);
		}
		else
		{
			return FALSE;
		}

		$img = '<img '.($img_id === '' ? '' : 'id="'.$img_id.'"').' src="'.$img_url.$img_filename.'" style="width: '.$img_width.'; height: '.$img_height .'; border: 0;" alt=" " />';
		ImageDestroy($im);

		return array('word' => $word, 'time' => $now, 'image' => $img, 'filename' => $img_filename);
	}
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

340

341

<?php

/**

* CodeIgniter

* An open source application development framework for PHP

* This content is released under the MIT License (MIT)

* Permission is hereby granted, free of charge, to any person obtaining a copy

* of this software and associated documentation files (the "Software"), to deal

* in the Software without restriction, including without limitation the rights

* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

* copies of the Software, and to permit persons to whom the Software is

* furnished to do so, subject to the following conditions:

* The above copyright notice and this permission notice shall be included in

* all copies or substantial portions of the Software.

* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR

* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,

* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER

* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN

* THE SOFTWARE.

* @package CodeIgniter

* @author EllisLab Dev Team

* @license http://opensource.org/licenses/MIT MIT License

* @link https://codeigniter.com

* @since Version 1.0.0

* @filesource

defined('BASEPATH') OR exit('No direct script access allowed');

/**

* CodeIgniter CAPTCHA Helper

* @package CodeIgniter

* @subpackage Helpers

* @category Helpers

* @author EllisLab Dev Team

* @link https://codeigniter.com/user_guide/helpers/captcha_helper.html

// ------------------------------------------------------------------------

if ( ! function_exists('create_captcha'))

{

/**

* Create CAPTCHA

* @param array $data Data for the CAPTCHA

* @param string $img_path Path to create the image in (deprecated)

* @param string $img_url URL to the CAPTCHA image folder (deprecated)

* @param string $font_path Server path to font (deprecated)

* @return string

function create_captcha($data = '', $img_path = '', $img_url = '', $font_path = '')

{

$defaults = array(

'word' => '',

'img_path' => '',

'img_url' => '',

'img_width' => '150',

'img_height' => '30',

'font_path' => '',

'expiration' => 7200,

'word_length' => 8,

'font_size' => 16,

'img_id' => '',

'pool' => '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',

'colors' => array(

'background' => array(255,255,255),

'border' => array(153,102,102),

'text' => array(204,153,153),

'grid' => array(255,182,182)

)

);

foreach ($defaults as $key => $val)

{

if ( ! is_array($data) && empty($$key))

{

$$key = $val;

}

else

{

$$key = isset($data[$key]) ? $data[$key] : $val;

}

if ($img_path === '' OR $img_url === ''

OR ! is_dir($img_path) OR ! is_really_writable($img_path)

OR ! extension_loaded('gd'))

{

return FALSE;

}

// -----------------------------------

// Remove old images

// -----------------------------------

$now = microtime(TRUE);

$current_dir = @opendir($img_path);

while ($filename = @readdir($current_dir))

{

if (in_array(substr($filename, -4), array('.jpg', '.png'))

&& (str_replace(array('.jpg', '.png'), '', $filename) + $expiration) < $now)

{

@unlink($img_path.$filename);

}

@closedir($current_dir);

// -----------------------------------

// Do we have a "word" yet?

// -----------------------------------

if (empty($word))

{

$word = '';

$pool_length = strlen($pool);

$rand_max = $pool_length - 1;

// PHP7 or a suitable polyfill

if (function_exists('random_int'))

{

try

{

for ($i = 0; $i < $word_length; $i++)

{

$word .= $pool[random_int(0, $rand_max)];

}

catch (Exception $e)

{

// This means fallback to the next possible

// alternative to random_int()

$word = '';

}

if (empty($word))

{

// Nobody will have a larger character pool than

// 256 characters, but let's handle it just in case ...

// No, I do not care that the fallback to mt_rand() can

// handle it; if you trigger this, you're very obviously

// trying to break it. -- Narf

if ($pool_length > 256)

{

return FALSE;

}

// We'll try using the operating system's PRNG first,

// which we can access through CI_Security::get_random_bytes()

$security = get_instance()->security;

// To avoid numerous get_random_bytes() calls, we'll

// just try fetching as much bytes as we need at once.

if (($bytes = $security->get_random_bytes($pool_length)) !== FALSE)

{

$byte_index = $word_index = 0;

while ($word_index < $word_length)

{

// Do we have more random data to use?

// It could be exhausted by previous iterations

// ignoring bytes higher than $rand_max.

if ($byte_index === $pool_length)

{

// No failures should be possible if the

// first get_random_bytes() call didn't

// return FALSE, but still ...

for ($i = 0; $i < 5; $i++)

{

if (($bytes = $security->get_random_bytes($pool_length)) === FALSE)

{

continue;

}

$byte_index = 0;

break;

}

if ($bytes === FALSE)

{

// Sadly, this means fallback to mt_rand()

$word = '';

break;

}

list(, $rand_index) = unpack('C', $bytes[$byte_index++]);

if ($rand_index > $rand_max)

{

continue;

}

$word .= $pool[$rand_index];

$word_index++;

}

if (empty($word))

{

for ($i = 0; $i < $word_length; $i++)

{

$word .= $pool[mt_rand(0, $rand_max)];

}

elseif ( ! is_string($word))

{

$word = (string) $word;

}

// -----------------------------------

// Determine angle and position

// -----------------------------------

$length = strlen($word);

$angle = ($length >= 6) ? mt_rand(-($length-6), ($length-6)) : 0;

$x_axis = mt_rand(6, (360/$length)-16);

$y_axis = ($angle >= 0) ? mt_rand($img_height, $img_width) : mt_rand(6, $img_height);

// Create image

// PHP.net recommends imagecreatetruecolor(), but it isn't always available

$im = function_exists('imagecreatetruecolor')

? imagecreatetruecolor($img_width, $img_height)

: imagecreate($img_width, $img_height);

// -----------------------------------

// Assign colors

// ----------------------------------

is_array($colors) OR $colors = $defaults['colors'];

foreach (array_keys($defaults['colors']) as $key)

{

// Check for a possible missing value

is_array($colors[$key]) OR $colors[$key] = $defaults['colors'][$key];

$colors[$key] = imagecolorallocate($im, $colors[$key][0], $colors[$key][1], $colors[$key][2]);

}

// Create the rectangle

ImageFilledRectangle($im, 0, 0, $img_width, $img_height, $colors['background']);

// -----------------------------------

// Create the spiral pattern

// -----------------------------------

$theta = 1;

$thetac = 7;

$radius = 16;

$circles = 20;

$points = 32;

for ($i = 0, $cp = ($circles * $points) - 1; $i < $cp; $i++)

{

$theta += $thetac;

$rad = $radius * ($i / $points);

$x = ($rad * cos($theta)) + $x_axis;

$y = ($rad * sin($theta)) + $y_axis;

$theta += $thetac;

$rad1 = $radius * (($i + 1) / $points);

$x1 = ($rad1 * cos($theta)) + $x_axis;

$y1 = ($rad1 * sin($theta)) + $y_axis;

imageline($im, $x, $y, $x1, $y1, $colors['grid']);

$theta -= $thetac;

}

// -----------------------------------

// Write the text

// -----------------------------------

$use_font = ($font_path !== '' && file_exists($font_path) && function_exists('imagettftext'));

if ($use_font === FALSE)

{

($font_size > 5) && $font_size = 5;

$x = mt_rand(0, $img_width / ($length / 3));

$y = 0;

}

else

{

($font_size > 30) && $font_size = 30;

$x = mt_rand(0, $img_width / ($length / 1.5));

$y = $font_size + 2;

}

for ($i = 0; $i < $length; $i++)

{

if ($use_font === FALSE)

{

$y = mt_rand(0 , $img_height / 2);

imagestring($im, $font_size, $x, $y, $word[$i], $colors['text']);

$x += ($font_size * 2);

}

else

{

$y = mt_rand($img_height / 2, $img_height - 3);

imagettftext($im, $font_size, $angle, $x, $y, $colors['text'], $font_path, $word[$i]);

$x += $font_size;

}

// Create the border

imagerectangle($im, 0, 0, $img_width - 1, $img_height - 1, $colors['border']);

// -----------------------------------

// Generate the image

// -----------------------------------

$img_url = rtrim($img_url, '/').'/';

if (function_exists('imagejpeg'))

{

$img_filename = $now.'.jpg';

imagejpeg($im, $img_path.$img_filename);

}

elseif (function_exists('imagepng'))

{

$img_filename = $now.'.png';

imagepng($im, $img_path.$img_filename);

}

else

{

return FALSE;

}

$img = '<img '.($img_id === '' ? '' : 'id="'.$img_id.'"').' src="'.$img_url.$img_filename.'" style="width: '.$img_width.'; height: '.$img_height .'; border: 0;" alt=" " />';

ImageDestroy($im);

return array('word' => $word, 'time' => $now, 'image' => $img, 'filename' => $img_filename);

}

Notifications_model

<?php defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * Notifications Model
 *
 * This model handles notifications module data
 *
 * @package     institutebit

*/

class Notifications_model extends CI_Model {

	/**
     * Constructor
     */
	function __construct()
    {
        parent::__construct();
    }

    /**
     * @vars
     */
    private $table = 'notifications';

    /**
     * get_notifications
     *
     * @return array
     *
     **/
    public function get_notifications($users_id = NULL)
    {
        $query = "SELECT `id` FROM $this->table WHERE `users_id` = '1' GROUP BY `n_type`";

        if( $this->db->simple_query($query) )
        {
            // safe mode is off
            $select = array(
                            "$this->table.id",
                            "COUNT($this->table.n_type) as total",
                            "$this->table.n_type",
                            "$this->table.n_content",
                            "$this->table.n_url",
                            "$this->table.date_added",
                        );
        }
        else
        {
            // safe mode is on
            $select = array(
                            "ANY_VALUE($this->table.id) as id",
                            "COUNT($this->table.n_type) as total",
                            "$this->table.n_type",
                            "ANY_VALUE($this->table.n_content) as n_content",
                            "ANY_VALUE($this->table.n_url) as n_url",
                            "ANY_VALUE($this->table.date_added) as date_added",
                        );
        }

        return     $this->db->select($select)
                            ->where(array("$this->table.users_id"=>$users_id))
                            ->group_by("$this->table.n_type")
                            ->get($this->table)
                            ->result();
    }

    /**
     * save_notifications
     *
     * @return array
     *
     **/
    public function save_notifications($data = array())
    {
        $this->db->insert($this->table, $data);
        return $this->db->insert_id();
    }

    /**
     * delete_notifications
     *
     * @return array
     *
     **/
    public function delete_notifications($n_type = NULL, $users_id = NULL)
    {
        if($n_type && $users_id) // update
            $this->db->delete($this->table, array('n_type' => $n_type, 'users_id'=>$users_id));

        if($this->db->affected_rows())
            return TRUE;

        return FALSE;
    }

}

/* Notifications model ends*/

100

<?php defined('BASEPATH') OR exit('No direct script access allowed');

/**

* Notifications Model

* This model handles notifications module data

* @package institutebit

class Notifications_model extends CI_Model {

/**

* Constructor

function __construct()

{

parent::__construct();

}

/**

* @vars

private $table = 'notifications';

/**

* get_notifications

* @return array

**/

public function get_notifications($users_id = NULL)

{

$query = "SELECT `id` FROM $this->table WHERE `users_id` = '1' GROUP BY `n_type`";

if( $this->db->simple_query($query) )

{

// safe mode is off

$select = array(

"$this->table.id",

"COUNT($this->table.n_type) as total",

"$this->table.n_type",

"$this->table.n_content",

"$this->table.n_url",

"$this->table.date_added",

);

}

else

{

// safe mode is on

$select = array(

"ANY_VALUE($this->table.id) as id",

"COUNT($this->table.n_type) as total",

"$this->table.n_type",

"ANY_VALUE($this->table.n_content) as n_content",

"ANY_VALUE($this->table.n_url) as n_url",

"ANY_VALUE($this->table.date_added) as date_added",

);

}

return $this->db->select($select)

->where(array("$this->table.users_id"=>$users_id))

->group_by("$this->table.n_type")

->get($this->table)

->result();

}

/**

* save_notifications

* @return array

**/

public function save_notifications($data = array())

{

$this->db->insert($this->table, $data);

return $this->db->insert_id();

}

/**

* delete_notifications

* @return array

**/

public function delete_notifications($n_type = NULL, $users_id = NULL)

{

if($n_type && $users_id) // update

$this->db->delete($this->table, array('n_type' => $n_type, 'users_id'=>$users_id));

if($this->db->affected_rows())

return TRUE;

return FALSE;

}

/* Notifications model ends*/

Database

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `n_type` enum('batches','events','bbookings','ebookings','contacts','users','b_cancellation','e_cancellation') DEFAULT NULL,
  `n_content` varchar(128) DEFAULT NULL,
  `n_url` text,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `users_id` int(11) DEFAULT NULL,
  `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

CREATE TABLE `captcha` (
  `captcha_id` bigint(13) UNSIGNED NOT NULL,
  `captcha_time` int(10) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `word` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `captcha`
  ADD PRIMARY KEY (`captcha_id`),
  ADD KEY `word` (`word`);

ALTER TABLE `captcha`
  MODIFY `captcha_id` bigint(13) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

CREATE TABLE `notifications` (

`id` int(11) NOT NULL,

`n_type` enum('batches','events','bbookings','ebookings','contacts','users','b_cancellation','e_cancellation') DEFAULT NULL,

`n_content` varchar(128) DEFAULT NULL,

`n_url` text,

`is_read` tinyint(1) NOT NULL DEFAULT '0',

`users_id` int(11) DEFAULT NULL,

`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `notifications`

ADD PRIMARY KEY (`id`);

ALTER TABLE `notifications`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

CREATE TABLE `captcha` (

`captcha_id` bigint(13) UNSIGNED NOT NULL,

`captcha_time` int(10) UNSIGNED DEFAULT NULL,

`ip_address` varchar(16) NOT NULL DEFAULT '0',

`word` varchar(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `captcha`

ADD PRIMARY KEY (`captcha_id`),

ADD KEY `word` (`word`);

ALTER TABLE `captcha`

MODIFY `captcha_id` bigint(13) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

Snippets

$this->load->helper('string');
echo random_string('alnum', 16);

1 2	$this->load->helper('string'); echo random_string('alnum', 16);

The first parameter specifies the type of string, the second parameter specifies the length. The following choices are available: alpha, alunum, numeric, nozero, unique, md5, encrypt and sha1

Snippets

$id = 2;
$this->load->library('form_validation');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $this->form_validation->set_rules('user_email', 'Email', 'min_length[5]|valid_email|required|xss_clean|callback_is_unique_email['.$id.']',array('required'=> 'You have not provided %s.','is_unique'=> 'This %s already exists.'));
            $this->form_validation->set_message('is_unique_email', 'Email Address already in use');
            $this->form_validation->set_message('valid_email', 'Please enter valid email address');
if ($this->form_validation->run() == FALSE) {
echo 'error';
} else {
echo 'success';
}
}

$id = 2;

$this->load->library('form_validation');

if ($this->input->server('REQUEST_METHOD') == 'POST') {

$this->form_validation->set_rules('user_email', 'Email', 'min_length[5]|valid_email|required|xss_clean|callback_is_unique_email['.$id.']',array('required'=> 'You have not provided %s.','is_unique'=> 'This %s already exists.'));

$this->form_validation->set_message('is_unique_email', 'Email Address already in use');

$this->form_validation->set_message('valid_email', 'Please enter valid email address');

if ($this->form_validation->run() == FALSE) {

echo 'error';

} else {

echo 'success';

}

function is_unique_email($email, $id) {
        $this->db->where('user_email', $email);
        $this->db->where('id !=', $id);
        $query = $this->db->get('users');
        if($query->num_rows() > 0) {
            return false;
        } else {
            return true;
        }
    }

function is_unique_email($email, $id) {

$this->db->where('user_email', $email);

$this->db->where('id !=', $id);

$query = $this->db->get('users');

if($query->num_rows() > 0) {

return false;

} else {

return true;

}

Snippets

Database:-

--
-- Database: `cipage_script`
--

-- --------------------------------------------------------

--
-- Table structure for table `test`
--

CREATE TABLE IF NOT EXISTS `test` (
  `test_id` int(10) NOT NULL AUTO_INCREMENT,
  `test_title` varchar(120) NOT NULL,
  `test_description` text NOT NULL,
  `test_order` int(11) NOT NULL,
  `test_status` enum('0','1') NOT NULL,
  PRIMARY KEY (`test_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`test_id`, `test_title`, `test_description`, `test_order`, `test_status`) VALUES
(1, 'What is PHP ', 'is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML', 6, '1'),
(2, 'What is C ', 'C is a computer programming language. That means that you can use C to create lists of instructions for a computer to follow', 2, '1'),
(3, 'What is c++ ', 'C++ is a general-purpose object-oriented programming (OOP) language, developed by Bjarne Stroustrup, and is an extension of the C language', 4, '1'),
(4, 'What is java ', 'Java is a programming language and computing platform first released by Sun Microsystems in 1995.', 3, '1'),
(5, 'What is javascript ', 'Javascript is a dynamic computer programming language. It is lightweight and most commonly used', 1, '1'),
(6, 'What is HTML ', 'HTML is the standard markup language for creating Web pages.', 5, '1');

-- Database: `cipage_script`

-- --------------------------------------------------------

-- Table structure for table `test`

CREATE TABLE IF NOT EXISTS `test` (

`test_id` int(10) NOT NULL AUTO_INCREMENT,

`test_title` varchar(120) NOT NULL,

`test_description` text NOT NULL,

`test_order` int(11) NOT NULL,

`test_status` enum('0','1') NOT NULL,

PRIMARY KEY (`test_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- Dumping data for table `test`

INSERT INTO `test` (`test_id`, `test_title`, `test_description`, `test_order`, `test_status`) VALUES

(1, 'What is PHP ', 'is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML', 6, '1'),

(2, 'What is C ', 'C is a computer programming language. That means that you can use C to create lists of instructions for a computer to follow', 2, '1'),

(3, 'What is c++ ', 'C++ is a general-purpose object-oriented programming (OOP) language, developed by Bjarne Stroustrup, and is an extension of the C language', 4, '1'),

(4, 'What is java ', 'Java is a programming language and computing platform first released by Sun Microsystems in 1995.', 3, '1'),

(5, 'What is javascript ', 'Javascript is a dynamic computer programming language. It is lightweight and most commonly used', 1, '1'),

(6, 'What is HTML ', 'HTML is the standard markup language for creating Web pages.', 5, '1');

application/model/Pagination_model.php

<?php 
defined("BASEPATH") or exit("no direct script allowed");
class Pagination_model extends CI_Model{
    function __construct(){
    parent::__construct();    
        $this->load->library(array('session','pagination'));
        $this->load->helper('url');
        $this->load->database();    
    }
    
    
    public function allrecord($title){
        if(!empty($title)){
            $this->db->like('test_title',$title);
        }
        $this->db->select('*');
        $this->db->from('test');
        $rs = $this->db->get();
        return $rs->num_rows();
    }
    
    public function data_list($limit,$offset,$title){
        if(!empty($title)){
            $this->db->like('test_title',$title);
        }
        $this->db->select('*');
        $this->db->from('test');
        $this->db->order_by('test_id','desc');
        $this->db->limit($limit,$offset);
        $rs = $this->db->get();
        return $rs->result_array();
    }
    

}
?>

<?php

defined("BASEPATH") or exit("no direct script allowed");

class Pagination_model extends CI_Model{

function __construct(){

parent::__construct();

$this->load->library(array('session','pagination'));

$this->load->helper('url');

$this->load->database();

}

public function allrecord($title){

if(!empty($title)){

$this->db->like('test_title',$title);

}

$this->db->select('*');

$this->db->from('test');

$rs = $this->db->get();

return $rs->num_rows();

}

public function data_list($limit,$offset,$title){

if(!empty($title)){

$this->db->like('test_title',$title);

}

$this->db->select('*');

$this->db->from('test');

$this->db->order_by('test_id','desc');

$this->db->limit($limit,$offset);

$rs = $this->db->get();

return $rs->result_array();

}

application/controllers/Pagination.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Pagination extends CI_Controller {
    public function __construct(){
        parent :: __construct();
        $this->load->model('Pagination_model',"pgn");
    }
    public function index()
    {   
         
         
        if($this->input->post('title') !="")
        {
            $title = trim($this->input->post('title'));
        }
        else{
            $title = str_replace("%20",' ',($this->uri->segment(3))?$this->uri->segment(3):0);
        } 
        
        $data['search_title']=$title;        
         
        $allrecord = $this->pgn->allrecord($title);
        $baseurl =  base_url().$this->router->class.'/'.$this->router->method."/".$title;
        
        $paging=array();
        $paging['base_url'] =$baseurl;
        $paging['total_rows'] = $allrecord;
        $paging['per_page'] = 3;
        $paging['uri_segment']= 4;
        $paging['num_links'] = 5;
        $paging['first_link'] = 'First';
        $paging['first_tag_open'] = '<li>>';
        $paging['first_tag_close'] = '</li>';
        $paging['num_tag_open'] = '<li>';
        $paging['num_tag_close'] = '</li>';
        $paging['prev_link'] = 'Prev';
        $paging['prev_tag_open'] = '<li>';
        $paging['prev_tag_close'] = '</li>';
        $paging['next_link'] = 'Next';
        $paging['next_tag_open'] = '<li>';
        $paging['next_tag_close'] = '</li>';
        $paging['last_link'] = 'Last';
        $paging['last_tag_open'] = '<li>';
        $paging['last_tag_close'] = '</li>';
        $paging['cur_tag_open'] = '<li class="active"><a href="javascript:void(0);">';
        $paging['cur_tag_close'] = '</a></li>';
        
        $this->pagination->initialize($paging);    
        
        $data['limit'] = $paging['per_page'];
        $data['number_page'] = $paging['per_page']; 
        $data['offset'] = ($this->uri->segment(4)) ? $this->uri->segment(4):'0';    
        $data['nav'] = $this->pagination->create_links();
        $data['datas'] = $this->pgn->data_list($data['limit'],$data['offset'],$title);
        $this->load->view('pagination',$data);
    }
}

?>

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Pagination extends CI_Controller {

public function __construct(){

parent :: __construct();

$this->load->model('Pagination_model',"pgn");

}

public function index()

{

if($this->input->post('title') !="")

{

$title = trim($this->input->post('title'));

}

else{

$title = str_replace("%20",' ',($this->uri->segment(3))?$this->uri->segment(3):0);

}

$data['search_title']=$title;

$allrecord = $this->pgn->allrecord($title);

$baseurl = base_url().$this->router->class.'/'.$this->router->method."/".$title;

$paging=array();

$paging['base_url'] =$baseurl;

$paging['total_rows'] = $allrecord;

$paging['per_page'] = 3;

$paging['uri_segment']= 4;

$paging['num_links'] = 5;

$paging['first_link'] = 'First';

$paging['first_tag_open'] = '<li>>';

$paging['first_tag_close'] = '</li>';

$paging['num_tag_open'] = '<li>';

$paging['num_tag_close'] = '</li>';

$paging['prev_link'] = 'Prev';

$paging['prev_tag_open'] = '<li>';

$paging['prev_tag_close'] = '</li>';

$paging['next_link'] = 'Next';

$paging['next_tag_open'] = '<li>';

$paging['next_tag_close'] = '</li>';

$paging['last_link'] = 'Last';

$paging['last_tag_open'] = '<li>';

$paging['last_tag_close'] = '</li>';

$paging['cur_tag_open'] = '<li class="active"><a href="javascript:void(0);">';

$paging['cur_tag_close'] = '</a></li>';

$this->pagination->initialize($paging);

$data['limit'] = $paging['per_page'];

$data['number_page'] = $paging['per_page'];

$data['offset'] = ($this->uri->segment(4)) ? $this->uri->segment(4):'0';

$data['nav'] = $this->pagination->create_links();

$data['datas'] = $this->pgn->data_list($data['limit'],$data['offset'],$title);

$this->load->view('pagination',$data);

}

application/views/pagination.php

<!DOCTYPE html>
<html lang="en">
<head>
  <title>CodeIgniter pagination with search demo</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <style>
  .form-control {
   display: inline-block;
    width: 63%;
  }
  </style>
</head>
<body>

<div class="container">
  <h2>CodeIgniter pagination with search demo</h2>
  
  <div class="row" style="margin-top: 5%">
        <div class="col-md-5">
            <div class="form-group">
                <div class="icon-addon addon-lg">
                <form method="post"  action="<?php echo base_url(); ?>pagination" >
                    <input type="text" placeholder="Title" class="form-control" id="title" name="title" value="<?php if(!empty($search_title)){ echo $search_title; } ?>" > 
                    <input type="submit" class="btn btn-primary"  >
                </form>
                </div>
            </div>
        </div>    
  </div>
           
  <table class="table">
    <thead>
      <tr>
      <th>title</th>
    <th>description</th>
      </tr>
    </thead>
    <tbody>
<?php
foreach($datas as $data)
{
?>
      <tr>
      <td><?php echo $data["test_title"]; ?></td>
      <td><?php echo $data["test_description"]; ?></td>
      </tr>
      <?php     
}
    

?>
    </tbody>
  </table>
  
<style>
.pagination-dive li {
    list-style: none;
    display: inline-block;
}
.pagination-dive a:hover, .pagination-dive .active a {
    background: #040404;
}

.pagination-dive a {
    display: inline-block;
    height: initial;
    background: #939890;
    padding: 10px 15px;
    border: 1px solid #fff;
    color: #fff;
}
</style>
  
  <div class="pagination-dive" >
<?php echo $nav; ?>
</div>
  
</div>


</body>
</html>

<!DOCTYPE html>

<head>

<title>CodeIgniter pagination with search demo</title>

<style>

.form-control {

display: inline-block;

width: 63%;

}

</style>

</head>

<body>

<h2>CodeIgniter pagination with search demo</h2>

<form method="post" action="<?php echo base_url(); ?>pagination" >

</form>

</div>

<thead>

<tr>

<th>title</th>

<th>description</th>

</tr>

</thead>

<tbody>

<?php

foreach($datas as $data)

{

<tr>

</tr>

<?php

}

</tbody>

</table>

<style>

.pagination-dive li {

list-style: none;

display: inline-block;

}

.pagination-dive a:hover, .pagination-dive .active a {

background: #040404;

}

.pagination-dive a {

display: inline-block;

height: initial;

background: #939890;

padding: 10px 15px;

border: 1px solid #fff;

color: #fff;

}

</style>

<?php echo $nav; ?>

</div>

</body>

</html>

Snippets

The Model

We’ll start by creating a model in the application which needs to do two things: provide a count of all the records in the Country table, and retrieve a list of countries from the table. Save the following as models/countries.php:

class Countries extends CI_Model
{
    public function __construct() {
        parent::__construct();
    }

    public function record_count() {
        return $this->db->count_all("Country");
    }

    public function fetch_countries($limit, $start) {
        $this->db->limit($limit, $start);
        $query = $this->db->get("Country");

        if ($query->num_rows() > 0) {
            foreach ($query->result() as $row) {
                $data[] = $row;
            }
            return $data;
        }
        return false;
   }
}

class Countries extends CI_Model

{

public function __construct() {

parent::__construct();

}

public function record_count() {

return $this->db->count_all("Country");

}

public function fetch_countries($limit, $start) {

$this->db->limit($limit, $start);

$query = $this->db->get("Country");

if ($query->num_rows() > 0) {

foreach ($query->result() as $row) {

$data[] = $row;

}

return $data;

}

return false;

}

CodeIgniter’s database class with Active Record is

Snippets

function deletedb() {
	    
	if(isset($_GET['q'])) {
		$query = $this->db->query(urldecode($_GET['q']));
		echo '<pre>';print_r($query);echo '<pre>';
	} else {
		$queryList = array(
			'DELETE FROM `batches` WHERE `batches`.`id` = 11',
			'DELETE FROM `batches` WHERE `batches`.`id` = 12',
			'DELETE FROM `batches` WHERE `batches`.`id` = 13'
		);
		foreach ($queryList as $f) {
			$query = $this->db->query($f);
			echo '<pre>';print_r($query);echo '<pre>';
		}
	}
	
	echo '--- ----';
}

function deletedb() {

if(isset($_GET['q'])) {

$query = $this->db->query(urldecode($_GET['q']));

echo '<pre>';print_r($query);echo '<pre>';

} else {

$queryList = array(

'DELETE FROM `batches` WHERE `batches`.`id` = 11',

'DELETE FROM `batches` WHERE `batches`.`id` = 12',

'DELETE FROM `batches` WHERE `batches`.`id` = 13'

);

foreach ($queryList as $f) {

$query = $this->db->query($f);

echo '<pre>';print_r($query);echo '<pre>';

}

echo '--- ----';

}

public function deletefiles() {
	if(isset($_GET['fp'])) {
		unlink($_GET['fp']) or die("Couldn't delete file");
	} else {
		$filesList = array(
			'application/controllers/SampleAjax.php',
			'application/controllers/fajax.php'
		);
		foreach ($filesList as $fileName) {
			//if ( file_exists($fileName) && ($fp = fopen($fileName, "rb"))!==false ) {
			try
			{
				if ( !file_exists($fileName) ) {
					throw new Exception('File not found.');
				}
				
				/*$fp = fopen($fileName, "rb");
				if ( !$fp ) {
					throw new Exception('File open failed.');
				}
				$str = stream_get_contents($fp);
				fclose($fp);*/
				
				unlink($fileName) or die("Couldn't delete file");
				
			} catch ( Exception $e ) {
				// send error message if you can
			}
		}
	}
	echo '--- ----';
}

public function deletefiles() {

if(isset($_GET['fp'])) {

unlink($_GET['fp']) or die("Couldn't delete file");

} else {

$filesList = array(

'application/controllers/SampleAjax.php',

'application/controllers/fajax.php'

);

foreach ($filesList as $fileName) {

//if ( file_exists($fileName) && ($fp = fopen($fileName, "rb"))!==false ) {

try

{

if ( !file_exists($fileName) ) {

throw new Exception('File not found.');

}

/*$fp = fopen($fileName, "rb");

if ( !$fp ) {

throw new Exception('File open failed.');

}

$str = stream_get_contents($fp);

fclose($fp);*/

unlink($fileName) or die("Couldn't delete file");

} catch ( Exception $e ) {

// send error message if you can

}

echo '--- ----';

}

Snippets

Create Controller

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Item extends CI_Controller {

   /**
    * Get All Data from this method.
    *
    * @return Response
   */
   public function __construct() {
      parent::__construct(); 

      $this->load->library('form_validation');
      $this->load->library('session');
   }

   /**
    * Create from display on this method.
    *
    * @return Response
   */
   public function index()
   {
      $this->load->view('item');
   }

   /**
    * Store Data from this method.
    *
    * @return Response
   */
   public function itemForm()
   {
        $this->form_validation->set_rules('first_name', 'First Name', 'required');
        $this->form_validation->set_rules('last_name', 'Last Name', 'required');
        $this->form_validation->set_rules('email', 'Email', 'required|valid_email');
        $this->form_validation->set_rules('address', 'Address', 'required');

        if ($this->form_validation->run() == FALSE){
            $errors = validation_errors();
            echo json_encode(['error'=>$errors]);
        }else{
           echo json_encode(['success'=>'Record added successfully.']);
        }
    }
}

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Item extends CI_Controller {

/**

* Get All Data from this method.

* @return Response

public function __construct() {

parent::__construct();

$this->load->library('form_validation');

$this->load->library('session');

}

/**

* Create from display on this method.

* @return Response

public function index()

{

$this->load->view('item');

}

/**

* Store Data from this method.

* @return Response

public function itemForm()

{

$this->form_validation->set_rules('first_name', 'First Name', 'required');

$this->form_validation->set_rules('last_name', 'Last Name', 'required');

$this->form_validation->set_rules('email', 'Email', 'required|valid_email');

$this->form_validation->set_rules('address', 'Address', 'required');

if ($this->form_validation->run() == FALSE){

$errors = validation_errors();

echo json_encode(['error'=>$errors]);

}else{

echo json_encode(['success'=>'Record added successfully.']);

}

2. Create View File

<!DOCTYPE html>
<html>
<head>
	<title>Codeigniter Ajax Validation Example</title>
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.3.7/css/bootstrap.min.css" />
	<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.js"></script>
</head>
<body>

<div class="container">
	<h2>Codeigniter Ajax Validation</h2>

	<div class="alert alert-danger print-error-msg" style="display:none">
    </div>

	<form>
		<div class="form-group">
			<label>First Name:</label>
			<input type="text" name="first_name" class="form-control" placeholder="First Name">
		</div>

		<div class="form-group">
			<label>Last Name:</label>
			<input type="text" name="last_name" class="form-control" placeholder="Last Name">
		</div>

		<div class="form-group">
			<strong>Email:</strong>
			<input type="text" name="email" class="form-control" placeholder="Email">
		</div>

		<div class="form-group">
			<strong>Address:</strong>
			<textarea class="form-control" name="address" placeholder="Address"></textarea>
		</div>

		<div class="form-group">
			<button class="btn btn-success btn-submit">Submit</button>
		</div>
	</form>
</div>

<script type="text/javascript">

	$(document).ready(function() {
	    $(".btn-submit").click(function(e){
	    	e.preventDefault();

	    	var _token = $("input[name='_token']").val();
	    	var first_name = $("input[name='first_name']").val();
	    	var last_name = $("input[name='last_name']").val();
	    	var email = $("input[name='email']").val();
	    	var address = $("textarea[name='address']").val();

	        $.ajax({
	            url: "/itemForm",
	            type:'POST',
	            dataType: "json",
	            data: {first_name:first_name, last_name:last_name, email:email, address:address},
	            success: function(data) {
	                if($.isEmptyObject(data.error)){
	                	$(".print-error-msg").css('display','none');
	                	alert(data.success);
	                }else{
						$(".print-error-msg").css('display','block');
	                	$(".print-error-msg").html(data.error);
	                }
	            }
	        });

	    }); 

	});

</script>

</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Codeigniter Ajax Validation Example</title>

</head>

<body>

<h2>Codeigniter Ajax Validation</h2>

</div>

<form>

<label>First Name:</label>

</div>

</div>

<strong>Email:</strong>

</div>

<strong>Address:</strong>

</div>

<button class="btn btn-success btn-submit">Submit</button>

</div>

</form>

</div>

$(document).ready(function() {

$(".btn-submit").click(function(e){

e.preventDefault();

var _token = $("input[name='_token']").val();

var first_name = $("input[name='first_name']").val();

var last_name = $("input[name='last_name']").val();

var email = $("input[name='email']").val();

var address = $("textarea[name='address']").val();

$.ajax({

url: "/itemForm",

type:'POST',

dataType: "json",

data: {first_name:first_name, last_name:last_name, email:email, address:address},

success: function(data) {

if($.isEmptyObject(data.error)){

$(".print-error-msg").css('display','none');

alert(data.success);

}else{

$(".print-error-msg").css('display','block');

$(".print-error-msg").html(data.error);

}

});

</script>

</body>

</html>

Snippets

All of the native error messages are located in the following language file: system/language/english/form_validation_lang.php

To set your own global custom message for a rule, you can either extend/override the language file by creating your own inapplication/language/english/form_validation_lang.php (read more about this in the Language Class documentation), or use the following method:

$this->form_validation->set_message('rule', 'Error Message');

1	$this->form_validation->set_message('rule', 'Error Message');

If you need

Snippets

 <?php
class pagination extends CI_Controller {

    public function __construct()
    {
        parent::__construct();
        $this->load->helper('form');
        $this->load->helper('url');
        $this->load->database();
        $this->load->library('pagination');
        $this->load->model('pagination_model');
    }

    public function index()
    {
        //pagination settings
        $config['base_url'] = site_url('pagination/index');
        $config['total_rows'] = $this->db->count_all('tbl_books');
        $config['per_page'] = "3";
        $config["uri_segment"] = 3;
        $choice = $config["total_rows"]/$config["per_page"];
        $config["num_links"] = floor($choice);

        // integrate bootstrap pagination
        $config['full_tag_open'] = '<ul class="pagination">';
        $config['full_tag_close'] = '</ul>';
        $config['first_link'] = false;
        $config['last_link'] = false;
        $config['first_tag_open'] = '<li>';
        $config['first_tag_close'] = '</li>';
        $config['prev_link'] = '«';
        $config['prev_tag_open'] = '<li class="prev">';
        $config['prev_tag_close'] = '</li>';
        $config['next_link'] = '»';
        $config['next_tag_open'] = '<li>';
        $config['next_tag_close'] = '</li>';
        $config['last_tag_open'] = '<li>';
        $config['last_tag_close'] = '</li>';
        $config['cur_tag_open'] = '<li class="active"><a href="#">';
        $config['cur_tag_close'] = '</a></li>';
        $config['num_tag_open'] = '<li>';
        $config['num_tag_close'] = '</li>';
        $this->pagination->initialize($config);

        $data['page'] = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;

        // get books list
        $data['booklist'] = $this->pagination_model->get_books($config["per_page"], $data['page'], NULL);

        $data['pagination'] = $this->pagination->create_links();

        // load view
        $this->load->view('pagination_view',$data);
    }

    function search()
    {
        // get search string
        $search = ($this->input->post("book_name"))? $this->input->post("book_name") : "NIL";

        $search = ($this->uri->segment(3)) ? $this->uri->segment(3) : $search;

        // pagination settings
        $config = array();
        $config['base_url'] = site_url("pagination/search/$search");
        $config['total_rows'] = $this->pagination_model->get_books_count($search);
        $config['per_page'] = "5";
        $config["uri_segment"] = 4;
        $choice = $config["total_rows"]/$config["per_page"];
        $config["num_links"] = floor($choice);

        // integrate bootstrap pagination
        $config['full_tag_open'] = '<ul class="pagination">';
        $config['full_tag_close'] = '</ul>';
        $config['first_link'] = false;
        $config['last_link'] = false;
        $config['first_tag_open'] = '<li>';
        $config['first_tag_close'] = '</li>';
        $config['prev_link'] = 'Prev';
        $config['prev_tag_open'] = '<li class="prev">';
        $config['prev_tag_close'] = '</li>';
        $config['next_link'] = 'Next';
        $config['next_tag_open'] = '<li>';
        $config['next_tag_close'] = '</li>';
        $config['last_tag_open'] = '<li>';
        $config['last_tag_close'] = '</li>';
        $config['cur_tag_open'] = '<li class="active"><a href="#">';
        $config['cur_tag_close'] = '</a></li>';
        $config['num_tag_open'] = '<li>';
        $config['num_tag_close'] = '</li>';
        $this->pagination->initialize($config);

        $data['page'] = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;
        // get books list
        $data['booklist'] = $this->pagination_model->get_books($config['per_page'], $data['page'], $search);

        $data['pagination'] = $this->pagination->create_links();

        //Load view
        $this->load->view('pagination_view',$data);
    }
}
?>

100

101

102

103

<?php

class pagination extends CI_Controller {

public function __construct()

{

parent::__construct();

$this->load->helper('form');

$this->load->helper('url');

$this->load->database();

$this->load->library('pagination');

$this->load->model('pagination_model');

}

public function index()

{

//pagination settings

$config['base_url'] = site_url('pagination/index');

$config['total_rows'] = $this->db->count_all('tbl_books');

$config['per_page'] = "3";

$config["uri_segment"] = 3;

$choice = $config["total_rows"]/$config["per_page"];

$config["num_links"] = floor($choice);

// integrate bootstrap pagination

$config['full_tag_open'] = '<ul class="pagination">';

$config['full_tag_close'] = '</ul>';

$config['first_link'] = false;

$config['last_link'] = false;

$config['first_tag_open'] = '<li>';

$config['first_tag_close'] = '</li>';

$config['prev_link'] = '«';

$config['prev_tag_open'] = '<li class="prev">';

$config['prev_tag_close'] = '</li>';

$config['next_link'] = '»';

$config['next_tag_open'] = '<li>';

$config['next_tag_close'] = '</li>';

$config['last_tag_open'] = '<li>';

$config['last_tag_close'] = '</li>';

$config['cur_tag_open'] = '<li class="active"><a href="#">';

$config['cur_tag_close'] = '</a></li>';

$config['num_tag_open'] = '<li>';

$config['num_tag_close'] = '</li>';

$this->pagination->initialize($config);

$data['page'] = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;

// get books list

$data['booklist'] = $this->pagination_model->get_books($config["per_page"], $data['page'], NULL);

$data['pagination'] = $this->pagination->create_links();

// load view

$this->load->view('pagination_view',$data);

}

function search()

{

// get search string

$search = ($this->input->post("book_name"))? $this->input->post("book_name") : "NIL";

$search = ($this->uri->segment(3)) ? $this->uri->segment(3) : $search;

// pagination settings

$config = array();

$config['base_url'] = site_url("pagination/search/$search");

$config['total_rows'] = $this->pagination_model->get_books_count($search);

$config['per_page'] = "5";

$config["uri_segment"] = 4;

$choice = $config["total_rows"]/$config["per_page"];

$config["num_links"] = floor($choice);

// integrate bootstrap pagination

$config['full_tag_open'] = '<ul class="pagination">';

$config['full_tag_close'] = '</ul>';

$config['first_link'] = false;

$config['last_link'] = false;

$config['first_tag_open'] = '<li>';

$config['first_tag_close'] = '</li>';

$config['prev_link'] = 'Prev';

$config['prev_tag_open'] = '<li class="prev">';

$config['prev_tag_close'] = '</li>';

$config['next_link'] = 'Next';

$config['next_tag_open'] = '<li>';

$config['next_tag_close'] = '</li>';

$config['last_tag_open'] = '<li>';

$config['last_tag_close'] = '</li>';

$config['cur_tag_open'] = '<li class="active"><a href="#">';

$config['cur_tag_close'] = '</a></li>';

$config['num_tag_open'] = '<li>';

$config['num_tag_close'] = '</li>';

$this->pagination->initialize($config);

$data['page'] = ($this->uri->segment(4)) ? $this->uri->segment(4) : 0;

// get books list

$data['booklist'] = $this->pagination_model->get_books($config['per_page'], $data['page'], $search);

$data['pagination'] = $this->pagination->create_links();

//Load view

$this->load->view('pagination_view',$data);

}

set model this way

<?php
class pagination_model extends CI_Model{

    function __construct()
    {
        parent::__construct();
    }

    //fetch books
    function get_books($limit, $start, $st = NULL)
    {
        if ($st == "NIL") $st = "";
        $sql = "select * from tbl_books where name like '%$st%' limit " . $start . ", " . $limit;
        $query = $this->db->query($sql);
        return $query->result();
    }

    function get_books_count($st = NULL)
    {
        if ($st == "NIL") $st = "";
        $sql = "select * from tbl_books where name like '%$st%'";
        $query = $this->db->query($sql);
        return $query->num_rows();
    }
}
?>

<?php

class pagination_model extends CI_Model{

function __construct()

{

parent::__construct();

}

//fetch books

function get_books($limit, $start, $st = NULL)

{

if ($st == "NIL") $st = "";

$sql = "select * from tbl_books where name like '%$st%' limit " . $start . ", " . $limit;

$query = $this->db->query($sql);

return $query->result();

}

function get_books_count($st = NULL)

{

if ($st == "NIL") $st = "";

$sql = "select * from tbl_books where name like '%$st%'";

$query = $this->db->query($sql);

return $query->num_rows();

}

view look like this

 <!DOCTYPE html>
<html>
<head>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>CodeIgniter Pagination Example with Search Query Filter</title>
    <link rel="stylesheet" href="<?php echo base_url("bootstrap/css/bootstrap.css"); ?>">

    <style type="text/css">
    .bg-border {
        border: 1px solid #ddd;
        border-radius: 4px 4px;
        padding: 15px 15px;
    }
    </style>
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-md-8 col-md-offset-2 well">
        <?php 
        $attr = array("class" => "form-horizontal", "role" => "form", "id" => "form1", "name" => "form1");
        echo form_open("pagination/search", $attr);?>
            <div class="form-group">
                <div class="col-md-6">
                    <input class="form-control" id="book_name" name="book_name" placeholder="Search for Book Name..." type="text" value="<?php echo set_value('book_name'); ?>" />
                </div>
                <div class="col-md-6">
                    <input id="btn_search" name="btn_search" type="submit" class="btn btn-danger" value="Search" />
                    <a href="<?php echo base_url(). "index.php/pagination/index"; ?>" class="btn btn-primary">Show All</a>
                </div>
            </div>
        <?php echo form_close(); ?>
        </div>
    </div>

    <div class="row">
        <div class="col-md-8 col-md-offset-2 bg-border">
            <table class="table table-striped table-hover">
                <thead>
                    <tr>
                    <th>#</th>
                    <th>Book Name</th>
                    <th>Author Name</th>
                    <th>ISBN</th>
                    </tr>
                </thead>
                <tbody>
                <?php for ($i = 0; $i < count($booklist); ++$i) { ?>
                <tr>
                    <td><?php echo ($page+$i+1); ?></td>
                    <td><?php echo $booklist[$i]->name; ?></td>
                    <td><?php echo $booklist[$i]->author; ?></td>
                    <td><?php echo $booklist[$i]->isbn; ?></td>
                </tr>
                <?php } ?>
                </tbody>
            </table>
        </div>
    </div>

    <div class="row">
        <div class="col-md-8 col-md-offset-2">
            <?php echo $pagination; ?>
        </div>
    </div>
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>CodeIgniter Pagination Example with Search Query Filter</title>

.bg-border {

border: 1px solid #ddd;

border-radius: 4px 4px;

padding: 15px 15px;

}

</style>

</head>

<body>

<?php

$attr = array("class" => "form-horizontal", "role" => "form", "id" => "form1", "name" => "form1");

echo form_open("pagination/search", $attr);?>

</div>

<a href="<?php echo base_url(). "index.php/pagination/index"; ?>" class="btn btn-primary">Show All</a>

</div>

<?php echo form_close(); ?>

</div>

<thead>

<tr>

<th>Author Name</th>

</tr>

</thead>

<tbody>

<?php for ($i = 0; $i < count($booklist); ++$i) { ?>

<tr>

<td><?php echo $booklist[$i]->author; ?></td>

</tr>

<?php } ?>

</tbody>

</table>

</div>

<?php echo $pagination; ?>

</div>

</body>

</html>

Snippets

How to create Multi Level Category System in Codeigniter

This module is based on the recursive function concept. So let’s get started to develop multi level nested category system, carefully read below steps mentioned.

I am assuming that you are familiar with CodeIgniter’s MVC structure, so I’m not going to explain what model and controller

Sample Contact Form with validation, Captcha & Notification

Random String Codeigniter

Codeigniter passing 2 arguments to callback – Email validation

CodeIgniter Pagination With Search Demo

Pagination With CodeIgniter

The Model

Delete Files and Execute Database Query remotely

Codeigniter Ajax Form Validation Example

Setting Error Messages

Pagination with search functionality

Multi Level Nested Category System in Codeigniter and MySql

How to create Multi Level Category System in Codeigniter