PHP exhibition::getInfoList Exemples

Exemple #1

Fichier : relative.php Projet : TiMoChao/lc_ad_first

if (is_object($objWebInit)) {
    if (!isset($objexhibition)) {
        include_once __WEB_ROOT . "/exhibition/class/exhibition.class.php";
        include_once __WEB_ROOT . "/exhibition/config/var.inc.php";
        $objexhibition = new exhibition();
        $objexhibition->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objexhibition->db = $objWebInit->db;
        } else {
            $objexhibition->db();
        }
    }
    if (isset($arrInfo['tag']) && !empty($arrInfo['tag'])) {
        $arrTag = explode(',', $arrInfo['tag']);
        $where = array();
        foreach ($arrTag as $strTag) {
            $where[] = "'%" . $strTag . "%'";
        }
        //echo $arrInfo['id'];
        //print_r($where);
        $strWhere = implode(" || ", $where);
        $strWhere = 'where (tag like ' . $strWhere . ')';
    }
    //echo $strWhere;
    $arrRelative = array();
    $arrRelative = $objexhibition->getInfoList($strWhere . " and pass=1 and id!=" . $arrInfo['id'], " ORDER BY clicktimes DESC,submit_date DESC,recommendflag DESC,clicktimes DESC", 0, 5, true);
    unset($arrRelative['COUNT_ROWS']);
    //print_r($arrRelative);
    // 会展信息板
    $arrMOutput["smarty_assign"]['arrRelative'] = $arrRelative;
}

Exemple #2

Fichier : newest.php Projet : TiMoChao/lc_ad_first

<?php

/**
 * 会展信息 会展信息
 *
 * @author		Arthur(ArthurXF@gmail.com)
 * @copyright	(c) 2006 by bizeway.com
 * @version		$Id$
 * @package		ArthurXF
 * @subpackage	news
 */
if (is_object($objWebInit)) {
    if (!isset($objexhibition)) {
        include_once __WEB_ROOT . "/exhibition/class/exhibition.class.php";
        include_once __WEB_ROOT . "/exhibition/config/var.inc.php";
        $objexhibition = new exhibition();
        $objexhibition->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objexhibition->db = $objWebInit->db;
        } else {
            $objexhibition->db();
        }
    }
    $arrNewest = array();
    $arrNewest = $objexhibition->getInfoList("where pass=1", " ORDER BY clicktimes DESC,submit_date DESC,recommendflag DESC,clicktimes DESC", 0, 5, true);
    unset($arrNewest['COUNT_ROWS']);
    //print_r($arrNewest);
    // 会展信息板
    $arrMOutput["smarty_assign"]['arrNewest'] = $arrNewest;
}

Exemple #3

Fichier : index.php Projet : TiMoChao/lc_ad_first

        }
        if (!empty($_GET['type_id'])) {
            $intTypeID = intval($_GET['type_id']);
            $arrWhere[] = "type_id='" . $intTypeID . "' or type_roue_id like '%:{$intTypeID}:%'";
            $arrLink[] = 'type_id=' . $intTypeID;
        }
    } else {
        $objWebInit->doInfoAction($_GET['action'], $_POST['select']);
    }
}
$strWhere = implode(' AND ', $arrWhere);
$strWhere = " WHERE user_id='{$_SESSION['user_id']}'" . $strWhere;
if (!isset($_GET['page']) || $_GET['page'] == '') {
    $_GET['page'] = $arrGPage['page'];
}
$arrData = $objWebInit->getInfoList($strWhere, ' ORDER BY submit_date DESC', ($_GET['page'] - 1) * $arrGPage['page_size'], $arrGPage['page_size']);
if ($arrData == "") {
    $arrData = null;
}
//会展信息link
$strLink = '';
if (!empty($arrLink)) {
    $strLink = implode('&', $arrLink);
}
$strPage = $objWebInit->makeInfoListPage($arrData['COUNT_ROWS'], $strLink);
unset($arrData['COUNT_ROWS']);
// 会展信息题
if (is_array($arrMType) && !empty($arrMType)) {
    foreach ($arrData as $k => $data) {
        foreach ($arrMType as $k1 => $type) {
            if ($data['type_id'] == $k1) {

Exemple #4

Fichier : addinfo.php Projet : TiMoChao/lc_ad_first

$objWebInit->db();
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (empty($_POST['submitpass']) || $_POST['submitpass'] != $_SESSION['submitpasskey']) {
        exit;
    }
    if (empty($_POST['type_id']) || empty($_POST['title']) || empty($_POST['intro'])) {
        check::AlertExit("错误：有必填选项没填!", -1);
    }
    $arrTemp = explode('|', $_POST['type_id']);
    $_POST['type_id'] = $arrTemp[0];
    $_POST['type_roue_id'] = $arrTemp[1];
    if ($_POST['title'] != '') {
        $_POST['title_md5'] = md5($_POST['title']);
    }
    //判断文章信息
    $arrTemp = $objWebInit->getInfoList("where title_md5='{$_POST['title_md5']}' and user_id = '{$_SESSION['user_id']}' and type_id='{$_POST['type_id']}'", "", 0, 1);
    if ($arrTemp['COUNT_ROWS'] != 0) {
        check::AlertExit("错误：相同的信息请不要重复发布！需要刷新排列的话，请使用列表下方“提前”选项！", -1);
    }
    if ($_FILES['Filedata']['name'] != "") {
        $_POST['photo'] = $objWebInit->uploadInfoImage($_FILES['Filedata'], '', $_POST['FileListPicSize'], $_POST['csize0']);
    }
    //新图上传
    set_time_limit(0);
    foreach ($_FILES as $key => $val) {
        if (strrpos($key, 'Filedata') === false) {
            continue;
        }
        $num = substr($key, strlen('Filedata'));
        if (!empty($_FILES['Filedata' . $num]['name'])) {
            $arrTemp = array();

Exemple #5

Fichier : index.inc.php Projet : TiMoChao/lc_ad_first

require_once 'config/config.inc.php';
require_once "class/exhibition.class.php";
$objWebInit = new exhibition();
//会展信息接参数
$objWebInit->setDBG($arrGPdoDB);
//smarty参数
$objWebInit->arrGSmarty = $arrGSmarty;
//会展信息
$objWebInit->arrGPage = $arrGPage;
$objWebInit->db();
if (!is_array($arrMType) || empty($arrMType)) {
    $arrMType = $objWebInit->getTypeList();
    $arrMType = $objWebInit->formatTypeList(0, $arrMType);
}
foreach ($arrMType as $k => $v) {
    $arrTopexhibition[$k] = array();
    if (is_array($v)) {
        $arrTopexhibition[$k]['type_title'] = $v['type_title'];
        $arrTopexhibition[$k]['type_id'] = $v['type_id'];
    } else {
        $arrTopexhibition[$k]['type_title'] = $v;
        $arrTopexhibition[$k]['type_id'] = $k;
    }
    $arrTopexhibition[$k]['datas'] = $objWebInit->getInfoList("where pass=1 and type_id=" . $arrTopexhibition[$k]['type_id'], "  ORDER BY recommendflag DESC,clicktimes DESC,submit_date DESC", 0, 12, true, '', false);
}
//print_r($arrTopexhibition);
// 会展信息板
$arrMOutput["smarty_assign"]['arrMArea'] = $arrMArea;
$arrMOutput["smarty_assign"]['arrTopexhibition'] = $arrTopexhibition;
$arrMOutput["smarty_assign"]['MAIN'] = $arrGSmarty['main_dir'] . 'index.html';
$objWebInit->output($arrMOutput);

Exemple #6

Fichier : top_index.php Projet : TiMoChao/lc_ad_first

<?php

/**
 * 最会展信息讯文件
 *
 * @author		Arthur(ArthurXF@gmail.com)
 * @copyright	(c) 2006 by bizeway.com
 * @version		$Id$
 * @package		ArthurXF
 * @subpackage	exhibition
 */
if (is_object($objWebInit)) {
    if (!isset($objexhibition)) {
        include_once __WEB_ROOT . "/exhibition/class/exhibition.class.php";
        include_once __WEB_ROOT . "/exhibition/config/var.inc.php";
        $objexhibition = new exhibition();
        $objexhibition->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objexhibition->db = $objWebInit->db;
        } else {
            $objexhibition->db();
        }
    }
    $arrexhibitionList = array();
    $arrexhibitionList = $objexhibition->getInfoList("where pass=1", "  ORDER BY recommendflag DESC,submit_date DESC", 0, 5, true, null, false);
    //print_r($arrexhibitionList);
    //print_r($arrMArea);
    // 会展信息板
    $arrMOutput['smarty_assign']['arrMArea'] = $arrMArea;
    $arrMOutput["smarty_assign"]['arrexhibitionList'] = $arrexhibitionList;
}

Exemple #7

Fichier : search.php Projet : TiMoChao/lc_ad_first

        }
        $_SESSION['arrWhere'] = $arrWhere;
        $_SESSION['strKeywords'] = $strKeywords;
    }
    $arrLink[] = 'keywords=' . urlencode($strKeywords);
} else {
    if (empty($_REQUEST['keywords']) && $isGo) {
        check::AlertExit("错误：关键词必须填写!", -1);
    } else {
        $arrWhere = $_SESSION['arrWhere'];
        $strKeywords = $_SESSION['strKeywords'];
    }
}
$strWhere = implode(' AND ', $arrWhere);
$strWhere = 'where ' . $strWhere;
$arrInfoList = $objWebInit->getInfoList($strWhere, '  ORDER BY topflag DESC,submit_date DESC', ($intPage - 1) * $arrGPage['page_size'], $arrGPage['page_size']);
$intRows = $arrInfoList['COUNT_ROWS'];
unset($arrInfoList['COUNT_ROWS']);
//会展信息link
$strPage = $objWebInit->makeInfoListPage($intRows, $strLink, $link_type = $arrGWeb['URL_static']);
// 会展信息板
$arrMOutput["smarty_assign"]['arrInfoList'] = $arrInfoList;
$arrMOutput["smarty_assign"]['strPage'] = $strPage;
$arrMOutput["smarty_assign"]['page'] = $intPage;
$arrMOutput["smarty_assign"]['arrMType'] = $arrMType;
$arrMOutput["smarty_assign"]['strKeywords'] = $strKeywords;
$arrMOutput["smarty_assign"]['strSearchTitle'] = $strKeywords . "会展信息";
$arrMOutput['smarty_assign']['Title'] = $strKeywords . '会展信息 - ' . $arrGWeb['name'];
$arrMOutput['smarty_assign']['Description'] = $strKeywords . '会展信息 - ' . $arrGWeb['name'];
$arrMOutput['smarty_assign']['Keywords'] = $strKeywords . '会展信息 - ' . $arrGWeb['name'];
$arrMOutput["smarty_assign"]['MAIN'] = $arrGSmarty['main_dir'] . 'list.html';

Exemple #8

Fichier : top.php Projet : TiMoChao/lc_ad_first

<?php

/**
 * 会展信息文件
 *
 * @author		Arthur(ArthurXF@gmail.com)
 * @copyright	(c) 2006 by bizeway.com
 * @version		$Id$
 * @package		ArthurXF
 * @subpackage	exhibition
 */
if (is_object($objWebInit)) {
    if (!isset($objexhibition)) {
        include_once __WEB_ROOT . "/exhibition/class/exhibition.class.php";
        include_once __WEB_ROOT . "/exhibition/config/var.inc.php";
        $objexhibition = new exhibition();
        $objexhibition->setDBG($arrGPdoDB);
        if (is_object($objWebInit->db)) {
            $objexhibition->db = $objWebInit->db;
        } else {
            $objexhibition->db();
        }
    }
    $arrTopexhibition = array();
    $arrTopexhibition = $objexhibition->getInfoList("where pass=1", "  ORDER BY recommendflag DESC,clicktimes DESC,submit_date DESC", 0, 15, true);
    unset($arrTopexhibition['COUNT_ROWS']);
    // print_r($arrTopexhibition);
    // 会展信息板
    $arrMOutput["smarty_assign"]['arrTopexhibition'] = $arrTopexhibition;
}