assigning a value from a array to a variable in codeigniter

Question

i want to save a value from a array to a variable .for doing a if condition check . this is my code inside models folder . i got a errormysqli_fetch_array() expects parameter 1 to be mysqli_result, object given .but the $query returns a array value.

public function this_is_try(){
    $this->db->select('*');
    $this->db->from('partnerprofile');
    $this->db->where('User_Id','20'); 

    $query = $this->db->get();
    $query->result_array();

    $row = mysqli_fetch_array($query);
    $user_id = $row['User_Id'];
    $agefrom = $row['AgeFrom'];

    print $user_id;
    exit;
}

Vigneswaran S · Accepted Answer · 2015-11-18 17:36:46Z

1

Instead of passing the entire $results(result object). store the result_object to a variable and pass it ie $result=$results[0];

public function this_is_try(){
$this->db->select('*');
     $this->db->from('partnerprofile');
     $this->db->where('User_Id','20');
     $query = $this->db->get();
     $results = $query->result();       
            $result = $results[0];
$user_id=$result->user_id;
$agefrom = $result->AgeFrom;

print $user_id;exit;

}

edited Nov 18, 2015 at 17:36

answered Mar 7, 2015 at 5:59

Vigneswaran S

2,0941 gold badge22 silver badges33 bronze badges

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

Comments

Macks · Accepted Answer · 2015-03-05 15:46:26Z

0

Try this :

public function this_is_try(){

$row = $this->db->select('*')
           ->from('partnerprofile');
           ->where('User_Id','20'); 
           ->get()->row();

$user_id = $row->User_Id;
$agefrom = $row->AgeFrom;

print $user_id;exit;

}

edited Mar 5, 2015 at 15:46

answered Mar 5, 2015 at 15:02

Macks

4313 silver badges4 bronze badges

3 Comments

Vigneswaran S Over a year ago

i got syntax error syntax error, unexpected '->' (T_OBJECT_OPERATOR) in C:\wamp\www\MilanRishtha\application\models\action_model.php

Vali S Over a year ago

try $user_id = $row->User_Id; $agefrom = $row->AgeFrom;

Rizier123 Over a year ago

While this code snippet may solve the question, including an explanation out of the code really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. Please also try not to crowd your code with explanatory comments, this reduces the readability of both the code and the explanations!

Collectives™ on Stack Overflow

assigning a value from a array to a variable in codeigniter

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related