{"id":2216,"date":"2021-07-09T10:05:24","date_gmt":"2021-07-09T10:05:24","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=2216"},"modified":"2021-07-09T10:10:53","modified_gmt":"2021-07-09T10:10:53","slug":"fetchobject","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/fetchobject\/","title":{"rendered":"fetchObject"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the fetchObject()<\/code> method to fetch the next row from a result set and returns it as an object.<\/p>\n\n\n\n

Introduction to the fetchObject() method #<\/a><\/h2>\n\n\n\n

Suppose that you have a pulishers<\/code> table:<\/p>\n\n\n

CREATE TABLE IF<\/span> NOT EXISTS publishers (\r\n    publisher_id INT AUTO_INCREMENT,\r\n    name VARCHAR(255<\/span>) NOT NULL<\/span>,\r\n    PRIMARY KEY (publisher_id)\r\n);<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
and a Publisher<\/code> class:<\/p>\n\n\n
<?php<\/span>\n\nclass<\/span> Publisher<\/span>\n<\/span>{\n    private<\/span> $publisher_id;\n    private<\/span> $name;\n}<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
To fetch each row from the publishers<\/code> table and returns it as a Publisher<\/code> object, you use the fetchObject()<\/code> method:<\/p>\n\n\n
public<\/span> function<\/span> fetchObject<\/span>(\n    string|null $class = \"stdClass\"<\/span>, \n    array $constructorArgs = []\n)<\/span>: object<\/span>|false<\/span><\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The fetchObject()<\/code> is a method of the PDOStatement<\/code> class. It fetches the next row from the result set associated with a PDOStatement<\/code> object and returns an object of a class. If the fetchObject()<\/code> method fails, it’ll return false<\/code> instead.<\/p>\n\n\n\n
The fetchObject()<\/code> method has two parameters:<\/p>\n\n\n\n