# image-optimization/1.5.3/classes/image/image-db-update.php

Image Optimizer – Compress Images and Convert to WebP or AVIF, version 1.5.3. 34 lines.

- Page: https://pluginprobe.com/plugins/image-optimization/1.5.3/code/classes/image/image-db-update.php
- Raw: https://pluginprobe.com/plugins/image-optimization/1.5.3/raw/classes/image/image-db-update.php
- Modified: 2024-02-06T14:05:42+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/image-optimization/1.5.3/code/classes/image/image-db-update.php#L10-L20`.

```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,
			]);
		}
	}
}

```