34 lines
655 B
PHP
34 lines
655 B
PHP
<?php
|
|
|
|
namespace ImageOptimization\Classes\Image;
|
|
|
|
use WP_Query;
|
|
|
|
if ( ! defined( 'ABSPATH' ) ) {
|
|
exit; // Exit if accessed directly.
|
|
}
|
|
|
|
class Image_DB_Update {
|
|
public static function update_posts_table_urls( string $old_url, string $new_url ) {
|
|
$query = new WP_Query( [
|
|
'post_type' => 'any',
|
|
'post_status' => 'any',
|
|
's' => $old_url,
|
|
'search_columns' => [ 'post_content' ],
|
|
] );
|
|
|
|
if ( ! $query->post_count ) {
|
|
return;
|
|
}
|
|
|
|
foreach ( $query->posts as $post ) {
|
|
$new_content = str_replace( $old_url, $new_url, $post->post_content );
|
|
|
|
wp_update_post([
|
|
'ID' => $post->ID,
|
|
'post_content' => $new_content,
|
|
]);
|
|
}
|
|
}
|
|
}
|