PDO Return All Rows [duplicate]

Question

So, right now I have a PHP function that utilizes PDO to return the first row of a specific table. That works fine, but I want to return all of the information, while being able to organize it all.

I have the table zip__admins and I'm trying to return the first_name and last_name from the table. With this information, I have a button on the login page asking the user to select their name (each person gets their own button) to sign in. As of now, I'm returning one result, instead of two results. How can I modify the below code to return two results, and input the data into a templating parameter.

final public function fetchAdminInfo() {
    global $zip, $db, $tpl;

    $query = $db->prepare('SELECT first_name, last_name FROM zip__admins');
    $query->execute();

    $result = $query->fetch(PDO::FETCH_ASSOC);

    $tpl->define('admin: first_name', $result['first_name']);
    $tpl->define('admin: last_name', $result['last_name']);
}

Here is my table: ![SQL Table][1]

Answer 1

You need to use fetchAll()

$result = $query -> fetchAll();

foreach( $result as $row ) {
    echo $row['first_name'];
    echo $row['last_name'];
}