Is there a way to condition inside an array using update batch? CodeIgniter PHP

Question

I am trying to update grades of student using update batch (multiple update)

However the problem arises when conditioning in the model, whereas the array condition does not accept else if statement

in this line, 'equiv' => $data['grade'][$i] == 65 ? 5 : 0, is there a way to make it a full condition statement where I can use else if and remove the else or :0 at the end of the line. The :0 makes all other data 0 which those data should not be affected.

public function updateAll(){
    $id = $this->input->post('studentID');

    $data = $this->input->post();
    
        for($i = 0; $i < (count($data['studentID'])); $i++){
        
            $batch[] = array(
            'studentID' => $data['studentID'][$i],
            'grade' => $data['grade'][$i],
            'equiv' => $data['grade'][$i] == 65 ? 5 : 0
            );

        }

    return $this->db->update_batch('tbl_college_grades', $batch, 'studentID');
}

Mhmmad Rehan · Accepted Answer · 2022-08-25 02:23:17Z

2

THIS IS WORK FOR ME, GOOD LUCK

public function updateAll(){
    $id = $this->input->post('studentID');

    $data = $this->input->post();
    $selected_equiv;
    
        for($i = 0; $i < (count($data['studentID'])); $i++){
            data['grade'][$i] == 65 ? $selected_equiv = 5 : 0
            $batch[] = array(
            'studentID' => $data['studentID'][$i],
            'grade' => $data['grade'][$i],
            'equiv' => $selected_equiv
            );

        }

    return $this->db->update_batch('tbl_college_grades', $batch, 'studentID');
}

answered Aug 25, 2022 at 2:23

Mhmmad Rehan

1111 silver badge3 bronze badges

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

1 Comment

Kay Angevare Over a year ago

Since when are we allowed to refer to a variable without the $ in PHP?

Collectives™ on Stack Overflow

Is there a way to condition inside an array using update batch? CodeIgniter PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related