{"id":2142,"date":"2021-07-07T09:03:58","date_gmt":"2021-07-07T09:03:58","guid":{"rendered":"https:\/\/phptutorial.net\/?page_id=2142"},"modified":"2021-07-09T08:48:45","modified_gmt":"2021-07-09T08:48:45","slug":"fetchcolumn","status":"publish","type":"page","link":"https:\/\/www.phptutorial.net\/php-pdo\/fetchcolumn\/","title":{"rendered":"fetchColumn"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you’ll learn how to use the fetchColumn()<\/code> method to get a single column from the next row of a result set.<\/p>\n\n\n\n

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

Sometimes, you want to get the value of a single column from the next row of a result set. In this case, you can use the fetchColumn()<\/code> method of the PDOStatement object.<\/p>\n\n\n

public<\/span> PDOStatement::fetchColumn(int $column = 0<\/span>): mixed<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
The fetchColumn()<\/code> method accepts a column index that you want to retrieve.<\/p>\n\n\n\n
The index of the first column is zero. The index of the second column is one, and so on. By default, the fetchColumn()<\/code> method returns the value of the first row from the result set if you don’t explicitly pass a column index.<\/p>\n\n\n\n
The fetchColumn()<\/code> method returns the value of the column specified by the $column<\/code> index. If the result set has no more rows, the method returns false<\/code>.<\/p>\n\n\n\n
Because of this, you should not use the fetchColumn()<\/code> to retrieve values from the boolean columns. The reason is that you won’t be able to know whether false<\/code> comes from the selected column or the result of no more rows.<\/p>\n\n\n\n
A fetchColumn() method example #<\/a><\/h2>\n\n\n\n
The following example uses the fetchColumn()<\/code> method to get the name of the publisher with id 1:<\/p>\n\n\n
<?php<\/span>\n\n$pdo = require<\/span> 'connect.php'<\/span>;\n\n$sql = 'SELECT name \n        FROM publishers \n        WHERE publisher_id = :publisher_id'<\/span>;\n\n$statement = $pdo->prepare($sql);\n$statement->execute(\n    ['publisher_id'<\/span> => 1<\/span>]\n);\n\n$publisher_name = $pdo->fetchColumn();\necho<\/span> $publisher_name;<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
How it works.<\/p>\n\n\n\n