find and replace from a database

Hi,
I have the following problem that I actually don't know how to solve

I have a website in PHP of which I have all the pages (they are like 500 pages), and I would like to do some basic SEO on them, say optimizing the title and the meta tags.

Obviously I reckon the better solution is to find a script or software that can help me to find the existing tags and replace them with the ones I create from my preferred keywords.

For example, I can build a database on Excel with my keywords manually inserting them, then wanting the script to pick up the correct keywords for the specific pages, and put them in the right place.

How can I do that? Is there a specific script for this?

Thank you in advance

 

I don't quite understand. I assume you have a website made in php which fetches the html from an sql database, and you want to replace the meta tages in the html in this database?

I don't know if there is a specific script/tool to do this, but if you have full server access you might want to take a look at this. If you don't have full access to the server, don't you have something like phpMyAdmin?

You must have somehow gotten these pages in the DB at the first place, so you can change them as well I would say...

If I didn't understand what you tried to say please clarify

 

for meta tags, why all this hassle? insert them manually into your pages.

 

The problem is to manage 500 or more meta tags manually

 

When you call the data from the database (im assuming mysql?) to your page you can do a string replace and insert words that way...

$mydata = $row['mydata'];
$newdata = str_replace('text to replace', 'replace with this text', $mydata);
echo $newdata;

PHP:

 

Could that code be ammended to edit html pages on the server?