dtgj8529 2017-02-02 17:58
浏览 31

在Twig中获取PDO

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 %}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 想问一下树莓派接上显示屏后出现如图所示画面,是什么问题导致的
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号