PHP PDO Fetch Methods

Welcome to our deep dive into PHP PDO Fetch Methods! In this comprehensive lesson, we'll explore how to work with database records using PHP Data Objects (PDO) and its various fetch methods.

By the end of this tutorial, you'll have a solid understanding of the key fetch methods and their applications in real-world scenarios. Let's get started! 🎯

What are PDO Fetch Methods?

PDO Fetch Methods are used to extract rows from the result set of a SQL query. They help us to interact with the data in a convenient way and fetch the data as needed.

In this lesson, we'll cover the following fetch methods:

fetch()
fetchAll()
fetchObject()
fetchColumn()

Fetch()

fetch() is a simple method that retrieves the next row from the result set. If there are no more rows, it returns FALSE.

📝 Note: It's important to free the memory by calling free() after using the fetch() method.

php

$stmt = $pdo->query('SELECT * FROM users');
$row = $stmt->fetch();

if ($row) {
    echo $row['name'];
    $stmt->free();
} else {
    echo "No rows found.";
}

FetchAll()

fetchAll() retrieves all the rows from the result set as an associative array, an indexed array, or an object array. By default, it returns an associative array.

php

$stmt = $pdo->query('SELECT * FROM users');
$users = $stmt->fetchAll();

foreach ($users as $user) {
    echo $user['name'];
}

FetchObject()

fetchObject() retrieves the next row from the result set as a PHP standard object. This can be particularly useful when dealing with complex data structures where the objects have multiple properties.

php

$stmt = $pdo->query('SELECT * FROM users');
$user = $stmt->fetchObject('User');

echo $user->name;

In the above example, we assume that a class named User exists with properties matching the column names in the users table.

FetchColumn()

fetchColumn() retrieves a single column from the result set as an array. It's useful when you only need a single column's data.

php

$stmt = $pdo->query('SELECT name FROM users');
$names = $stmt->fetchColumn();

foreach ($names as $name) {
    echo $name;
}

Quiz

That's it for our PHP PDO Fetch Methods tutorial! Practice using these methods in your projects and explore more advanced concepts as you grow your PHP skills. Happy coding! 💡