欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

phpli联接一个表,让他安不同的方循环出来

程序员文章站 2022-05-13 16:46:18
...
phpli连接一个表,让他安不同的方循环出来
php文件
$sql = "SELECT * FROM `pp_vod` where vod_cid = 8 order by vod_addtime LIMIT 0 , 12";
$query = mysql_query($sql);
$i = mysql_num_rows($query);
$j = 0;
while($a = mysql_fetch_array($query)){
if ( $j
$id[$j] = $a['vod_id'];
$area[$j] = $a['vod_area'];
$hits[$j] = $a['vod_hits'];
$title[$j] = $a['vod_name'];
$author[$j] = $a['vod_actor'];
$authoreml[$j] = $a['authoreml'];
$putdate[$j] = $a['vod_addtime'];
$pic[$j] = $a['vod_pic'];
$cat[$j] = $a['vod_cid'];
$content[$j] = $a['vod_content'];

$j++;
}
}



$t->set_file("main","3333.htm");


$t -> set_block("main","row","rows");
for($j = 0; $j $t -> set_var(array("authoreml" => $authoreml[$j],
"author" => $author[$j],
"id" => $id[$j],
"title" => $title[$j],
"putdate" => $putdate[$j],
"pic" =>$pic[$j]));
$t -> parse("rows","row",ture);
}

$t->parse("out","main",true);
/*
此方法共有三个参数,目前我们先只用前两个.第一个参数为一会要输出的名称,第二个参数为之前定义模板文件时的名称.
*/
//输出
$t->p("out");
模板文件