How to access result set row values by positional index instead of column name in CodeIgniter

Question

I'm having trouble generating my query result.

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row)
{
   echo $row['title'];
   echo $row['name'];
   echo $row['body'];
}

Will this work?

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row)
{
   echo $row['0'];
   echo $row['1'];
   echo $row['2'];
}

Perhaps we need to know what realistic problem you are actually solving. I mean, you could use a key map to translate indexes to keys, or call array_values() on each row, or maybe even use one of the printf() family functions. Offering the best advice requires better understanding your scenario. I can say, generally, that there should be no echoing in the model, and no querying in the view. — mickmackusa
– mickmackusa ♦, Commented Sep 30 at 5:38

Ayush · Accepted Answer · 2012-08-08 18:29:49Z

1

As Edward mentioned, the array returned is an associative array. While there is no standard way to index into assoc array using integers, you could do it this way:

$resultarray = $query->result_array();
// get an array of keys in result
$keys = array_keys($resultarray[0]);

foreach ($resultarray as $row)
{
   echo $row[$keys[0]];
   echo $row[$keys[1]];
   echo $row[$keys[2]];
}

answered Aug 8, 2012 at 18:29

Ayush

42.5k52 gold badges170 silver badges243 bronze badges

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

Comments

Edward Ruchevits · Accepted Answer · 2012-08-08 18:25:43Z

1

$query->result_array() generates an associative array. You can't access it's elements by index.

answered Aug 8, 2012 at 18:25

Edward Ruchevits

6,69612 gold badges54 silver badges87 bronze badges

Collectives™ on Stack Overflow

How to access result set row values by positional index instead of column name in CodeIgniter

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related