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 = '' . 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!
';
}
?>