How to get value from URL in Codeigniter?

Get value from URL in Codeigniter

Paste in Controller

$user_id = $this->uri->segment(2);

//$user_id = $this->uri->segment(position_after_index.php);

Paste in View

<?php echo base_url('index.php/update/'.$row['ID']); ?>

//http://localhost/codelearning/index.php/update/26

Paste in Routes

$route['update/(:any)'] = 'welcome/update_user';

$route['page_name/(:any)'] = 'conroller_name/controller_function';

How to call Model function in Controller in Codeigniter?

Call Model function in Controller in Codeigniter

 $query = $this->Customer_model->register_user($person,$phone,$email,$password);

// $query = $this->model_name->model_function($function_perameter,$phone,$email,$password);

How to create functions in model in Codeigniter?

 Create functions in the model in Codeigniter

 Delete, Fetch, Insert and Update functions in Codeigniter

<?php 

class Customer_model extends CI_Model {

 

    /**

    * Responsable for auto load the database

    * @return void

    */

    public function __construct()

    {

        $this->load->database();

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

    }

    /**

    * Get product by his is

    * @param int $product_id 

    * @return array

    */

   

   public function get_login_data()

    {

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

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

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

return $query->result_array(); 

    }

public function login_detail($email,$password)

    {

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

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

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

$this->db->where('password',$password);

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

return $query->result_array(); 

    }

public function get_single_user_detail($user_id)

    {

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

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

$this->db->where('ID',$user_id);

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

return $query->result_array(); 

    }

function register_user($name,$phone,$email,$password){

$data = array(

'name' => $name,

'phone' => $phone,

'email ' => $email,

'password ' => $password

);

$this->db->insert('login_form', $data);

}

function delete_user($user_id){

$this -> db -> where('ID', $user_id);

$this -> db -> delete('login_form');

}

function update_user($user_id,$name,$phone,$email,$password){

$data = array(

'name' => $name,

'phone' => $phone,

'email ' => $email,

'password ' => $password

);

$this->db->update('login_form', $data);

$this -> db -> where('ID', $user_id);

}

}

How to connect database in Codeigniter?

 Connect database in Codeigniter

$active_group = 'default';

$query_builder = TRUE;

$db['default'] = array(

'dsn' => '',

'hostname' => 'localhost', //add server

'username' => 'root', //username

'password' => '',

'database' => 'codelearning', //database name

'dbdriver' => 'mysqli',

'dbprefix' => '',

'pconnect' => FALSE,

'db_debug' => (ENVIRONMENT !== 'production'),

'cache_on' => FALSE,

'cachedir' => '',

'char_set' => 'utf8',

'dbcollat' => 'utf8_general_ci',

'swap_pre' => '',

'encrypt' => FALSE,

'compress' => FALSE,

'stricton' => FALSE,

'failover' => array(),

'save_queries' => TRUE

);

How to link CSS and Javascript File in Codeigniter?

 Link CSS and Javascript File in Codeigniter

Paste in view

<link rel="stylesheet" href="<?php echo base_url(); ?>assets/css/style.css">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

<script  src="<?php echo base_url(); ?>assets/js/custom.js" ></script>

Definite base URL in config.php file (D:\wamp\www\codelearning\application\config)

$config['base_url'] = 'http://localhost/codelearning/';

How to user logout (destroy session) in codeigniter?

 User logout (destroy session) in Codeigniter

Paste in Controller

public function logout(){

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

$this->session->unset_userdata('ID');

$this->session->sess_destroy();

redirect('register');

}

Paste in View

<div class="site_header"><h2><a href="<?php echo base_url('index.php/Welcome/logout'); ?>">Logout</a></h2></div>

Note:- Welcome is a controller name

How to use ajax properly in Codeigniter?

Use ajax properly in Codeigniter

Paste In view

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>

<script  src="<?php echo base_url(); ?>assets/js/custom.js" ></script>

<script>

$(document).ready(function(){

$(".ajax_bt").click(function(e) {

e.preventDefault();

    var person = $('#person').val();

    var phone = $('#phone').val();

    var email = $('#email').val();

    var password = $('#password').val();

//alert(person+''+''+phone+''+email+''+password);

  if(person != '' && phone != '' && email != '' && password != ''){

  

      $.ajax({

        url: "<?php echo base_url('index.php/Welcome/insert_data_with_ajax'); ?>",

        data: {

'person':person,

'phone':phone,

'email':email,

'password':password

}, // change this to send js object

        type: "post",

        success: function(data){

           //document.write(data); just do not use document.write

           console.log(data);

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

   

        },

        error:function(data){

           //document.write(data); just do not use document.write

           console.log(data);

   $('#ajax_response').html('<p style="color:Red; margin:0px">Data not inserted...</p>');

   

        }

      });

       

    }

else{

$('#ajax_response').html('<p style="color:Red; margin:0px">Please fill all fields...</p>');

}

});

});

</script>

Paste In Controller

class Welcome extends CI_Controller {

 public function __construct()

    {

        parent::__construct();

        

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

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

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

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

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

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

      

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

       

    }

public function insert_data_with_ajax() {

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

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

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

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

$query = $this->Customer_model->register_user($person,$phone,$email,$password);

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

 

echo 'Data inserted successfully';

 

}

else{  

echo 'Data Not inserted';

} 

die();

}

public function ajax()

{

if ($this->session->userdata('ID') == FALSE)

        {

            

redirect('register'); //if session is not there, redirect to login page

        }

$data['main_content']='ajax';

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

}

 

}

Paste In Model

class Customer_model extends CI_Model {

    public function __construct()

    {

        $this->load->database();

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

    }

function update_user($user_id,$name,$phone,$email,$password){

$data = array(

'name' => $name,

'phone' => $phone,

'email ' => $email,

'password ' => $password

);

$this->db->update('login_form', $data);

$this -> db -> where('ID', $user_id);

}

}