Smarty从数据库中提取图片显示到页面（实例）

PHP 文件：

 

<?php
include("libs/Smarty.class.php");
$smarty=new Smarty();
$smarty->template_dir="demo/templates";
$smarty->compile_dir="demo/templates_c";
$smarty->left_delimiter="<{";
$smarty->right_delimiter="}>";
$smarty->config_dir="demo/config";
//$smarty->caching=true;//开启缓存
//$smarty->cache_dir="../demo/cache";//缓存文件存放的路径

$array2=array();
mysql_connect("localhost","root","123");
mysql_select_db("fanyi");
mysql_query("set names utf8");
$q="select * from tupian order by id desc limit 1 ";
$result=mysql_query($q);
while($row=mysql_fetch_assoc($result)){
 $array2[]=$row;
 
 }
 
//print_r ($array2);
$smarty->assign("array2",$array2);
$smarty->display("huoban.tpl");

?>

TPL文件：

 <div id="articeBottom">
<{section name=new loop=$array}>

<{$array[new].content}>

<{/section}>
 </div><p>
    <{section name=n loop=$array2}>
    <img alt="" src="../../../fanyi/admin/<{$array2[n].logo}>" border="0">
  
   <{/section}>
</p></div>