Wordpress SEO Expert

Improve your Google ranking with Peter Mahoney, 20+ years SEO & Wordpress experience

  • SEO Overhaul
  • SEO Campaign
  • WP Support
  • Blog
    • SEO Emails
  • Praise

Easily search and replace throughout a (smallish) MySQL database

September 19, 2012 by Peter Wordpress SEO Expert

Every now and then I need to search through an entire MySQL database, to change a word, term, URL, or some other string.

Rather than searching through the entire database to make the change, I just use phpMyAdmin to export the whole thing as an .sql file, which is of course just plain text.

Open it in a text editor, find and replace in there, then re-upload to phpMyAdmin.

In short, I get it done easily in a bout 45 seconds without having to worry about a typo in an SQL query destroying my data.

Filed Under: Hints & Tips, Nerd-stream Tagged With: database, mysql, search, sql

Donate monthly via Paypal, and HTML

September 17, 2012 by Peter Wordpress SEO Expert

BINGO! This is just what I needed tonight. I was starting to create a PHP solution that would enable me to set up monthly donations (rather than a subscription) to Paypal.

But then I thought, “Paypal must have a more elegant solution for this, and if not more elegant, than certainly simpler”.

And while they didn’t, a quick Google search revealed someone else had. In HTML.

Monthly Donations Button | PayPal.

Filed Under: Code, Nerd-stream Tagged With: donate, html, paypal

Create custom RSS feeds in WordPress

August 31, 2012 by Peter Wordpress SEO Expert

I couldn’t quite work out how best to do create a custom RSS feed in WordPress.

My task seemed simple enough, to make an RSS feed of news articles from popular news sources…but the RSS feed needed to link back to the original source, NOT the article in WordPress.

Writing the PHP script to generate the RSS was simple, but the final step was getting WordPress to serve that feed.

Here’s the documentation I used, in addition to a custom field:

Create custom RSS feeds in WordPress | Tips4PHP.

Filed Under: Code, Nerd-stream, Wordpress Tagged With: documentation, feeds, PHP, rss, wordpress

New Twitter logo in pure CSS

June 11, 2012 by Peter Wordpress SEO Expert

This is why I love CSS. Now, it will only work in newer browsers, but does look awesome.

Roll over it and you’ll see how they made this, with a variety of CSS circles.

You can of course also view the code by right hand clicking and viewing source. This is what I love about the web, something that makes us really say WOW, in just a hundred odd lines of code.

Filed Under: Code, Nerd-stream Tagged With: CSS, Twitter

Double-tagging, or CSS vertical align

May 22, 2012 by Peter Wordpress SEO Expert

This is pretty geeky, but I’ve tried several ways of doing this, and wanted to post what I’ve found to be the best. And based on testing, it’s also the most cross-browser compliant solution.

The issue is (seemingly) simple. How do you use the equivalent of valign=”middle” in CSS? With tables this was pretty simple. But we’ve all moved on from tables for layout. I hope.

While CSS (including CSS3) does have a vertical-align, you can’t use it in the same way for you text-align for example. You can’t simply tell it that all text within a container should sit halfway down the div.

The way I’ve found most useful is to double-tag. That is, to use a parent div, and then a child within it.

Here’s the code to show what I mean:
#content1 {
display:table;
height:400px;
}

#content2 {
display:table-cell;
vertical-align:middle;
}

And then when writing the HTML:
<div id=”content1″>
<div id=”content2″>
This text will sit halfway down the div, regardless of whether I have one line of text, or three.
</div>
</div>

In essence the first div says “Go on, act like I’m a table”.  And then second continues, “And let’s just say I’m a table cell. Because cells *can* have vertical-align assigned to them!”

Double-tagging.

Filed Under: Code, Nerd-stream Tagged With: align, CSS, vertical

  • « Previous Page
  • 1
  • …
  • 24
  • 25
  • 26

Get FREE Wordpress SEO tips!

I send regular newsletters with WordPress SEO expert-level tips. Sign up to get them, along with my FREE e-book “Ongoing SEO Success”.

Did I mention they’re free!

Subscribe for free

Praise

I have over 2,500 5-star feedback reviews (and I’ve never received less than the full five.)

Here’s just one example, from Mike who runs Costello Entertainments:

Migration, Hosting, SEO and Speed Work on our new website all completed quickly and efficiently and Peter was most helpful in fixing an issue with a Popover on the site as well. If you’re thinking about asking Peter to do a job for you or hesitating, JUST DO IT! – He knows programming and the internet inside out, he’ll get the job done for you professionally, with a smile. I wish I could call a plumber or a tradesman to do the jobs I can’t do myself with the same level of confidence.
Read a lot more.

Recent Blogs

  • Outreach for backlinks – how to get quality links that Google will love
    I’m thinking of redirecting my Virtual Assistant work to other tasks as the generic LinkedIn work I ...
  • (Small) Pricing changes for 2025
    When COVID first hit, like a lot of people around the world I wanted to help my clients as much as possible ...
  • My site has errors – timeouts – and my host isn’t helping me
    Hi Peter, My site has been reporting errors (timeouts) which have become more regular the past week or so. I ...
  • How do we fix 404 errors after a site move or migration?
    Hi Peter, We migrated from Visualsoft to Woocommerce approx. 10 days ago and are experiencing 404 errors. ...

Legal

  • Terms and conditions
  • Privacy policy
  • Disclaimer

Prices are quoted exclusive of VAT unless expressly stated.

Also read

  • Payment information

RSS

Peter Mahoney, WordPress SEO expert blog

Recent Posts

  • Outreach for backlinks – how to get quality links that Google will love
  • (Small) Pricing changes for 2025
  • My site has errors – timeouts – and my host isn’t helping me
  • How do we fix 404 errors after a site move or migration?
  • Why does SEMRush show my ranking change so much?

© Copyright 2025 Wordpress SEO Expert · All Rights Reserved · Site by Peter Mahoney