Inserting data into database using if statement

Question

I wrote a code to insert input data to database using codeigniter but before inserting, data will go through an if statement to check the input then if condition is met data will be saved.

I was trying to check if the input data is equal to section then parent id must be 0. Else if not section then the $data['type'] entered must be inserted to database and parent id must not be 0. This is my code so far.

$data = array (
'title' => $this->input->post->('title'),
'type' => $this->input->post->('type'),
'description' => $this->input->post->('description')
); 


if ($data['type'] == 'section') {
         $data['parent_id'] = 0;
       } else {
         $data['parent_id']  = $this->input->post('parent_id');
         $data['type']  = $this->input->post('type');
       }
 $result = $this->checklist_item_model->put_item($data);

Model

public function put_item ($data) {
   $this->db->insert('items', $data);
 }

Where is your insert query or model code!!

Saty
– Saty

2016-04-15 04:55:03 +00:00
Commented Apr 15, 2016 at 4:55 — Saty
– Saty, Commented Apr 15, 2016 at 4:55
I edited the code above pls have a look

claudios
– claudios

2016-04-15 04:56:31 +00:00
Commented Apr 15, 2016 at 4:56 — claudios
– claudios, Commented Apr 15, 2016 at 4:56

Saty · Accepted Answer · 2016-04-15 05:15:55Z

1

You can create you condition as

if($this->input->post('type')=='section')
{
$data = array(
 'title' => $this->input->post('title'),
 'type' => $this->input->post('type'),
 'description' => $this->input->post('description'),
 'parent_id' => 0// if section==0 condition
);
} else {
    $data = array(
    'title' => $this->input->post('title'),
    'type' => $this->input->post('type'),
    'description' => $this->input->post('description'),
    'parent_id' => $this->input->post('parent_id')
    );
}

 $result = $this->checklist_item_model->put_item($data);

edited Apr 15, 2016 at 5:15

answered Apr 15, 2016 at 5:02

Saty

22.5k7 gold badges35 silver badges52 bronze badges

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

7 Comments

claudios Over a year ago

got an error syntax error, unexpected '(', expecting identifier (T_STRING) or variable (T_VARIABLE) or '{' or '$'

Saty Over a year ago

AHHH!! my bad remove -> after post! Check updated answer!!

claudios Over a year ago

the code run but I got the same error. it only insert the section input

Saty Over a year ago

If you got same error then this code will never run!! I think you miss something!! Check your column name and array key

claudios Over a year ago

I get it now. It's because of my database field type which is enum which is case sensitive.

|

claudios · Accepted Answer · 2016-04-15 05:37:20Z

1

You can use ternary operator to simplify your code

$data = array (
    'title' => $this->input->post('title'),
    'type' => $this->input->post('type'),
    'description' => $this->input->post('description'),
    'parent_id' => ($this->input->post('parent_id') == 'section') ? 0 : $this->input->post('parent_id');
); 
$result = $this->checklist_item_model->put_item($data);

And, in the model you can return the last insert id like this

public function put_item ($data) {
    $this->db->insert('items', $data);
    return $this->db->insert_id();
}

edited Apr 15, 2016 at 5:37

claudios

6,6768 gold badges51 silver badges98 bronze badges

answered Apr 15, 2016 at 5:08

Adersh

5981 gold badge9 silver badges22 bronze badges

2 Comments

claudios Over a year ago

This one is helpful too. Using only short type of if else condition.

Saty Over a year ago

Your solution is good and efficient just remove -> after post to make it syntax error free

Collectives™ on Stack Overflow

Inserting data into database using if statement

2 Answers 2

7 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related