WordPress画像アップロード時に保存される画像情報をDBで確認する

//（例）
a:6:{
    s:5:"width";
    i:863;
    s:6:"height";
    i:410;s:4:"file";
    s:17:"2022-11-19-20.png";
    s:8:"filesize";
    i:25735;
    s:5:"sizes";
    a:5:{
      s:8:"thumb100";
      a:5:{
          s:4:"file";s:25:"2022-11-19-20-100x100.png";
          s:5:"width";i:100;
          s:6:"height";i:100;
          s:9:"mime-type";
          s:9:"image/png";
          s:8:"filesize";
          i:5316;
        }s:8:"thumb150";a:5:{
          s:4:"file";s:25:"2022-11-19-20-150x150.png";
          s:5:"width";i:150;s:6:"height";i:150;s:9:"mime-type";s:9:"image/png";s:8:"filesize";i:9674;
        }s:8:"thumb120";a:5:{
          s:4:"file";s:24:"2022-11-19-20-120x68.png";
          s:5:"width";i:120;s:6:"height";i:68;s:9:"mime-type";s:9:"image/png";s:8:"filesize";i:4815;
        }s:8:"thumb160";a:5:{
          s:4:"file";s:24:"2022-11-19-20-160x90.png";
          s:5:"width";i:160;s:6:"height";i:90;s:9:"mime-type";s:9:"image/png";s:8:"filesize";i:7242;
        }s:8:"thumb320";a:5:{
          s:4:"file";s:25:"2022-11-19-20-320x180.png";
          s:5:"width";i:320;s:6:"height";i:180;s:9:"mime-type";s:9:"image/png";s:8:"filesize";i:19426;
        }
    }s:10:"image_meta";
  a:12:{
    s:8:"aperture";
    s:1:"0";
    s:6:"credit";s:0:"";
    s:6:"camera";s:0:"";
    s:7:"caption";s:0:"";
    s:17:"created_timestamp";
    s:1:"0";
    s:9:"copyright";s:0:"";
    s:12:"focal_length";
    s:1:"0";
    s:3:"iso";
    s:1:"0";
    s:13:"shutter_speed";
    s:1:"0";
    s:5:"title";s:0:"";
    s:11:"orientation";
    s:1:"0";
    s:8:"keywords";
    a:0:{}
  }
}

//-------------------------------------------------------------
// 投稿画像のalt=""のときライブラリのaltを挿入する
//------------------------------------------------------------
function my_set_img_alt_title( $content ) {
	global $wpdb;
	if ( preg_match_all( '/<img [^>]+alt=""[^>]+>/i', $content, $images ) ) {
		foreach( $images[0] as $image ) {
			if ( preg_match( '/src=[\'"]([^\'"]+)[\'"]/i', $image, $src ) ) {
				if ( preg_match( '/([^\/]+?)(-e\d+)?(-\d+x\d+)?(\.\w+)?$/', $src[1], $file ) ) {
					$attachiment_id = (int)$wpdb->get_var( $wpdb->prepare( "SELECT ID FROM {$wpdb->posts} WHERE post_name=%s", $file[1] ) );
					if ( $attachiment_id ) {
						$alt = get_post_meta( $attachiment_id, '_wp_attachment_image_alt', true );
						$replace = str_replace( 'alt=""', 'alt="' . esc_attr( $alt ) . '" ',  $image );
						$content = str_replace( $image, $replace, $content );
					}
				}
			}
		}
	}
	return $content;
}
add_filter( 'the_content', 'my_set_img_alt_title' );
//----------------------------