Skip to content

Instantly share code, notes, and snippets.

@sabrina-zeidan
Created December 22, 2023 12:43
Show Gist options
  • Save sabrina-zeidan/b0641e0956eb72ef4d5eaeaa70089c10 to your computer and use it in GitHub Desktop.
Save sabrina-zeidan/b0641e0956eb72ef4d5eaeaa70089c10 to your computer and use it in GitHub Desktop.
List or delete all transients with a specific prefix WordPress
function delete_transients_with_prefix( $prefix ) {
foreach ( get_transient_keys_with_prefix( $prefix ) as $key ) {
// delete_transient( $key );
echo "<br>". $key." ".get_transient( $key );
}
}
/**
* Gets all transient keys in the database with a specific prefix.
*
* Note that this doesn't work for sites that use a persistent object
* cache, since in that case, transients are stored in memory.
*
* @param string $prefix Prefix to search for.
* @return array Transient keys with prefix, or empty array on error.
*/
function get_transient_keys_with_prefix( $prefix ) {
global $wpdb;
$prefix = $wpdb->esc_like( '_transient_' . $prefix );
$sql = "SELECT `option_name` FROM $wpdb->options WHERE `option_name` LIKE '%s'";
$keys = $wpdb->get_results( $wpdb->prepare( $sql, $prefix . '%' ), ARRAY_A );
if ( is_wp_error( $keys ) ) {
return [];
}
return array_map( function( $key ) {
// Remove '_transient_' from the option name.
return substr( $key['option_name'], strlen( '_transient_' ) );
}, $keys );
}
//To fire the function:
delete_transients_with_prefix( 'speedguard');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment