Example #1
0
<?php

define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
$id = findIdByName('佳音服务');
$service_list = $id ? queryListByCatId($id) : array();
$smarty->assign('service_list', $service_list);
$smarty->display('service.dwt');
function findIdByName($cat_name)
{
    $sql = "SELECT cat_id FROM `ecs_article_cat` WHERE cat_name = '" . $cat_name . "'";
    return $GLOBALS['db']->getOne($sql);
}
function queryListByCatId($cat_id)
{
    $sql = 'SELECT cat_id,cat_name,keywords,cat_desc FROM ' . $GLOBALS['ecs']->table('article_cat') . ' WHERE parent_id = ' . $cat_id;
    $res = $GLOBALS['db']->getAll($sql);
    return $res;
}
Example #2
0
 * ECSHOP 文章内容
 * ============================================================================
 * * 版权所有 2005-2012 上海商派网络科技有限公司,并保留所有权利。
 * 网站地址: http://www.ecshop.com;
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用;不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * $Author: liubo $
 * $Id: article.php 17217 2011-01-19 06:29:08Z liubo $
 */
define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
$id = findIdByName('企业新闻');
$news = $id ? queryListByCatId($id) : array();
$id = findIdByName('企业公告');
$notice = $id ? queryListByCatId($id) : array();
$smarty->assign('news', $news);
$smarty->assign('notice', $notice);
$smarty->display('our.dwt');
function findIdByName($cat_name)
{
    $sql = "SELECT cat_id FROM `ecs_article_cat` WHERE cat_name = '" . $cat_name . "'";
    return $GLOBALS['db']->getOne($sql);
}
function queryListByCatId($cat_id)
{
    $sql = 'SELECT a.article_id, a.title, ac.cat_name, a.add_time, a.file_url, a.open_type, ac.cat_id, ac.cat_name, a.content ' . ' FROM ' . $GLOBALS['ecs']->table('article') . ' AS a, ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac' . " WHERE a.is_open = 1 AND a.cat_id = ac.cat_id AND ac.cat_id = {$cat_id}" . ' ORDER BY a.article_type DESC, a.add_time DESC LIMIT 2';
    $res = $GLOBALS['db']->getAll($sql);
    $arr = array();
    foreach ($res as $idx => $row) {
Example #3
0
 * $Author: liubo $
 * $Id: article.php 17217 2011-01-19 06:29:08Z liubo $
 */
define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
$id = $_REQUEST['id'] ? intval($_REQUEST['id']) : 0;
$cat_name = '';
if ($id == 1) {
    $cat_name = '企业新闻';
} elseif ($id == 2) {
    $cat_name = '企业公告';
} else {
    show_message('服务器找不到该资源');
    exit;
}
$cat_id = findIdByName($cat_name);
/* 获得当前页码 */
$page = !empty($_REQUEST['page']) && intval($_REQUEST['page']) > 0 ? intval($_REQUEST['page']) : 1;
/* 获得文章总数 */
$size = 4;
$count = get_article_count($cat_id);
$pages = $count > 0 ? ceil($count / $size) : 1;
if ($page > $pages) {
    $page = $pages;
}
$pager['search']['id'] = $cat_id;
$keywords = '';
$goon_keywords = '';
//继续传递的搜索关键词
/* 获得文章列表 */
if (isset($_REQUEST['keywords'])) {