#1 小双
我使用的代码:head_picture.php页面,
$query="select * from zc_commodity where tb_commodity_id=".$recid;
$result=mysql_query($query);
if(!$result) die("error: mysql query");
$num=mysql_num_rows($result);
if($num<1) die("error: no this recorder");
$data = mysql_result($result,0,"tb_commodity_picture");
mysql_close($conn);
echo $data;
?>
smarty模板调用页面index.html:
conn.php页面:
$conn=mysql_connect("localhost","root","root") or die('连接失败:' . mysql_error());
if(mysql_select_db("shopzc",$conn))
echo "";
else
echo ('数据库选择失败:' . mysql_error());
mysql_query("set names gb2312");
?>
上面是可以显示的,如何使用sp把上面head_picture.php页面里的代码放在controller文件夹里的main.php页面里面:
这个是我写的,没有做出来,不明白上面的data如何输出?
class main extends spController
{
function img(){
$recid = $this->spArgs('tb_commodity_id');
$result = $gb->find(array('tb_commodity_id'=>$recid),"tb_commodity_id DESC",NULL) or $this->error('未定义的图片');
$num=count($result);
if($num<1) die("error: no this recorder");
$this->data = $result['tb_commodity_picture'];
$this->display("index.html");
}
}
2010-07-22 18:16:04