也许您可以尝试扩展PDO类以自动为您调用该函数…简而言之:
class myPDO extends PDO
{
function animalQuery($sql)
{
$result = parent::query($sql);
$result->setFetchMode(PDO::FETCH_INTO, new animals);
return $result;
}
// // useful if you have different classes
// function vegetableQuery($sql)
// {
// $result = parent::query($sql);
// $result->setFetchMode(PDO::FETCH_INTO, new vegetables);
// return $result;
// }
}
$dbh = new myPDO("mysql:host=$hostname;dbname=animals", $username, $password);
$stmt = $dbh->animalQuery("SELECT * FROM animals");
foreach($stmt as $animals)
{
echo $animals->name;
}