I take data from DB through PDO and I can't show all of data in HTML with Twig, but only first row showed. Help, please.
function listOfTasksWithSort ($pdo, $user,$sortStyle) {
$sortStyleOrder = isset($sortStyle) ? $sortStyle : '';
if (empty($sortStyleOrder)) {
return $pdo->query("SELECT id, user_id, assigned_user_id, description, is_done, date_added FROM task WHERE user_id = '$user'");
} else {
return $pdo->query("SELECT id, user_id, assigned_user_id, description, is_done, date_added FROM task WHERE user_id = '$user' ORDER BY $sortStyle ASC");
}
}
$listOfTasks = listOfTasksWithSort ($pdo, $_SESSION['userId'],$sortStyle);
$template = $twig->loadTemplate('index.tmpl');
echo $template->render(array(
'row' => $listOfTasks->fetch(),
));
{% for i in 1..10000 if row %}
{{ row.description }}
{% set row = false %}
{% endfor %}