举个简单的例子,我在php里面有写一个
“select * from table where pid=1”
“select * from table where pid=2”
“select * from table where pid=3”那么我在模板里面就会分别调取用到这三个。
{foreach from=$pid_01 item=list}
{$list.title}
{/foreach}
{foreach from=$pid_02 item=list}
{$list.title}
{/foreach}
{foreach from=$pid_03 item=list}
{$list.title}
{/foreach}我能不能直接在php里面
“select * from table”然后在模板里面去设定条件?
“select * from table where pid=1”
“select * from table where pid=2”
“select * from table where pid=3”那么我在模板里面就会分别调取用到这三个。
{foreach from=$pid_01 item=list}
{$list.title}
{/foreach}
{foreach from=$pid_02 item=list}
{$list.title}
{/foreach}
{foreach from=$pid_03 item=list}
{$list.title}
{/foreach}我能不能直接在php里面
“select * from table”然后在模板里面去设定条件?
不是特别的理解,能稍微详细一点吗?
$db->Query("list_01","select * from table where pid =8");
while($list_arr=$db->GetArray("list_01"))
{
$list_01[] = $list_arr;
}
$qf->assign("list_01",$list_01);$db->Query("list_02","select * from table where pid =8");
while($list_arr=$db->GetArray("list_02"))
{
$list_02[] = $list_arr;
}
$qf->assign("list_02",$list_02);$db->Query("list_03","select * from table where pid =8");
while($list_arr=$db->GetArray("list_03"))
{
$list_03[] = $list_arr;
}
$qf->assign("list_03",$list_03);
{foreach from=$list_01 item=list}
{$list.title}
{/foreach}
{foreach from=$list_02 item=list}
{$list.title}
{/foreach}
{foreach from=$list_03 item=list}
{$list.title}
{/foreach}
上面的是我现在的代码,如果我想只在php里面取一次的话,模板里面应该怎么写呢?$db->Query("list","select * from table where pid =8");
while($list_arr=$db->GetArray("list"))
{
$list[] = $list_arr;
}
$qf->assign("list",$list);
如果我想只在php里面取一次的话,模板里面应该怎么写呢?$db->Query("list","select * from table");
while($list_arr=$db->GetArray("list"))
{
$list[] = $list_arr;
}
$qf->assign("list",$list);
像这样的话我一次就在php里面全部取出来了,应该在模板里面怎么样写才能把"where pid = 8","where pid = 9","where pid = 10"这样个意思的限制条件加进去呢?
{foreach from=$pid item=list}
{if $list.qid eq "1"}
....
{elseif $list.qid eq "2"}
....
{else}
....
{/if}
{/foreach}
{section name=lt loop=$list}
{if $list[lt].id eq "1"}
……
{/if}
{if $list[lt].id eq "2"}
……
{/if}
{/section}