prefix . 'wpbot_subscription'; if ( isset( $_POST['wpbot_email_subscription_remove'] ) && $_POST['wpbot_email_subscription_remove'] == '1' ) { if ( current_user_can( 'manage_options' ) && isset( $_POST['emails'] ) && is_array( $_POST['emails'] ) ) { foreach ( $_POST['emails'] as $email_id ) { $wpdb->delete( $table, array( 'id' => intval( $email_id ) ), array( '%d' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching } echo ''; exit; } } $current_user = wp_get_current_user(); $url = admin_url( 'edit.php?post_type=sld&page=qcsld_click_list' ); $customPagHTML = ''; // Main Report Area $sql1 = $wpdb->prepare( 'SELECT count(*) FROM %i where 1', $table ); $total = $wpdb->get_var( $sql1 ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching $items_per_page = 50; $page = isset( $_GET['cpage'] ) ? abs( (int) $_GET['cpage'] ) : 1;// phpcs:ignore WordPress.Security.NonceVerification.Missing $offset = ( $page * $items_per_page ) - $items_per_page; $sql = $wpdb->prepare( 'SELECT * FROM %i where 1 order by id desc LIMIT %d, %d', $table, $offset, $items_per_page ); $rows = $wpdb->get_results( $sql ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter $totalPage = ceil( $total / $items_per_page ); if ( $totalPage > 1 ) { $customPagHTML = '

Page ' . esc_html( $page ) . ' of ' . esc_html( $totalPage ) . '' . paginate_links( array( 'base' => add_query_arg( 'cpage', '%#%' ), 'format' => '', 'prev_text' => esc_html__( '«' ), 'next_text' => esc_html__( '»' ), 'total' => esc_html( $totalPage ), 'current' => esc_html( $page ), ) ) . '

'; } $mainurl = admin_url( 'admin.php?page=email-subscription' ); ?>

Record has beed Deleted Successfully!

'; } ?>