{"id":2207,"date":"2021-07-09T07:29:15","date_gmt":"2021-07-09T07:29:15","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=2207"},"modified":"2021-10-31T06:48:45","modified_gmt":"2021-10-31T06:48:45","slug":"php-fetch","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/php-fetch\/","title":{"rendered":"fetch"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the PHP fetch()<\/code> method of the PDOStatement<\/code> object to fetch a row from the result set.<\/p>\n\n\n\n

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

The fetch()<\/code> is a method of the PDOStatement<\/code> class. The fetch()<\/code> method allows you to fetch a row from a result set associated with a PDOStatement<\/code> object.<\/p>\n\n\n\n

Internally, the fetch()<\/code> method fetches a single row from a result set and moves the internal pointer to the next row in the result set. Therefore, the subsequent call to the fetch()<\/code> method will return the next row from the result set.<\/p>\n\n\n\n

To fetch all rows from a result set one by one, you typically use the fetch()<\/code> method in a while<\/a><\/code> loop.<\/p>\n\n\n\n

The following shows the syntax of the fetch()<\/code> method:<\/p>\n\n\n

public<\/span> function<\/span> fetch<\/span>(\n    int $mode = PDO::FETCH_DEFAULT, \n    int $cursorOrientation = PDO::FETCH_ORI_NEXT, \n    int $cursorOffset = 0<\/span>\n)<\/span>: mixed<\/span><\/span><\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The fetch()<\/code> method accepts three optional parameters. The most important one is the first parameter $mode.<\/p>\n\n\n\n
The $mode<\/code> parameter determines how the fetch()<\/code> returns the next row. The $mode parameter accepts one of the PDO::FETCH_*<\/code> constants. The most commonly used modes are:<\/p>\n\n\n\n