' . esc_html__( 'Enter the suffix to search for below and press the \'Search\' button to view the results. Further help can be found by clicking on the Help tab at the top right-hand of the screen.', 'simple-embed-code' ) . '

'; ?>

get_results( $wpdb->prepare( "SELECT meta_value, post_title, ID FROM $wpdb->postmeta, $wpdb->posts WHERE meta_key = %s AND post_id = ID AND post_status NOT IN ('trash', 'auto-draft', 'inherit') AND post_type IN ('post', 'page') ORDER BY meta_value", $options['keyword_ident'] . $suffix ) ); // @codingStandardsIgnoreLine -- being used for a simple, ad-hoc search feature in admin. Unlikely to be used much and caching on this is overkill $records = $wpdb->num_rows; if ( 0 < $records ) { echo ''; $prev_html = ''; foreach ( $meta as $meta_data ) { $html = $meta_data->meta_value; $post_title = $meta_data->post_title; $post_ident = $meta_data->ID; echo '' . "\n"; echo '\n"; echo '\n"; echo "\n"; $prev_html = $html; } echo "

' . esc_html( $post_title ) . "

' . esc_html( $html ) . "

\n"; } else { ce_report_error( esc_html__( 'No posts were found containing that embed code.', 'simple-embed-code' ), 'Code Embed', true ); } } ?>