simpods_select()

Get entries from a table, taking Simpods Hierachy, Simpods Linked Areas, Pods into account.

Copy to Clipboard

Parameters

$fields

Fields to search. Prefix _exc_ to implement NOT LIKE, _find_ to search substring, _prev_ for the previous record of the search target and _next_ for the record after. _prev_ and _next_ only work with order ASC.

array{ 'id' => 1, // search id 1 '_exc_id' => 2, // exclude id 2 '_find_post_name' => 'test', '_prev_id' => 3, // find the record before id 3 '_next_id' => 4, // find the record after id 4 }

$attributes

SQL attributes array:

Copy to Clipboard

array(
    'target_tb'    => '',         // The target database table
    'limit'        => 0,          // Max number of results to return
    'order'        => 'ASC',      // Search order. _prev_ and _next_ only work with ASC
    'order_by'     => '',         // Field to order the results by. Can be string or an array: array( array( field_name, direction, escape field name or not ), ... ), e.g. array( array( 'main_tb.`name`', 'ASC', false ), array( 'pos_tb.`post_title`', 'DESC', false ) )
    'group_by'     => '',         // Group your search results
    'having'	   => '',		  // Restrict the results returned by the GROUP BY	
    'start'        => 0,          // Which row to start the search
    'cat_areas'    => array(),    // For Simpods Hierarchy: array( array( 'join' => AND|OR, 'cattb' => number, 'catid' => number ) )
    'inc_cats'     => false,      // If true, all Simpods Hierarchy categories will be unserialized and included
    'linked_areas' => array(),    // For Simpods Linked Area: array( array( 'join' => AND|OR, 'cattb' => number, 'catid' => number ) )
    'inc_areas'    => false,      // If true, all Simpods Linked Areas will be unserialized and included
    'scheduled'    => false,      // If scheduled, outdated posts won't be included. Only work if the Simpods Schedule Component is available.
    'post_status'  => array(),    // Post status, e.g. 'publish', 'pending' etc.
    'count_only'   => false,      // If true, the search will return the number of how many rows found
    'term_id'      => 0,          // The term id, like the post category id or custom taxonomy id.
    'search'       => '',         // Extra bits that are not included in the function, expect escaped. e.g. AND main_tb.field = "something" AND post_tb.post_name LIKE "%%something%%"
    'join'         => '',         // Extra join queries, expect escaped
    'fields'       => '',         // Extra fields to return, usually needed when you use 'search' and 'join' above string or array e.g.
    'fields_only'  => false,	  // If true, only the fields in the fields option will be returned.
    'results_type' => ARRAY_A,    // ARRAY_A | ARRAY_N | OBJECT | OBJECT_K
    'return_query' => false,	  // Return query for debugging	
);

$can_echo_query

If true the query will be echoed out (default false)

$can_prefix

If true, prefixes table names with the WordPress table prefix (default true)

Return

array

Array of found rows. If there are none, the array will be empty.

Example

Basic use:

Copy to Clipboard

Advanced use – getting children from a parent post organised by Simpods Hierachy:

Copy to Clipboard

simpods-functions.class.php

Function Reference

Parameters

Return

Example