Category Archives: Codeigniter

Pagination in Codeigniter

Step1:create a database users with fields id,username,city and make necessary changes in the config.php file if required or else you can use the steps mentioned here below http://mydoubts.in/blog/username-validation-using-codeigniter-check-the-username-in-the-databse-for-validating-a-user/ step2:create a controler pagination.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Pagination extends CI_Controller {

 function __construct()
 {
   parent::__construct();
  $this->load->model('paginationdata','',TRUE);
 }

 function index()
 {
			$offset=$this->uri->segment(3);
			$per_page=3;
            $config['total_rows'] =$this->paginationdata->countusers();
 			$this->load->library('table');
			$this->load->library('pagination');
				
			$config['base_url'] = base_url().'/index.php/pagination/index';
			$config['per_page'] = 3;
			$config['num_links'] = 5;
			$this->pagination->initialize($config);
		
				
        	$this->db->select('id, username, city');
            $data['userslist'] = $this->paginationdata->loadusers($per_page,$offset);
            $header = array('SINO','Username', 'City');
            $this->table->set_heading($header);
            $this->load->view('mylist', $data);
 
 }
 
}
?>

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

class Pagination extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->model('paginationdata','',TRUE);

}

function index()

{

$offset=$this->uri->segment(3);

$per_page=3;

$config['total_rows'] =$this->paginationdata->countusers();

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

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

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

$config['per_page'] = 3;

$config['num_links'] = 5;

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

$this->db->select('id, username, city');

$data['userslist'] = $this->paginationdata->loadusers($per_page,$offset);

$header = array('SINO','Username', 'City');

$this->table->set_heading($header);

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

}

Step2: create view file mylist.php

<?
<html>
<head>
<title>Pagination example using codeigniter</title>
</head>
<body>
    <div id='paginationrslt'>
    <?php  echo $this->table->generate($userslist);  echo $this->pagination->create_links(); ?> 
    </div>
</body>
</html>

?>

<html>

<head>

<title>Pagination example using codeigniter</title>

</head>

<body>

<?php echo $this->table->generate($userslist); echo $this->pagination->create_links(); ?>

</div>

</body>

</html>

Step3: create a model file paginationdata.php

<?php
class Paginationdata extends CI_Model {
  
    function loadusers($per_page,$offset) {
        $query = $this->db->get('users', $per_page, $offset);
        if ($query->num_rows > 0) {
            return $query;
        }
    }
    
	function countusers() {
	
	return $this->db->count_all('users');
	 
   
	}
}
?>

<?php

class Paginationdata extends CI_Model {

function loadusers($per_page,$offset) {

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

if ($query->num_rows > 0) {

return $query;

}

function countusers() {

return $this->db->count_all('users');

}

Fatal error: Call to a member function generate() on a non-object in- Error in codeigniter

Table library is missing, may be you forget to add table. use the below statement in controller of you application $this->load->library(‘table’);

how to styllish the error message in codeigniter

Please Refer this link http://mydoubts.in/blog/username-validation-using-codeigniter-check-the-username-in-the-databse-for-validating-a-user/ and do the below steps on the mentioned files step1:add the below code into the view file uservalidationpage.php

<style TYPE="text/css">
.error{
 color: #808000
}
</style>

.error{

color: #808000

}

</style>

step2:add the below code in controllers/usernamevalidation.php $this->form_validation->set_error_delimiters(‘ ‘, ‘ ‘);

Removing index.php from the url in codeigniter

Eg:how to remove index.php from the below url ? http://localhost/hello/index.php/usernamevalidation/validateme after removing the index.php url will be look like as below http://localhost/hello/usernamevalidation/validateme For removing the index.php follow the following steps open the config.php php in config folder make the changes as below $config[‘index_page’] = “”; $config[‘uri_protocol’] = “REQUEST_URI” and create an .htaccess file and add… Read More »

Fatal error: Cannot redeclare class – Error message in codeigniter

class Usernamevalidation extends CI_Controller{ if you use the same name for modelfile and modle class it will throw this error message like below Class Usernamevalidation extends CI_Model { so please use separate class name for both model and controllers. Click to see the Demo Click here to see the detailed code and demo

username validation using codeigniter-check the username in the databse for validating a user

Here 2 validations are added first one is if user not entering any values it will alert message.second is if user enter ‘mydoubts.in’ in the username field it will throw alert message. step1:Create a database in mysql using phpmydmin.After installling the xaamp/Waamp Type the below url into the browser. http://localhost/phpmyadmin/ # create a database called… Read More »

username validation using codeigniter

Here 2 validations are added first one is if user not entering any values it will alert message.second is if user enter ‘mydoubts.in’ in the username field it will throw alert message. stept1:create view file inside the application/views-uservalidationpage.php uservalidationpage.php

<html>
<head>

</head>
<body>

<?php 
echo form_open('usernamevalidation/validateme', array('id'=>'form1')); 
?>
<?php echo validation_errors(); ?>
<h5>User Name</h5>
<input type="text" name="name" value="<?php echo set_value('name'); ?>" size="50" />
<div><input type="submit" value="Submit" /></div>
</form>
</body>
</html>

<html>

<head>

</head>

<body>

<?php

echo form_open('usernamevalidation/validateme', array('id'=>'form1'));

<?php echo validation_errors(); ?>

</form>

</body>

</html>

step2: create a controller inside the application/controllers/usernamevalidation.php usernamevalidation.php

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

class Usernamevalidation extends CI_Controller{

function index()
	{ 
	
					

		$this->load->view('uservalidationpage');	
	
	}
	
	
	function validateme()
	{
	
	
		$this->load->library('form_validation');
		
		$this->form_validation->set_rules('name', 'Username', 'callback_username_check');
		if ($this->form_validation->run() == FALSE)
		{

			$this->load->view('uservalidationpage');			
			
		}
		else
		{
		
			//here you can add the data savings into the db.
		}
		
	}
	
	
	public function username_check($str)
	{
	
	   $this->form_validation->set_rules('name', 'User Name', 'required');
	   if ($this->form_validation->run() == FALSE)
		{
		return FALSE;
        }
	
		else if ($str == 'mydoubts.in')
		{
			$this->form_validation->set_message('username_check', 'The %s field can not be the word "mydoubts.in"');
			return FALSE;
		}
		else
		{
			return TRUE;
		}
	}
}
?>

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

class Usernamevalidation extends CI_Controller{

function index()

{

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

}

function validateme()

{

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

$this->form_validation->set_rules('name', 'Username', 'callback_username_check');

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

{

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

}

else

{

//here you can add the data savings into the db.

}

public function username_check($str)

{

$this->form_validation->set_rules('name', 'User Name', 'required');

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

{

return FALSE;

}

else if ($str == 'mydoubts.in')

{

$this->form_validation->set_message('username_check', 'The %s field can not be the word "mydoubts.in"');

return FALSE;

}

else

{

return TRUE;

}

validation using codeigniter and jquery-input field validation using codeigniter and jquery

step1:create an assets folder in the root directory means structure will be like this /application /system /user_guide /assets/js/custom.js custom.js

 $(document).ready(function() {
$('#myform').submit(function(){
	
	$.post($('#myform').attr('action'), $('#myform').serialize(), function( data ) {
	if(data.st == 0)
		{
		 $('#my-error').html(data.msg);
		}
				
		if(data.st == 1)
		{
		  $('#my-error').html(data.msg);
		}
				
	}, 'json');
	return false;			
   });

	
});

$(document).ready(function() {

$('#myform').submit(function(){

$.post($('#myform').attr('action'), $('#myform').serialize(), function( data ) {

if(data.st == 0)

{

$('#my-error').html(data.msg);

}

if(data.st == 1)

{

$('#my-error').html(data.msg);

}

}, 'json');

return false;

});

step2:create controller inside application/controllers-validate.php

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

class Validate extends CI_Controller{

function index()
	{ 
	  
		$data['include'] = 'jquerypage';
		$this->load->view('mypage', $data);	
	
	}
	
	
	function savedata()
	{
				
		$this->load->library('form_validation');
		$this->form_validation->set_rules('name', 'Name', 'required');
		$this->form_validation->set_rules('age', 'Age', 'required');
				
		if ($this->form_validation->run() == FALSE)
		{
						
			echo json_encode(array('st'=>0, 'msg' => validation_errors()));
		}
		else
		{
			
			$name = $this->input->post('name');
			$age = $this->input->post('age');
					
			echo json_encode(array('st'=>0, 'msg' => 'Successfully Submiited'));
		}
		
	}
}
?>

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

class Validate extends CI_Controller{

function index()

{

$data['include'] = 'jquerypage';

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

}

function savedata()

{

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

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

$this->form_validation->set_rules('age', 'Age', 'required');

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

{

echo json_encode(array('st'=>0, 'msg' => validation_errors()));

}

else

{

$name = $this->input->post('name');

$age = $this->input->post('age');

echo json_encode(array('st'=>0, 'msg' => 'Successfully Submiited'));

}

step3:create view files inside view folder application/views-mypage.php,jquerypage.php mypage.php

<?php $this->load->view($include); ?>
jquerypage.php
<html>
<head>

</head>
<body>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script type="text/javascript" src="<?=base_url();?>assets/js/custom.js"></script>
<?php 
echo form_open('validate/savedata', array('id'=>'myform')); 

?>

<div id="my-error"></div>

<h5>Name</h5>
<input type="text" name="name" value="<?php echo set_value('name'); ?>" size="50" />

<h5>Age</h5>
<input type="text" name="age" value="<?php echo set_value('age'); ?>" size="50" />
<div><input type="submit" value="Submit" /></div>

</form>
</body>
</html>

<?php $this->load->view($include); ?>

jquerypage.php

<html>

<head>

</head>

<body>

<?php

echo form_open('validate/savedata', array('id'=>'myform'));

</form>

</body>

</html>

Automatic dropdown box loading using codeigniter and Jquery/Ajax

Step1:Open the database.php inside the config folder and make changes like as below

$active_group = 'default';
$active_record = TRUE;

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'testlogin';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;

$active_group = 'default';

$active_record = TRUE;

$db['default']['hostname'] = 'localhost';

$db['default']['username'] = 'root';

$db['default']['password'] = '';

$db['default']['database'] = 'testlogin';

$db['default']['dbdriver'] = 'mysql';

$db['default']['dbprefix'] = '';

$db['default']['pconnect'] = TRUE;

$db['default']['db_debug'] = TRUE;

$db['default']['cache_on'] = FALSE;

$db['default']['cachedir'] = '';

$db['default']['char_set'] = 'utf8';

$db['default']['dbcollat'] = 'utf8_general_ci';

$db['default']['swap_pre'] = '';

$db['default']['autoinit'] = TRUE;

$db['default']['stricton'] = FALSE;

step2:create a table inside testlogin database and insert the values please see the query below. —————————————————————

CREATE TABLE IF NOT EXISTS `country_state` (
  `country` varchar(250) NOT NULL,
  `state` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country_state`
--

INSERT INTO `country_state` (`country`, `state`) VALUES
('india', 'kerala'),
('india', 'karnataka'),
('USA', 'Texas'),
('USA', 'Newyork'),
('UAE', 'Abhudhabi'),
('UAE', 'Dubai');

CREATE TABLE IF NOT EXISTS `country_state` (

`country` varchar(250) NOT NULL,

`state` varchar(250) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `country_state`

INSERT INTO `country_state` (`country`, `state`) VALUES

('india', 'kerala'),

('india', 'karnataka'),

('USA', 'Texas'),

('USA', 'Newyork'),

('UAE', 'Abhudhabi'),

('UAE', 'Dubai');

————————————————————– step3:Create a model file inside application/model/countrystate.php

<?php
class Countrystate extends CI_Model {
  
    function loadcountries() {
        $query = $this->db->query("SELECT DISTINCT country FROM country_state");
         
        if ($query->num_rows > 0) {
            return $query->result();
        }
    }
     
    function loadstatesfromcountries($country) {
	
        $query = $this->db->query("SELECT state FROM country_state WHERE country = '{$country}'");
	
         
        if ($query->num_rows > 0) {
            return $query->result();
        }
    }
}
?>

<?php

class Countrystate extends CI_Model {

function loadcountries() {

$query = $this->db->query("SELECT DISTINCT country FROM country_state");

if ($query->num_rows > 0) {

return $query->result();

}

function loadstatesfromcountries($country) {

$query = $this->db->query("SELECT state FROM country_state WHERE country = '{$country}'");

if ($query->num_rows > 0) {

return $query->result();

}

step4: create controllers inside the controllers folder-application/controllers/countrystate_disp.php

<?php
class Countrystate_disp extends CI_Controller {
     
        function __construct() {
        parent::__construct();
        $this->load->model('countrystate','',TRUE);

    }
     
    
    function index() {
       
        $arrCountries = $this->countrystate->loadcountries();
              
        foreach ($arrCountries as $countries) {
            $arrcountries[$countries->country] = $countries->country;
        }
         
        $data['country'] = $arrcountries;
         
       
        $this->load->view('loadcountrystate',$data);
    }
     
    function ajax_call() {
       
        if (isset($_POST) && isset($_POST['country'])) {
            $country = $_POST['country'];
			           $arrStates = $this->countrystate->loadstatesfromcountries($country);
                     foreach ($arrStates as $states) {
                $arrstates[$states->state] = $states->state;
            }
             
       
            print form_dropdown('state',$arrstates);
        } else {
            redirect('site');
        }
  	
	}
}
?>

<?php

class Countrystate_disp extends CI_Controller {

function __construct() {

parent::__construct();

$this->load->model('countrystate','',TRUE);

}

function index() {

$arrCountries = $this->countrystate->loadcountries();

foreach ($arrCountries as $countries) {

$arrcountries[$countries->country] = $countries->country;

}

$data['country'] = $arrcountries;

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

}

function ajax_call() {

if (isset($_POST) && isset($_POST['country'])) {

$country = $_POST['country'];

$arrStates = $this->countrystate->loadstatesfromcountries($country);

foreach ($arrStates as $states) {

$arrstates[$states->state] = $states->state;

}

print form_dropdown('state',$arrstates);

} else {

redirect('site');

}

step5:create view file inside the application/view/loadcountrystate.php

<?php
$this->load->helper('html');
?>
<html>
    <head>
        <title>state loading based on country using jquery and codeigniter</title>
        <script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
        <script type="text/javascript">
            $(document).ready(function () { 
                $('#countrycombox select').change(function () {
                    var selCountry = $(this).val();
                    console.log(selCountry);
                    $.ajax({   
                        url: "countrystate_disp/ajax_call", 
                        async: false,
                        type: "POST", 
                        data: "country="+selCountry, 
                        dataType: "html", 
                         
                        
                        success: function(data) {
                        
                            $('#state').html(data);
                        }
                    })
                });
            });
        </script>
    </head>
     
    <body>
        <div id="mydoubts">
            <div id="countrycombox"><?php print form_dropdown('country',$country); ?></div>
            <div id="state"></div>
        </div>
    </body>
</html>

<?php

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

<html>

<head>

<title>state loading based on country using jquery and codeigniter</title>

$(document).ready(function () {

$('#countrycombox select').change(function () {

var selCountry = $(this).val();

console.log(selCountry);

$.ajax({

url: "countrystate_disp/ajax_call",

async: false,

type: "POST",

data: "country="+selCountry,

dataType: "html",

success: function(data) {

$('#state').html(data);

}

})

});

</script>

</head>

<body>

</div>

</body>

</html>

Click… Read More »

Unable to load the requested class: jquery error in codeigniter

<?php
class Test extends CI_Controller{

function index()
	{ 
	$this->load->library('javascript');
	$this->load->library('javascript/jquery');
}
?>

<?php

class Test extends CI_Controller{

function index()

{

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

$this->load->library('javascript/jquery');

}