PHP get_article_children函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中get_article_children函数的典型用法代码示例。如果您正苦于以下问题：PHP get_article_children函数的具体用法？PHP get_article_children怎么用？PHP get_article_children使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了get_article_children函数的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: get_article_count

/**
 * 获得指定分类下的文章总数
 *
 * @param   integer     $cat_id
 *
 * @return  integer
 */
function get_article_count($cat_id, $requirement = '')
{
    global $db, $ecs;
    if ($requirement != '') {
        $count = $db->getOne('SELECT COUNT(*) FROM ' . $ecs->table('ecsmart_article') . ' WHERE ' . get_article_children($cat_id) . ' AND  title like \'%' . $requirement . '%\'  AND is_open = 1');
    } else {
        $count = $db->getOne("SELECT COUNT(*) FROM " . $ecs->table('ecsmart_article') . " WHERE " . get_article_children($cat_id) . " AND is_open = 1");
    }
    return $count;
}

开发者ID:seanguo166，项目名称:yinoos，代码行数:17，代码来源:lib_article.php

示例2: get_articleslist

function get_articleslist()
{
    $result = get_filter();
    if ($result === false) {
        $filter = array();
        $filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
        if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
            $filter['keyword'] = json_str_iconv($filter['keyword']);
        }
        $filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']);
        $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.article_id' : trim($_REQUEST['sort_by']);
        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
        $where = '';
        if (!empty($filter['keyword'])) {
            $where = " AND a.title LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
        }
        if ($filter['cat_id']) {
            $where .= " AND a." . get_article_children($filter['cat_id']);
        }
        /* 文章总数 */
        $sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where;
        $filter['record_count'] = $GLOBALS['db']->getOne($sql);
        $filter = page_and_size($filter);
        /* 获取文章数据 */
        $sql = 'SELECT a.* , ac.cat_name ' . 'FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
        $filter['keyword'] = stripslashes($filter['keyword']);
        set_filter($filter, $sql);
    } else {
        $sql = $result['sql'];
        $filter = $result['filter'];
    }
    $arr = array();
    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
    while ($rows = $GLOBALS['db']->fetchRow($res)) {
        $rows['date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['add_time']);
        $arr[] = $rows;
    }
    return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}

开发者ID:norain2050，项目名称:mhFault，代码行数:39，代码来源:article.php

示例3: while

     if ($res !== false) {
         while ($row = $db->fetchRow($res)) {
             $item_url = 'package.php';
             $separator = strpos($item_url, '?') === false ? '?' : '&amp;';
             $about = $uri . $item_url;
             $title = htmlspecialchars($row['act_name']);
             $link = $uri . $item_url . $separator . 'from=rss';
             $desc = htmlspecialchars($row['act_desc']);
             $subject = $_LANG['remark_package'];
             $date = local_date('r', $row['start_time']);
             $rss->addItem($about, $title, $link, $desc, $subject, $date);
         }
         $rss->outputRSS($ver);
     }
 } elseif (substr($_REQUEST['type'], 0, 11) == 'article_cat') {
     $sql = 'SELECT article_id, title, author, add_time' . ' FROM ' . $GLOBALS['ecs']->table('article') . ' WHERE is_open = 1 AND ' . get_article_children(substr($_REQUEST['type'], 11)) . ' ORDER BY add_time DESC LIMIT ' . $_CFG['article_page_size'];
     $res = $db->query($sql);
     if ($res !== false) {
         while ($row = $db->fetchRow($res)) {
             $item_url = build_uri('article', array('aid' => $row['article_id']), $row['title']);
             $separator = strpos($item_url, '?') === false ? '?' : '&amp;';
             $about = $uri . $item_url;
             $title = htmlspecialchars($row['title']);
             $link = $uri . $item_url . $separator . 'from=rss';
             $desc = '';
             $subject = htmlspecialchars($row['author']);
             $date = local_date('r', $row['add_time']);
             $rss->addItem($about, $title, $link, $desc, $subject, $date);
         }
         $rss->outputRSS($ver);
     }

开发者ID:firsteam，项目名称:falcons，代码行数:31，代码来源:feed.php

示例4: get_cat_articles

/**
 * 获得文章分类下的文章列表
 *
 * @access  public
 * @param   integer     $cat_id
 * @param   integer     $page
 * @param   integer     $size
 *
 * @return  array
 */
function get_cat_articles($cat_id, $page = 1, $size = 20, $requirement = '')
{
    //取出所有非0的文章
    if ($cat_id == '-1') {
        $cat_str = 'cat_id > 0';
    } else {
        $cat_str = get_article_children($cat_id);
    }
    //增加搜索条件，如果有搜索内容就进行搜索
    if ($requirement != '') {
        $sql = 'SELECT article_id, title, author, add_time, file_url, open_type' . ' FROM ' . $GLOBALS['ecs']->table('article') . ' WHERE is_open = 1 AND title like \'%' . $requirement . '%\' ' . ' ORDER BY article_type DESC, article_id DESC';
    } else {
        $sql = 'SELECT article_id, title, author, add_time, file_url, open_type' . ' FROM ' . $GLOBALS['ecs']->table('article') . ' WHERE is_open = 1 AND ' . $cat_str . ' ORDER BY article_type DESC, article_id DESC';
    }
    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);
    $arr = array();
    if ($res) {
        while ($row = $GLOBALS['db']->fetchRow($res)) {
            $article_id = $row['article_id'];
            $arr[$article_id]['id'] = $article_id;
            $arr[$article_id]['title'] = $row['title'];
            $arr[$article_id]['short_title'] = $GLOBALS['_CFG']['article_title_length'] > 0 ? sub_str($row['title'], $GLOBALS['_CFG']['article_title_length']) : $row['title'];
            $arr[$article_id]['author'] = empty($row['author']) || $row['author'] == '_SHOPHELP' ? $GLOBALS['_CFG']['shop_name'] : $row['author'];
            $arr[$article_id]['url'] = $row['open_type'] != 1 ? build_uri('article', array('aid' => $article_id), $row['title']) : trim($row['file_url']);
            $arr[$article_id]['add_time'] = date($GLOBALS['_CFG']['date_format'], $row['add_time']);
        }
    }
    return $arr;
}

开发者ID:norain2050，项目名称:mhFault，代码行数:39，代码来源:index.php

示例5: htmlspecialchars

                $link     = $uri . $item_url . $separator . 'from=rss';
                $desc     = htmlspecialchars($row['act_desc']);
                $subject  = $_LANG['remark_package'];
                $date     = local_date('r', $row['start_time']);

                $rss->addItem($about, $title, $link, $desc, $subject, $date);
            }

            $rss->outputRSS($ver);
        }
    }
    elseif(substr($_REQUEST['type'], 0, 11) == 'article_cat')
    {
        $sql = 'SELECT article_id, title, author, add_time' .
               ' FROM ' .$GLOBALS['ecs']->table('article') .
               ' WHERE is_open = 1 AND ' . get_article_children(substr($_REQUEST['type'], 11)) .
               ' ORDER BY add_time DESC LIMIT ' . $_CFG['article_page_size'];
        $res = $db->query($sql);

        if ($res !== false)
        {
            while ($row = $db->fetchRow($res))
            {
                $item_url = build_uri('article', array('aid' => $row['article_id']), $row['title']);
                $separator = (strpos($item_url, '?') === false)? '?' : '&amp;';
                $about    = $uri . $item_url;
                $title    = htmlspecialchars($row['title']);
                $link     = $uri . $item_url . $separator . 'from=rss';
                $desc     = '';
                $subject  = htmlspecialchars($row['author']);
                $date     = local_date('r', $row['add_time']);

开发者ID:xiaoxiaowu007，项目名称:jicai，代码行数:31，代码来源:feed.php

示例6: get_article_count

/**
 * 获得指定分类下的文章总数
 *
 * @param   integer     $cat_id
 *
 * @return  integer
 */
function get_article_count($cat_id)
{
    global $db, $ecs;
    $count = $db->getOne("SELECT COUNT(*) FROM " . $ecs->table('article') . " WHERE " . get_article_children($cat_id) . " AND is_open = 1");
    return $count;
}

开发者ID:BGCX261，项目名称:zishashop-svn-to-git，代码行数:13，代码来源:lib_article.php

示例7: get_articles_list

function get_articles_list($cat_id = 0, $page_size = 20, $is_important = -1, $keyword = '', $sort_by = 'a.article_id', $sort_order = 'DESC')
{
    $filter = array();
    $filter['keyword'] = $keyword;
    $filter['cat_id'] = $cat_id;
    $filter['sort_by'] = $sort_by;
    $filter['sort_order'] = $sort_order;
    $filter['page_size'] = $page_size;
    $where = '';
    if (!empty($filter['keyword'])) {
        $where = " AND a.title LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
    }
    if ($filter['cat_id']) {
        $where .= " AND a." . get_article_children($filter['cat_id']);
    }
    if ($is_important > -1) {
        $where .= " AND a.is_important=" . $is_important . " ";
    }
    /* 文章总数 */
    $sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE is_open=1  ' . $where;
    $filter['record_count'] = $GLOBALS['db']->getOne($sql);
    $filter = page_and_size_new($filter);
    /* 获取文章数据 */
    $sql = 'SELECT a.* , ac.cat_name ' . 'FROM ' . $GLOBALS['ecs']->table('article') . ' AS a ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('article_cat') . ' AS ac ON ac.cat_id = a.cat_id ' . 'WHERE is_open=1  ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'];
    $filter['keyword'] = stripslashes($filter['keyword']);
    $arr = array();
    $res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
    while ($rows = $GLOBALS['db']->fetchRow($res)) {
        $rows['date'] = local_date('Y-m-d', $rows['add_time']);
        $rows['add_time'] = local_date('Y-m-d H:i:s', $rows['add_time']);
        $rows['alt'] = $rows['title'];
        $rows['short_title'] = sub_str($rows['title'], 13);
        $rows['middle_title'] = sub_str(${$rows}['title'], 16);
        $arr[] = $rows;
    }
    return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
}

开发者ID:dalinhuang，项目名称:hteacher，代码行数:37，代码来源:lib_new_common.php

示例8: get_articleslist

 function get_articleslist($offset)
 {
     $result = get_filter();
     if ($result === false) {
         $filter = array();
         $filter['keyword'] = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);
         if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1) {
             $filter['keyword'] = json_str_iconv($filter['keyword']);
         }
         $filter['cat_id'] = empty($_REQUEST['cat_id']) ? 0 : intval($_REQUEST['cat_id']);
         $filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'a.article_id' : trim($_REQUEST['sort_by']);
         $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
         $where = '';
         if (!empty($filter['keyword'])) {
             $where = " AND a.title LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";
         }
         if ($filter['cat_id']) {
             $where .= " AND a." . get_article_children($filter['cat_id']);
         }
         /* 文章总数 */
         $sql = 'SELECT COUNT(*)as count FROM ' . $this->pre . 'touch_article AS a ' . 'LEFT JOIN ' . $this->pre . 'touch_article_cat AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where;
         $res = $this->row($sql);
         $filter['record_count'] = $res['count'];
         $filter = page_and_size($filter);
         /* 获取文章数据 */
         $sql = 'SELECT a.* , ac.cat_name ' . 'FROM ' . $this->pre . 'touch_article AS a ' . 'LEFT JOIN ' . $this->pre . 'touch_article_cat AS ac ON ac.cat_id = a.cat_id ' . 'WHERE 1 ' . $where . ' ORDER by ' . $filter['sort_by'] . ' ' . $filter['sort_order'] . ' LIMIT ' . $offset;
         $filter['keyword'] = stripslashes($filter['keyword']);
         set_filter($filter, $sql);
     } else {
         $sql = $result['sql'];
         $filter = $result['filter'];
     }
     $arr = array();
     $res = $this->query($sql);
     foreach ($res as $rows) {
         $rows['date'] = local_date(C('time_format'), $rows['add_time']);
         $arr[] = $rows;
     }
     return array('arr' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
 }

开发者ID:pf5512，项目名称:ViciEctouch，代码行数:40，代码来源:ArticleBaseModel.class.php

示例9: get_cat_new_arts

function get_cat_new_arts($cat_id, $num)
{
    if ($cat_id == "-1") {
        $cat_str = "cat_id > 0";
    } else {
        $cat_str = get_article_children($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  FROM " . $GLOBALS['ecs']->table("article") . " AS a, " . $GLOBALS['ecs']->table("article_cat") . " AS ac WHERE a.is_open = 1 and a.article_type = 0 AND a.cat_id = ac.cat_id AND ac.cat_type = 1 AND a." . $cat_str . " ORDER BY a.add_time DESC LIMIT " . $num;
    $res = $GLOBALS['db']->getAll($sql);
    $arr = array();
    foreach ($res as $idx => $row) {
        $arr[$idx]['id'] = $row['article_id'];
        $arr[$idx]['title'] = $row['title'];
        $arr[$idx]['short_title'] = 0 < $GLOBALS['_CFG']['article_title_length'] ? sub_str($row['title'], $GLOBALS['_CFG']['article_title_length']) : $row['title'];
        $arr[$idx]['cat_name'] = $row['cat_name'];
        $arr[$idx]['add_time'] = local_date($GLOBALS['_CFG']['date_format'], $row['add_time']);
        $arr[$idx]['url'] = $row['open_type'] != 1 ? build_uri("article", array("aid" => $row['article_id']), $row['title']) : trim($row['file_url']);
        $arr[$idx]['cat_url'] = build_uri("article_cat", array("acid" => $row['cat_id']), $row['cat_name']);
    }
    return $arr;
}

开发者ID:seanguo166，项目名称:yinoos，代码行数:21，代码来源:init.php

注：本文中的get_article_children函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP get_article_count函数代码示例发布时间：2022-05-15

PHP get_article函数代码示例发布时间：2022-05-15

CVE-2020-35163

1 dphi-official/Machine_Learning_Bootcamp

dphi-official/Machine_Learning_Bootcamp

阅读：1436|2022-08-18

2 delphi自定义窗口消息

假设你的消息这样定义： Const WM_YOURMSG=WM_USER+100; 你的过程定义

阅读：600|2022-07-18

3 juven/maven-bash-completion: Maven Bash

juven/maven-bash-completion: Maven Bash Auto Completion

阅读：859|2022-08-16

4 route101/mastoinker: Quick image view as

route101/mastoinker: Quick image view assistant for Mastodon client

阅读：971|2022-08-18

5 MATLAB地图工具箱学习总结（三）地图工具箱

MATLAB地图工具箱学习总结（三）地图工具箱的基本知识 MATLAB地图工具箱学习总结系列

阅读：883|2022-07-18

6 配置VLFeat-0.9.20+MATLAB2013a

在VLFeat官网上是这么介绍VLFeat的：VLFeat开源库实现了流行的计算机视觉算法，专门从

阅读：930|2022-07-18

7 CVE-2022-34819

A vulnerability has been identified in SIMATIC CP 1242-7 V2 (All versions), SIMA

阅读：752|2022-07-29

8 0e0w · GitHub

0e0w · GitHub

阅读：453|2022-08-15

9 tgreyuk/typedoc-plugin-markdown: A plugi

tgreyuk/typedoc-plugin-markdown: A plugin for TypeDoc that enables TypeScript AP

阅读：856|2022-08-18

10 CVE-2022-1325

A flaw was found in Clmg, where with the help of a maliciously crafted pandore o

阅读：1545|2022-09-18

客服电话

电子邮件

PHP get_article_children函数代码示例

示例1: get_article_count

示例2: get_articleslist

示例3: while

示例4: get_cat_articles

示例5: htmlspecialchars

示例6: get_article_count

示例7: get_articles_list

示例8: get_articleslist

示例9: get_cat_new_arts

请发表评论

全部评论

上一篇：

下一篇：

krishnaik06/Machine-Learning-in-90-days

armancodv/building-energy-model-matlab:

美元符号为什么是“$”

FGRibreau/import-tweets-to-mastodon: How

Delphi与DirectX之DelphiX(14):TPictureCol

CVE-2020-35163

bradtraversy/iweather: Ionic 3 mobile we

mysensors/MySensors: MySensors library a

joaomh/curso-de-matlab

断牙刷新位置时间（断牙属性及刷新位置介绍

rugk/mastodon-simplified-federation: Sim

关于我们

产品与服务

解决方案

139-2527-9053