原文地址：

http://www.thinkcmf.com/document/article/id/232.html

sp_sql_posts($tag,$where)

功能：

查询文章列表，不做分页

参数：

$tag:查询语句（见

$tag规则

）

$where:查询条件，（暂只支持数组），格式和thinkphp where方法一样；

返回信息如下：

[pcsh lang="php" tab_size="4" message="" hl_lines="" provider="manual"]

Array
(
    [tid]                   => 3
    [object_id]             => 3
    [term_id]               => 1
    [listorder]             => 0
    [status]                => 1
    [id]                    => 1
    [post_author]           => 1
    [post_keywords]         => 
    [post_source]           => 1300000000
    [post_date]             => 2016-04-05 18:52:08
    [post_content]          => ''
    [post_title]            => 哦哦哦
    [post_excerpt]          => 
    [post_status]           => 1
    [comment_status]        => 1
    [post_modified]         => 2016-04-05 18:51:36
    [post_content_filtered] => 
    [post_parent]           => 0
    [post_type]             => 
    [post_mime_type]        => 
    [comment_count]         => 0
    [smeta]                 => {"thumb":"20160407\/5705c94020795.jpg"}
    [post_hits]             => 60
    [post_like]             => 0
    [istop]                 => 0
    [recommended]           => 0
    [user_login]            => king
    [user_pass]             => ###dab65970ee54e3a9b768c2cb7c427514
    [user_nicename]         => admin
    [user_email]            => king@qq.com
    [user_url]              => 
    [avatar]                => 
    [sex]                   => 0
    [birthday]              => 
    [signature]             => 
    [last_login_ip]         => 0.0.0.0
    [last_login_time]       => 2016-04-07 10:28:29
    [create_time]           => 2016-04-05 05:06:45
    [user_activation_key]   => b662d1854de4a475e7be820bf0cec88f
    [user_status]           => 1
    [score]                 => 0
    [user_type]             => 1
    [coin]                  => 0
    [mobile]                => 
)

[/pcsh]

最后更新于 2017-03-17 15:58:08 并被添加「」标签，已有 665 位童鞋阅读过。