Smarty Template Engine从数据库中获取单行并使用这些字段

Question

I am new to smarty and stepped into a problem. As per their manual if I fetch data from the database and want to display it in a loop then I can easily use the foreach function but here I want to transfer the values of single row and use them on the tpl page using if else. How can I transfer the value and use them without using foreach for a single row?

My server side code

$verify = $pdo->prepare("SELECT ver_code, ver_validity FROM verification WHERE ver_user = :user");
$verify-> bindValue(':user', $_GET['user']);
$verify-> execute();
//   $vf = $verify->fetch();
//   $code = $vf['ver_code'];
//   $expiry = $vf['ver_validity'];

$smarty->assign('verify', $vf);

$smarty->display('reset.tpl');

I want to send the values coming from database to the presentation code and use them using the if else statement. Please help me on solving this issue.

Answer 1

Fetch one single row:

$vf = $verify->fetch();

Assign it to Smarty variable:

$smarty->assign('verify', $vf);

Use it in the Smarty template like:

{$verify.ver_code}
{$verify.ver_validity}

Inside an if statement:

{if $verify.ver_code eq "abcdefg"}

Hope this helps.