mapping data in codeigniter

Question

Hi I have a data stored in array

 $roles = [2,4];

I want to mapping the data I have in $roles with the data in the database. I don't know how to mapping data if I have more than one data in $roles like in above and I don't know how to show it all in a table view.

I try this

 if (count($roles) == 1) {
  if ($roles[0] == 2) {
    $data['need_app'] = $this->Hire_model->need_approval_req($OrganizationID, $requestor_id);
  }else if ($roles[0] == 3) {
    $data['need_app'] = $this->Hire_model->need_approval_recruiter();
  }else if ($roles[0] == 4) {
    $data['need_app']=$this->Hire_model->need_approval_hr();
  }else if ($roles[0] == 5) {
    $data['need_app'] = $this->Hire_model->need_approval_cc($PositionID, $OrganizationID, $requestor_id);
  }
}else{
   for ($i=0; $i < count($roles)-1 ; $i++) { 
    if ($roles[0] == 2) {
      $data['need_app'] = $this->Hire_model->need_approval_req($OrganizationID, $requestor_id);
      var_dump(count($data['need_app']));
    }else if ($roles[0] == 3) {
      $data['need_app'] = $this->Hire_model->need_approval_recruiter();
    }else if ($roles[0] == 4) {
      $data['need_app']=$this->Hire_model->need_approval_hr();
    }else if ($roles[0] == 5) {
      $data['need_app'] = $this->Hire_model->need_approval_cc($PositionID, $OrganizationID, $requestor_id);
      var_dump(count($data['need_app']));
    }
    // var_dump(count($data['need_app']));
  }
}

Hope anyone can help me

have you tried using foreach?

sauhardnc
– sauhardnc

2020-05-19 05:10:28 +00:00
Commented May 19, 2020 at 5:10 — sauhardnc
– sauhardnc, Commented May 19, 2020 at 5:10
I already use it but it show the last foreach data

Nadia
– Nadia

2020-05-19 05:11:24 +00:00
Commented May 19, 2020 at 5:11 — Nadia
– Nadia, Commented May 19, 2020 at 5:11
share the code where you're using foreach

sauhardnc
– sauhardnc

2020-05-19 05:13:08 +00:00
Commented May 19, 2020 at 5:13 — sauhardnc
– sauhardnc, Commented May 19, 2020 at 5:13

sauhardnc · Accepted Answer · 2020-05-19 05:21:53Z

1

I've written a code which should help you with this case, comments are mentioned wherever necessary. Hope it helps you.

foreach ($roles as $role) { 
    if ($role == 2) {
      $data['need_app'][] = $this->Hire_model->need_approval_req($OrganizationID, $requestor_id); // you need to make an array here otherwise the current value will over-write the previous one
      var_dump(count($data['need_app']));
    }else if ($role == 3) {
      $data['need_app'][] = $this->Hire_model->need_approval_recruiter(); // you need to make an array here otherwise the current value will over-write the previous one
    }else if ($role == 4) {
      $data['need_app'][] =$this->Hire_model->need_approval_hr(); // ...
    }else if ($role == 5) {
      $data['need_app'][] = $this->Hire_model->need_approval_cc($PositionID, $OrganizationID, $requestor_id); // ...
    }
    // var_dump($data['need_app']);
}

answered May 19, 2020 at 5:21

sauhardnc

1,9612 gold badges8 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Nadia Over a year ago

still can't to combine the data

sauhardnc Over a year ago

I'm sorry, I can't understand what you're asking, please clarify.

Nadia Over a year ago

when I am using it, it still show data for the last for each

sauhardnc Over a year ago

The data will be saved as an array so you'll have to use foreach again to get the data. In your view - foreach($need_app as $need){ echo $need;} This will give the value of each element in the array. You can then use it according to your needs.

Nadia Over a year ago

I get it, but now, how to display it in a desc. I try foreach( $need_app as $row){} n get error.

|

Nipun Tharuksha · Accepted Answer · 2020-05-19 05:30:19Z

0

 foreach ($roles as $role) {

            if ($role == 2) {

                //your logic here

            } else if ($role == 4) {

                //your logic here

            } else if ($role == WHAT_EVER_YOU_WANTS) {
                //Logic
            }

            //your logic here
        }

SO based on your question

foreach ($roles as $role) {
            if ($role == 2) {
                $data['need_app'] = $this->Hire_model->need_approval_req($OrganizationID, $requestor_id);
            } else if ($role == 3) {
                $data['need_app'] = $this->Hire_model->need_approval_recruiter();
            } else if ($role == 4) {
                $data['need_app'] = $this->Hire_model->need_approval_hr();
            } else if ($role == 5) {
                $data['need_app'] = $this->Hire_model->need_approval_cc($PositionID, $OrganizationID, $requestor_id);
            }
        }

Instead of using something like $role == 4

Make a constant or another variable inside the function and loop the conditions with that variable values. This will be helpful for future modification.

Something like this

$loopValues = [1,2,3,4,5,6] // Or    $loopValues = [['val' => 1, 'function' => functionName()]] <- I prefer this one all the time

and then loop it like below

 foreach ($roles as $role) {

            if ($role == $loopValues[0]) {

                //your logic here
}
}

edited May 19, 2020 at 5:30

answered May 19, 2020 at 5:17

Nipun Tharuksha

2,5654 gold badges19 silver badges44 bronze badges

2 Comments

Nadia Over a year ago

how to combine the data in one variable if I have 2,4 in $roles

Nipun Tharuksha Over a year ago

You can use an array as I did $loopValues = [1,2,3,4,5,6]

Collectives™ on Stack Overflow

mapping data in codeigniter

2 Answers 2

6 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related