userinfo_biz.php

来自「城市分类信息,门户网站,我做为地方信息网」· PHP 代码 · 共 33 行

<?php



$query = $DB->query("SELECT bizid FROM {$tablepre}bizboss WHERE ischeck='1' AND uid='$uid'");
while($rs = $DB->fetch_array($query)) {
	$bizid .= $rs['bizid'] . ',';
}
$bizid = preg_replace("/(.+?),/U", "\\1", $bizid);



$page = intval($page);
$page = $page ? $page : 1;
$start = ($page==1)? 0 : ($page-1) * $webbizlist;

if($bizid) {
	
	$query = $DB->query("SELECT bizid FROM {$tablepre}bizinfo WHERE bizid IN ($bizid)");
	$num = $DB->num_rows($query);
	$page = commonPage($page, $num, '../user/userinfo.php?action=biz&uid='.$uid, $webbizlist);
	
	
	$query = $DB->query("SELECT bizid, biz_name, biz_photo, biz_intro FROM {$tablepre}bizinfo WHERE bizid IN ($bizid) LIMIT $start, $webbizlist");
	while($rs = $DB->fetch_array($query)) {
		$rs['biz_photo'] = empty($rs['biz_photo']) ? WEB_URL . 'images/common/noimg.jpg' : WEB_URL . 'webdata/biz_images/'.$rs['biz_photo'];
		$rs['biz_intro'] = cutstr($rs['biz_intro'], 108);
		$bizlist[] = $rs;
	}

}
include showPage('userinfo_biz');
?>