Thursday, January 27, 2011

Pagination

 Pagination Controller


<?php
 class Pagination extends Controller {
  function Pagination() {
    parent::Controller();
    $this->load->helper('url');
    $this->load->database();
  }

  function index() {
    // load pagination class
    $this->load->library('pagination');
    $config['base_url'] = base_url().'pagination/index/';
    $config['total_rows'] = $this->db->count_all('user');
    $config['per_page'] = '3';
    $config['full_tag_open'] = '<p>';
    $config['full_tag_close'] = '</p>';

    $this->pagination->initialize($config);
       
    //load the model and get results
    $this->load->model('pagination_model');
    $data['results'] = $this->pagination_model->get_users($config['per_page'],$this->uri->segment(3));
       
    // load the HTML Table Class
    $this->load->library('table');
    $this->table->set_heading('ID', 'Name', 'Age', 'Gender','Address');
       
    // load the view
    $this->load->view('pagination', $data);
  }
}





Pagination Model

<?php
class Pagination_model extends Model {
  function Pagination_model(){
    parent::Model();
  }

  function get_users($num, $offset)
  /*$num specifies the number of results to retrieve from the database and
    $offset specifies where it should start retrieving results from.*/
    {
    $query = $this->db->get('user', $num, $offset);   
    return $query;
  }
}

Pagination View

<html>
<head>
<title>CodeIgniter Pagination </title>
</head>
<body>
<h1>Welcome To Codeigniter</h1>
<?php echo $this->table->generate($results); ?>
<?php echo $this->pagination->create_links(); ?>
</body>
</html>




Posted by at No comments:

inser values in database

inser values in database

Controller

<?php
class Form_controller extends Controller
{

  function Form_controller()
   {
    parent::Controller();
    $this->load->model('form_model');
    $this->load->helper(array('form','url'));

   }
   function index()
   {
    $data=array();
  // var_dump($_POST);

        if( $this->input->post("submit")  == 'Submit')
         { 
       
            $name =  $this->input->post('name');
            $age  =  $this->input->post ('age');
            $gender =  $this->input->post('gender');
            $address =  $this->input->post('address');
            $this->form_model->insertit($name,$age,$gender,$address);
           
        }
   
   //$data['mywords'] = 'hello world';
  
   $this->load->view('form',$data);
   }
  
 }

Model

<?php
class Form_model extends Model
{
  function Form_model()
  {
    parent::Model();
   
  }

  function insertit($name,$age,$address,$gender){
 
          $data = array(
                
                 'name'             => $name,
                 'age'           => $age,
                 'gender'          => $gender,
                 'address'       => $address);
          $this->db->insert('user', $data );
 
  }      
      
        
 
}
?>




View
 <html>
<body>
<form action="<?php echo base_url() ?>form_controller" method="post">
<table align="center" border="1">
<tr><td>NAME:</td><td><input type="text" name="name" id="name" /></td></tr>
<tr><td>AGE:</td><td><input type="text" name="age" id="age" /></td></tr>
<tr><td>GENDER:</td><td><input type="text" name="gender" id="gender" /></td></tr>
<tr><td>ADDRESS:</td><td><input type="text" name="address" id="address" /></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="submit" value="Submit" /></td></tr>
</table>
</form>
</body>
</html>


Posted by at No comments:

Add a check box and selected checkbox deleted and search box




















Add  checkbox controller

<?php 
class Add_users extends Controller
{
   function Add_users()
   {
     parent::Controller();
     $this->load->database();
     $this->load->model('add_users_model');
     $this->load->helper('url');
   }
    function index()
    {
     $data=array();
     $submit=$this->input->post('submit');
     if($submit=='Add')
     {
      $name=$this->input->post('name');
      $this->add_users_model->add_values($name);
     
     }
     $submit=$this->input->post('submit');
   
     if($submit=='Delete'){
   
     $name=$_POST;
   
     foreach($name as $value){
     
      $this->add_users_model->delete_values($value);
     
     }
      }
      $res=$this->add_users_model->getusers('user');
      $data['query']=$res;
     
      $submit=$this->input->post('submit');
       if($submit=='Submit')
      //if(isset($_POST['submit'])=='Submit')
      {
      $name=$this->input->post('search');
     
      $data['query'] = $this->add_users_model->search_values($name);
    }
  
     $this->load->view('add_users',$data);
    }
   
   
   
}

add_model.php

<?php
class Add_model extends Model
{
 function Add_model()
   {
    parent::Model();
   }
   function insert_values($name)
    {
     $data = array('name'=>$name );
          
             $query=$this->db->insert('user', $data );
    }
   
    function getusers()
    {
      $query = $this->db->get('user');
      return $query->result();
   
    }
    function delete_values($name)
    {
      //$row=$this->db->delete('user', array('name' => $name));
      $this->db->where('name', $name);
      $this->db->delete('user');
   
    }
function search_values($name)
   {
     $this->db->select('*');
    $this->db->from('user');
    $this->db->like('name',$name);
    $query = $this->db->get();
    return $query->result();

   }

}
?>



add_view.php

<html>
<title>Add Users</title>
<body>
<form action="<?php echo base_url()?>add_users" method="post">
USERNAME:<input type="text" name="name" /><br>

<input type="submit" name="submit" value="Add" />
</form>
<form action="<?php echo base_url()?>add_users" method="post">
<h4>Search:<input type="text" name="search">
<input type="submit" name="submit" value="Submit"></h4>
</form>
<form action="<?php echo base_url()?>add_users" method="post">
<?php $i=1;
foreach($query as $value){?>
<input type="checkbox" name="check<?php echo $i; ?>" value="<?php echo $value->name; ?>"><?php echo $value->name; ?><br>
<?php $i++; } ?>

<input type="submit" name="submit" value="Delete" />
</form>
</body>
</html>
Posted by at No comments:

insert,delet,update








controller registration.php

<?php
  class Registration extends Controller
  {
 
    function Registration()
      {
       parent::Controller();
       $this->load->database();
       $this->load->model('registration_model');
       $this->load->helper('url');
       }
      function index()
       {
        $data=array();
        $submit = $this->input->post('submit');
        if($submit == 'Insert')
          {
          
            $name=$this->input->post('name');
            $age =$this->input->post('age');
            $gender=$this->input->post('gender');
            $address=$this->input->post('address');
             $this->registration_model->insert_values($name,$age,$gender,$address);
         
          }
       
           $submit=$this->input->post('delete');
           if($submit=='Delete')
            {
             $i=$this->input->post('index');
             $id =$this->input->post('id'.$i);
             $this->registration_model->delete_values($id);
            }
             $row=$this->registration_model->getusers();
             $data['query']=$row;
            $this->load->view('registration',$data);
     
      
            }
     
      function update($id=NULL)
      {
    $data=array();
   
    $submit=$this->input->post('submit');
           if($submit=='Update')
           {
            
             $name=$this->input->post('name');
             $age=$this->input->post('age');
             $gender=$this->input->post('gender');
             $address=$this->input->post('address');
                    
             $this->registration_model->update_values($name,$age,$gender,$address,$id);
               redirect('registration');
              }
             //$row=$this->registration_model->getusers();
             $row=$this->registration_model->getusers_byid($id);
             $data['query']=$row;
           
             $this->load->view('update_reg',$data);
     }
   
}
?>



create model registration_model.php


<?php
class Registration_model extends Model
{
   function Registration_model()
     {
       parent::Model();
     }
      
    function insert_values($name,$age,$gender,$address)
    {
     $data=array(
                  'name'=>$name,
                  'age'=>$age,
                  'gender'=>$gender,
                  'address'=>$address );
     $query=$this->db->insert('user',$data);             

    }  
   
      function getusers()
        {
       $query = $this->db->get('user');
       return $query->result();
       }
       function getusers_byid($id)
        {
          $this->db->where('id',$id);
          $query = $this->db->get('user');
          return $query->row();
       }
      
     function update_values($name,$age,$gender,$address,$id)
     {
   
        $data=array('name'=>$name,
                    'age'=>$age,
                   'gender'=>$gender,
                   'address'=>$address);
            $this->db->where('id',$id);
            $this->db->update('user',$data);
           
   
           
     }
     function delete_values($id)
     {
        $this->db->where('id', $id);
        $this->db->delete('user');
   
     }

}


?>


create view registration.php

<html>
<title>
Registration</title>
<body>
<form action="<?php echo base_url()?>registration" method="post">
<table border="1">
<tr><td>Username:</td><td><input type="text" name="name" /></td></tr>
<tr><td>Age:</td><td><input type="text" name="age" /></td></tr>
<tr><td>Gender:</td><td><input type="text" name="gender" /></td></tr>
<tr><td>Address:</td><td><input type="text" name="address" /></td></tr>
<tr><td align="center" colspan="2"><input type="submit" name="submit" value="Insert" /></td>
</tr>
</table>
</form>
<table border="1">
<tr>
    <td>NAME</td>
    <td>AGE</td>
    <td>GENDER</td>
    <td>ADDRESS</td>
   
</tr>
<?php
$i="";
foreach($query as $value){?>
<form action="<?php echo base_url()?>registration" method="post">

<tr>
<td><?php echo $value->name;?></td>
<td><?php echo $value->age;?></td>
<td><?php echo $value->gender;?></td>
<td><?php echo $value->address;?></td>
<td><input type="hidden" name="id<?php echo $i;?>" value="<?php echo $value->id;?>" ></td>
    <input type="hidden" name="index" value="<?php echo $i;?>">
    <input type="hidden" name="delete" value="Delete">
<td><a href="<?php echo base_url()?>registration/update/<?php echo $value->id;?>">Update</a></td>
<td><input type="submit" name="submit" value="Delete<?php echo $i;?>"></td>
  </tr>
  </form>
<?php
}?>

</table>

</body>
</html>


create form update.php


<html>
<head>
</head>
<title>Update</title>
<body>
<form action="<?php echo base_url() ?>registration/update/<?php echo $query->id; ?>" method="post">

<table border="2" align="center">

<tr>
<td>NAME</td><td><input type="text" name="name" value="<?php echo $query->name; ?>" /></td></tr>
<tr><td>AGE</td><td><input type="text" name="age" value="<?php echo $query->age; ?>" /></td></tr>
<tr><td>GENDER</td><td><input type="text" name="gender" value="<?php echo $query->gender; ?>"/></td></tr>
<tr><td>ADDRESS</td><td><input type="text" name="address" value="<?php echo $query->address; ?>"/></td></tr>
<td colspan="2" align="center"><input type="submit" name="submit" value="Update" /></td>

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


Posted by at No comments:

Monday, January 24, 2011

login authentication using codeigniter

login controller

<?php

 class Login extends Controller {

    function Login()
    {
        parent::Controller();
        $this->load->model('login_model');
    }

    function index()
   
    {
      
        $username = $this->session->userdata('username');
        $password = $this->session->userdata('password');
       
        $data['mymessage'] = "welcome to php";   
        $submit = $this->input->post('submit');
       
            if($submit == 'login')
         {
         
                 $username = $this->input->post('username');
               
                   $password = $this->input->post('password');
               
                 $check = $this->login_model->check_login($username,$password);
       
                  if($check == true){
                  $this->session->set_userdata(array('username'=>$username));
                  redirect(base_url().'home');
                 

                    }
                    else
                    {
                       
                        $data['message']= "username and password is not match";
                       
                        }
               
           // redirect(base_url().'login');
      
    }
                $this->load->view('login',$data);
   
}
}
?>

home controller

<?php
class Home extends Controller
{
  function Home()
  {
     parent::Controller();
     $this->load->library('session');
     $this->load->helper('url');   
   
  }
     function index()
     {
     $username = $this->session->userdata('username');
     //var_dump($username);
     if($username)
       {
       echo "$username";
       //redirect(base_url().'home');
       }else{
        redirect(base_url().'login');
        }
       $this->load->view('home');
   
     }
}


logoutcontroller

<?php
class Logout extends Controller
{
  function Logout()
  {
    parent::Controller();
    $this->load->library('session');
    $this->load->helper('url');   
  }

function index()
    {

       $this->session->unset_userdata('username');
       $this->session->unset_userdata('password');
       $this->session->unset_userdata('login');
        //$this->session->unset_userdata(array('username' => '', 'password' => ''));
        $this->session->sess_destroy();
        redirect(base_url().'login');
    }
}
    ?>

create model login_model.php

<?php
class Login_model extends Model
{
    function Login_model()
    {
      parent::Model();
     
    }
   
    function check_login($username,$password)
     {
          $query=$this->db->select('username','password');
          $query=$this->db->from('test');
          $query=$this->db->where('username',$username);
          $query=$this->db->where('password',$password);
          $query=$this->db->get();
         
          if($query->num_rows()>0)
          {
            return true;
            }
            else{
            return false;
          }
     }
}

?>



create view login.php


<html>
<title>
Login
</title>
<body>
<?php echo $mymessage;?><br>
<?php if(isset($message)) echo $message;?>
<form action="<?php echo base_url()?>login" method="post">
<table border="1" align="center">
<tr><td>USERNAME:</td><td><input type="text" name="username"></td></tr>
<tr><td>PASSWORD:</td><td><input type="password" name="password"></td></tr>
<tr><td align="center" colspan="2"><input type="submit" name="submit" value="login"></td></tr>
</table>
</form>
</body>
</html>
Posted by at No comments:
Subscribe to: Posts (Atom)