PHP WPOTools::getQueryArgs Examples

Example #1

File: wpomatic-class-copy-thing.php Project: elizabethcb/Daily-Globe

 /**
  * Retrieves feeds from database
  *         
  * @param   mixed   $args
  */
 function getFeeds($args = '')
 {
     global $wpdb;
     extract(WPOTools::getQueryArgs($args, array('fields' => '*', 'campid' => '', 'join' => false, 'orderby' => 'created_on', 'ordertype' => 'DESC', 'limit' => null)));
     $sql = "SELECT {$fields} FROM {$this->db['campaign_feed']} cf ";
     if (!empty($join)) {
         $sql .= "INNER JOIN {$this->db['campaign']} camp ON camp.id = cf.campaign_id ";
     }
     if (!empty($campid)) {
         $sql .= "WHERE cf.campaign_id = {$campid}";
     }
     return $wpdb->get_results($sql);
 }