Home >Backend Development >PHP Tutorial > smarty 数据库查询有关问题

smarty 数据库查询有关问题

WBOY
WBOYOriginal
2016-06-13 13:53:33798browse

smarty 数据库查询问题
function class_id(){
if(!empty($_GET['class_id'])){
$sql="select * from goods_class as a,goods_detail as b where a.id=b.class_id and a.id='$_GET[class_id]'";
$query=mysql_query($sql);
while($row_class=mysql_fetch_array($query)){
$sm_class[]=array("name"=>$row_class['goods_name'],"id"=>$row_class['id'],"picture"=>$row_class['picture']);

  }
}
return $sm_class;
//print_r($sm_class);
}

class_id();
$smarty->assign("sm_class",$sm_class);

if语句放到方法外可以再html中正常显示,上面这样写则不行,为什么?

------解决方案--------------------
$sm_class =class_id();
$smarty->assign("sm_class",$sm_class);

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn