OOP PDO fetch while loop

Question

I have a function in my class which is not completed. I'm searching a way to do it all night long. Well I want to fetch all the result of a SELECT request to MYSQL using PDO in a OOP class/function.

Here my function

function select($query)
{
    try
    {
    $sql = $this->connect->query($query);
        while ($row = $sql->fetch(PDO::FETCH_ASSOC))
        {
        return ????
        }
    }
    catch(PDOException $e) 
    {  
        echo $e->getMessage(); 
    }

}

I know that I can do it with a while loop, I tested a few options but most of the time I only got 1 result. Anyone a point for me, where I could start my search for a solution to this issue?

slashingweapon · Accepted Answer · 2012-11-16 04:09:33Z

3

It's pretty easy, actually. You use PDO::FETCH_CLASS and specify which class you want to instantiate for each row.

Here is an example that fetches all available rows as an array of objects of class YourClassName.

function select($query) {
    try {
        $sql = $this->connect->query($query);
        return $sql->fetchAll(PDO::FETCH_CLASS, YourClassName);
    } catch(PDOException $e) {  
        echo $e->getMessage(); 
    }
}

answered Nov 16, 2012 at 4:09

slashingweapon

11.4k4 gold badges33 silver badges52 bronze badges

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

Comments

Steve · Accepted Answer · 2012-11-16 03:58:39Z

0

Only use $sql->fetch(PDO::FETCH_ASSOC) within the while loop, not before, as you have it.

So, like:

while($row = $sql->fetch(PDO::FETCH_ASSOC)) {
    // something
}

answered Nov 16, 2012 at 3:58

Steve

3,0785 gold badges31 silver badges39 bronze badges

2 Comments

Johnny000 Over a year ago

yeah, remarked that as I posted the code ... the // something is what am missing... any points how I could go for it ?

Steve Over a year ago

items from $row are fetched like they are in an array. If you are doing select name from pets you would access it like: $row['name']

Collectives™ on Stack Overflow

OOP PDO fetch while loop

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related