Fetch modes determine the shape of the rows read: FETCH_ASSOC gives an associative array, FETCH_NUM an indexed array, FETCH_OBJ an object, FETCH_CLASS a class instance. fetch reads one row, fetchAll all of them, fetchColumn a single value.
Example
$lignes = $stmt->fetchAll(PDO::FETCH_ASSOC);