A PHP Error was encountered Severity: Notice Message: Undefined variable: data Filename: profile/viewabout.php Line Number: 79

Question

Controller: I'm trying to fetch the records from database, but it is showing undefined variable $data in the view section. What is the problem i don't understand.

public function vabout(){
    if(!$this->session->userdata('logged_in')){
        redirect('register/login');
    }
    $this->load->model('profile_model');
    $data = $this->profile_model->viewprofile();

    $this->load->view('templates/pheader');
    $this->load->view('profile/viewabout',$data);
    $this->load->view('templates/pfooter');

}

Model: This is the model section, is there any issue in model for fetching the record?

public function viewprofile(){
    $data = $this->db->get('profile');
    return $data->row_array();
}

View: errore: a php error encountered $data is undefined

<?php
      foreach ($data as $row)
        { ?>
        <p><?php echo $row->id; ?></p>
        <p><?php echo $row->name; ?></p>
        <?php
      }
  ?>

B. Desai · Answer 1 · 2017-09-12T04:50:01.413

You need to pass array with key name $datanot contain data as key name, Every key you pass with data array will become variable in view

public function vabout(){
                if(!$this->session->userdata('logged_in')){
                    redirect('register/login');
                }
                $this->load->model('profile_model');
                $data['data'] = $this->profile_model->viewprofile(); // add data as index

                $this->load->view('templates/pheader');
                $this->load->view('profile/viewabout',$data);
                $this->load->view('templates/pfooter');

            }

Also you are retrieving data in view like object. So in model not convert result in array

public function viewprofile(){
    $data = $this->db->get('profile');
    return $data->result();
}

it didn't work @B. Desai Thanks anyway.. – Sep 12 '17 at 04:59 — , Sep 12 '17 at 04:59

flixy · Answer 2 · 2017-09-12T05:14:35.003

1

Replace your code with this: Controller

 public function vabout($id = NULL){
        if(!$this->session->userdata('logged_in')){
            redirect('register/login');
        }
        $this->load->model('profile_model');
        $data['data'] = $this->profile_model->viewprofile($id);

        $this->load->view('templates/pheader');
        $this->load->view('profile/viewabout',$data);
        $this->load->view('templates/pfooter');

    }

Replacing model with this. Is it right then?

Model:

public function viewprofile($id = FALSE){
     if($id === FALSE){
        $query = $this->db->get('profile');
        return $query->result_array();
      }
         $query = $this->db->get_where('profile',array('id' => $id);
         return $query->row_array();
    }

View:

<?php
              foreach ($data as $row)
                { ?>
                <p><?php echo $row['id']; ?></p>
                <p><?php echo $row['name']; ?></p>
                <?php
              }
          ?>

edited Sep 12 '17 at 05:14

answered Sep 12 '17 at 04:56

flixy

73
2
10

Thanks @flixy it worked.... – Sep 12 '17 at 04:58
Anytime @SohailShaikh – flixy Sep 12 '17 at 04:59
@SohailShaikh two returns in same function, are you serious it worked? – Alive to die - Anant Sep 12 '17 at 05:00
Ya @AlivetoDie I am also surprised. Also in model `$id` must be undeined error. I have suggested same solution (but with object).And here he says it worked, ;p – B. Desai Sep 12 '17 at 05:02
Yes @AlivetoDie – Sep 12 '17 at 05:02
And also flixy know that `$id` will be there in controller `vabout($id = NULL)` @AlivetoDie. :D – B. Desai Sep 12 '17 at 05:07
yes i'm also a bit confused though @B.Desai but it is working... – Sep 12 '17 at 05:12
Ya this edited one is also working @flixy – Sep 12 '17 at 05:17

A PHP Error was encountered Severity: Notice Message: Undefined variable: data Filename: profile/viewabout.php Line Number: 79

2 Answers2