首页 > 代码库 > smarty 数据库整理

smarty 数据库整理

获取栏目的class信息 bname btitle

public function user_getclassinfo($classid){	$query = "select c1.classurl,c1.filetype,c2.cnavname,c2.cnavurl,c1.classimg,c1.intro,c1.bname,c1.classpagekey,c1.classname,c1.sonclass from kk_enewsclass as c1,kk_enewsclassadd as c2 where c1.classid = c2.classid and c1.classid = $classid";	$command = $this->connection->createCommand($query);	$classdata =  http://www.mamicode.com/$command->queryAll();"classid"]=$classid;	return $classdata;}

 

smarty 数据库整理