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
– Damien Pirsy, Commented May 15, 2014 at 7:02
@DamienPirsy I need an index number. I need the index number for other parts of the code. — achll
– achll, Commented May 15, 2014 at 7:03
@achll Do you mean out of the result set object you want only a particular row? — AyB
– AyB, Commented May 15, 2014 at 7:24
@ICanHasKittenz I think no. I just want the index of current array result. — achll
– achll, Commented May 15, 2014 at 7:25

user3629249 · Accepted Answer · 2014-05-15 07:29:55Z

1

$index is the number you are looking for.

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

answered May 15, 2014 at 7:29

user3629249

16.6k1 gold badge18 silver badges17 bronze badges

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

Comments

Marian · Accepted Answer · 2014-05-15 07:22:04Z

0

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

answered May 15, 2014 at 7:22

Marian

1,1642 gold badges15 silver badges25 bronze badges

2 Comments

achll Over a year ago

I also read that from here: stackoverflow.com/questions/141108/… but I don't get it how to use $index and $name?

Mohit Jain Over a year ago

Please explain your answer in brief.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related