Smarty如何从数据库读取图片（实例）

从页面上传图片到数据库见（http://blog.csdn.net/xtqueen_up/article/details/8292290）

 

<?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;
 
 }
 
$smarty->display("huoban.tpl");

?>

 

tpl文件：

    <{section name=n loop=$array2}>
    <img alt="" src="图片路径/<{$array2[n].logo}>" border="0">
    <{/section}>