แต่ใช้คำสั่งต่างๆในส่วนของ Controller เช่น sql ทำให้ส่งค่าไปที่ Template ไม่ได้
Code: Select all
$sql_ary = array(
'SELECT' => '*',
'FROM' => array(
'phpbb_m_check_pass' => 't',
),
'ORDER_BY' => 'id DESC LIMIT 1'
);
$sql = $db->sql_build_query('SELECT', $sql_ary);
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$id = $row['id'];
$template->assign_vars(array(
'ID' => $id,
'USERNAME' => $row['username_check'],
'PASSWORD' => $row['password_check'],
'TELL' => $row['tell'],
'PASSDUP' => $row['pass_duplicate'],
));
}