php - Retrieve alt text by referencing img src - Wordpress

I have a website with 400+ images. Using a spreadsheet plugin I've been through and manually addedalt text to each of the images.

The problem I have is that the pages are built with a page builder and a lot of the images where added in text blocks using<img src="https://example.com/image-folder/image-name.jpg"> and therefore haven't dynamically pulled in thealt text.

I'm trying to avoid having to go through all of the pages, find theimg code, work out which image it is, look up thealt text and manually type it, again!

I'm thinking there must be a way to reference the image in the database by theimgsrc, then get thealt text from the database that way.

I'd like to write a function that sits in the functions file and I can call from thealt text. Something like thisget_alt_text():

<img src="https://example.com/image-folder/image-name.jpg" alt="<?php echo( get_alt_text() ); ?>">

This way I can just paste in a single bit of text into each imagealt which would save a ton of time.

It seems there are functions that could help me, but it's a bit more than I fully understand right now and wondered if someone could at least say (with confidence) that it's possible or not.

For example this Wordpress "attachment_url_to_postid" function.

or this "wp_get_attachment_image_src" function

My thinking for the function is:

• Get theimgsrc
• match that to an image in the database
• get that image ID and meta data etc
• separate thealt text and pass that back

So, my question is:

• Can you tell me if this is possible?
• Even better, point me in the right direction.
• Even better yet! Show an example.

Thank you for your time.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.