mybiz.php

城市分类信息,门户网站,我做为地方信息网

<?php



define('CURSCRIPT', 'mybiz');

require_once '../include/common.php';

if(empty($cbc_uid)) {
	redirect('璇峰厛鐧婚檰', '../user/login.php');
}

$bizid = 0;

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

if($bizid) {
	$page = intval($page);
	$page = $page ? $page : 1;
	$start = ($page==1)? 0 : ($page-1) * $webbizlist;
	
	$query = $DB->query("SELECT bizid FROM {$tablepre}bizinfo WHERE bizid IN ($bizid)");
	$num = $DB->num_rows($query);
	$page = commonPage($page, $num, '../user/mybiz.php?action=biz', $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(nl2br($rs['biz_intro']), 100);
		$bizlist[] = $rs;	
	}

}
include showPage('mybiz');
?>