PHP getting sql result by using for loop (or index number) and not foreach in controller codeigniter

Question

I have a query that goes like this:

function getnames(){
        $sql = "select * from names where status = '1'";

        $query = $this->db->query($sql);

        if($query->num_rows()>0){
            return $query->result();
        }
        else{
            return null;
        }
    }

This function is already loaded in the new_model.php. I am using CodeIgniter.

Then in the controller, I use a function that returns the query result. I already have this in the controller:

    function getnames(){
    return $this->new_model->getnames();
}

What I want to do is that instead of using foreach() loop in getting the array result, I want to use something else that will let me use an index number. How can I do this? Please help. Thanks!

Why are you against foreach? Is there any specific, concrete reason? — Damien Pirsy, May 15 '14 at 07:02
@DamienPirsy I need an index number. I need the index number for other parts of the code. — achll, May 15 '14 at 07:03
@achll Do you mean out of the result set object you want only a particular row? — AyB, May 15 '14 at 07:24
@ICanHasKittenz I think no. I just want the index of current array result. — achll, May 15 '14 at 07:25

score 1 · Accepted Answer · answered May 15 '14 at 07:29

1

$index is the number you are looking for.

$name is the value of the $names[$index]

answered May 15 '14 at 07:29

user3629249

16,402
1
16
17

score 0 · Answer 2 · answered May 15 '14 at 07:22

0

How about using foreach ($names as $index => $name) ?

answered May 15 '14 at 07:22

Marian

1,154
2
15
25

I also read that from here: http://stackoverflow.com/questions/141108/how-to-find-the-foreach-index but I don't get it how to use $index and $name? – achll May 15 '14 at 07:23
Please explain your answer in brief. – Mohit Jain May 15 '14 at 07:58

PHP getting sql result by using for loop (or index number) and not foreach in controller codeigniter

2 Answers2