</ul> </div> <{/foreach}>以上部分都正常,现在是想在下面这个函数里调用一个模板变量,应该怎么写呢? function get_picture($tagid) { // query database for the books in a category if (!$tagid || $tagid=='') return false; $db = new db; $connect = $db->connect(); $query="SELECT picture FROM `tags` where id=$tagid"; $tag_result=$db->query($query); $tags=$db->fetch_assoc($tag_result); return $tags; }
=====================
$archives['title'];
<?php
$archives_array = get_archives_list();
$tpl->assign("archives_array", $archives_array);
$tpl->display('archives.tpl');
?>
<?php
function get_archives_list()
{
$db = new db;
$connect = $db->connect();
$query = "SELECT id,name,title,info,ip,time_at,tags,tag_id FROM `archives` ORDER BY `id` DESC";
$result = $db->query($query);
if (!$result)
return false;
$num_cats = $db->num_rows($query);
if ($num_cats ==0)
return false;
$result = db_result_array($result);
return $result;
} function db_result_array($result)
{
$res_array = array();
for ($count=0; $row = mysql_fetch_assoc($result); $count++)
$res_array[$count] = $row; return $res_array;
}
?>archives.tpl部分代码
<{foreach from=$archives_array item="archives"}>
<div class="post">
<ul>
<div class="title"><{$archives.title|capitalize}></div>
</ul>
</div>
<{/foreach}>以上部分都正常,现在是想在下面这个函数里调用一个模板变量,应该怎么写呢?
function get_picture($tagid)
{
// query database for the books in a category
if (!$tagid || $tagid=='')
return false;
$db = new db;
$connect = $db->connect();
$query="SELECT picture FROM `tags` where id=$tagid";
$tag_result=$db->query($query);
$tags=$db->fetch_assoc($tag_result);
return $tags;
}