Controller (application/controllers/Home.php)
PHP Code:
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Home extends CI_Controller {
public function index()
{
$this->load->model('user_model');
$data = array();
$regno = $this->session->userdata('username');
$data['appdetails_show'] = $this->user_model->getapp($regno);
$this->load->view('welcome_message',$data);
}
}
Model (application/models/User_model.php)
PHP Code:
<?php
class User_model extends CI_Model {
public function getapp($regno){
$this->db->select('*');
$this->db->from('appdetpayment');
$this->db->where('appdetpayment.regno',$regno);
$this->db->order_by('appdetpayment.appno');
$query = $this->db->get();
return $query->result_array();
}
}
IMPORTANT!! in application/config/autoload.php add database and session libraries. Example:
PHP Code:
$autoload['libraries'] = array('database','session');
With this works! Please check the $regno variable in controller. Sometimes can be null and generate a invalid SQL.