Using PDO connection within a php class

Question

I'm struggling to get something I think should be really simple to work. I have created a class which connects to a database using PDO and would like to initially just create a function to pass direct SQL queries to it.

class PDO_MySQL
{
    private $_db;
    private $connection_string;

    public function __construct()
    {
        $this->_db = new PDO($this->connection_string, DB_USERNAME, DB_PASSWORD);
    }
    public function DB_Query($sql)
    {
        $query = $this->_db->query($sql);
        return $query;
    }
}

Then in my code:

$db = new PDO_MySQL();
$people = $db->DB_Query("SELECT * FROM about_us");
print_r($people);

But this is returning

PDOStatement Object ( [queryString] => SELECT * FROM about_us )

When I am looking for it to return a results set.

The connection string is set and the connection is fine i've just removed excess code for this post.

Secondary question, is this the best approach? I'm moving from MySQLi and non-Class based scripts.

or see this tutorial: phpro.org/tutorials/Introduction-to-PHP-PDO.html .. i think what you are missing here is fetchAll — Arfeen
– Arfeen, Commented May 30, 2012 at 11:46
Thanks, fetchAll has got it working. Is there an equivalent to mysqli fetch_object() without using the PDO FETCH_INTO or FETCH_CLASS? — MattP
– MattP, Commented May 30, 2012 at 11:50
@PLB the documentation shows this line can be added to return as an object $query->setFetchMode(PDO::FETCH_OBJ); before the fetch() or fetchAll() — MattP
– MattP, Commented May 30, 2012 at 11:59

Leri · Accepted Answer · 2012-05-30 11:48:37Z

1

Instead of

public function DB_Query($sql)
{
    $query = $this->_db->query($sql);
    return $query;
}

you have to do:

public function DB_Query($sql)
{
    $query = $this->_db->prepare($sql);
    $query->execute();
    return $query->fetchAll();
}

because

PDO::query — Executes an SQL statement, returning a result set as a PDOStatement object

answered May 30, 2012 at 11:48

Leri

12.6k7 gold badges46 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Using PDO connection within a php class

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related