store value from array result to variable in codeigniter

Question

I have following controller,

class mycontroller extends CI_Controller
{
   public function getvalue() {
        $q= $this->db->select(array('value'))
                          ->from('settting')
                          ->get();
         $data['data']= $q->result();
             $this->load->view('myview',$data); 
    }

}

In my view:

print_r($data);

Gives output like this

Array ( [0] => stdClass Object ( [value] => wwwwwwwwwwww ) [1] => stdClass Object ( [value] => 5454546 ) [2] => stdClass Object ( [value] => 6868 ) [3] => stdClass Object ( [value] => 9898 ) [4] => stdClass Object ( [value] => 7878 ) [5] => stdClass Object ( [value] => 212 ) [6] => stdClass Object ( [value] => 87878 ) [7] => stdClass Object ( [value] => 8989 ) [8] => stdClass Object ( [value] => 212 ) )

I am trying to store each single value in variable

when i use ,

foreach($data as $row)
{
   echo $row->value;
}

its give me all value but i need to save each value in variable.

how can i do this, like this,

$var1='wwwwwwwwwwww'; // [0 ] array value  
$var2='5454546';      // [1]  array value

Dino Babu · Accepted Answer · 2013-02-22 10:24:51Z

4

better save it to another array

$my_values = array();
foreach($data as $row)
{
   $my_values[] = $row->value;
}

now you have :

echo $my_values[0]; // wwwwwwwwwwww
echo $my_values[1]; // 5454546

answered Feb 22, 2013 at 10:24

Dino Babu

5,8093 gold badges26 silver badges33 bronze badges

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

Comments

Pankaj Singh · Accepted Answer · 2013-12-30 11:10:45Z

When you print a query variable,

print_r($query);

you would get following result

Array ( [0] => stdClass Object ( 
               [Id] => 14 
               [username] => john 
               [password] => e10adc3949ba59abbe56e057f20f883e 
               [email] => [email protected] 
               [key] => 7f55570435fd15393f27eaac659b078a 
               [is_active] => 1 
               [gender] => Man 
               [countryid] => 1 
               [stateid] => 4 
               [cityid] => 4 
               [age] => 31 
       ) )

So if you want to get the value of a single element from this array, you can write the following code -

echo $query[0]->username;

then you get the following value

john

I hope this solves your problems. I'm sure that you might have already found the answer. but i got the same problem, so i thought it might help somebody.

Winston · Accepted Answer · 2013-02-22 10:24:06Z

1

You can try like this

class mycontroller extends CI_Controller
{
   public function getvalue() {
        $q = $this->db->select(array('value'))
                  ->from('settting')
                  ->get()
                  ->result_array();
        $i = 0;
        foreach($q as $val)
        {
            ${'var' . ++$i} = $val['value']; // Here we put each value in new variable, with variable name var1, var2, ...
        }
        echo $var1;
        echo $var2;
        $this->load->view('myview',$data); 
    }
}

answered Feb 22, 2013 at 10:24

Winston

1,8152 gold badges18 silver badges29 bronze badges

Comments

Muhammad Raheel · Accepted Answer · 2013-02-22 10:33:25Z

1

You strategy is totally wrong. You are calling a db call from a controller which breaks MVC rule. Create a model for this.

Class Value Extends CI_Model{

function __construct(){
    parent::__construct();
}

function getValue(){
return $this->db
            ->select(array('value'))
            ->from('settting')
            ->get();
            ->result();

}

And now call it from controller

class mycontroller extends CI_Controller
{
   $this->load->model('value');
   public function getvalue() {

        $data['value']= $this->value->getValue();   
        $this->load->view('myview',$data); 
    }
}

And now in the view

foreach($value as $row)
{
    echo $row;
}

answered Feb 22, 2013 at 10:33

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

Comments

Samy · Accepted Answer · 2013-02-22 10:28:25Z

0

You loop through the result with some tempoarary variable to construct variable. But i don't know whats the use of storing the array values in seperate variable :-)

$i = 0;
 foreach($data as $row)
{
  $var_.$i = $row->value;
  $i++;
}

answered Feb 22, 2013 at 10:28

Samy

6324 silver badges14 bronze badges

1 Comment

Kango Over a year ago

:because value comes from single colum "value" not from row and i want to show this value in textbox on form open.

Muhammad Raheel · Accepted Answer · 2013-02-22 10:35:01Z

0

Look array is containing "stdClass Object" object. So you need to convert object into array. So convert using,

$data= $q->result();
$data['data']=$data->result_array();  or $data->row_array();

edited Feb 22, 2013 at 10:35

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

answered Feb 22, 2013 at 10:26

Chandramohan

461 silver badge8 bronze badges

Collectives™ on Stack Overflow

store value from array result to variable in codeigniter

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related