Function Reference: geodir_imex_get_filter_where
Summary
Get the SQL where clause part to filter posts in import/export.
Global Values
- $wpdb
- (object) (required) WordPress Database object.
- Default: None
Package
GeoDirectory
Parameters
- $where
- (string) (required) The SQL where clause part.
- Default: empty
- $post_type
- (string) (required) The post type.
- Default: None
Return Values
- (string)
- SQL where clause part.
Change Log
Since: 1.6.4
Source File
geodir_imex_get_filter_where() is located in geodirectory-admin/admin_functions.php [Line: 6327]
Source Code
function geodir_imex_get_filter_where($where = '', $post_type = '') { global $wpdb; $filters = !empty( $_REQUEST['gd_imex'] ) && is_array( $_REQUEST['gd_imex'] ) ? $_REQUEST['gd_imex'] : NULL; if ( !empty( $filters ) ) { foreach ( $filters as $field => $value ) { switch ($field) { case 'start_date': $where .= " AND `" . $wpdb->posts . "`.`post_date` >= '" . sanitize_text_field( $value ) . " 00:00:00'"; break; case 'end_date': $where .= " AND `" . $wpdb->posts . "`.`post_date` <= '" . sanitize_text_field( $value ) . " 23:59:59'"; break; } } } return $where; }