Page 51 of 427

Using Direct Database Queries to Quickly Update Data, Part 1

May 7, 2019 / Tom

This is not the first time I’ve mentioned this, but one of the challenges that come with talking about writing direct database queries to update information in the WordPress database is that you leave yourself open to something like:

Yeah, but there’s an API to do something just like that.

And, in many cases, that’s right. I’m a big fan of using ’em, too. But there are times where direct, parameterized database queries can be a more optimal choice.

No, it’s not a database but wouldn’t it be awesome if they looked like this? Photo by Tobias Fischer on Unsplash

This is, of course, contingent on the environment in which you’re working the requirements of your project.

So this is yet another post that’s going to be an illustration of how to use $wpdb to quickly update information based on metadata (without using something like WP_Query or WP_Meta_Query to handle it).

WordCamp Atlanta 2019: Web Apps with WordPress

May 2, 2019 / Tom

I’ve enjoyed speaking at WordCamps since my first back in 2013. You can see a short list of the ones at which I’ve spoken here:

And this weekend is officially WordCamp Atlanta 2019.

WordCamp Atlanta 2019: Web Apps with WordPress

I took 2018 off of speaking for several different reasons, and I’m not planning to do much in 2019 (especially with another kid making her debut later this year ❤️).

But given the work I’ve been doing with WordPress over the past few years, it seemed fitting to apply to at least speak at my local WordCamp.

Using cURL to Determine If the Specified URL Is a Valid Page

April 30, 2019 / Tom

Earlier this month, I wrote about finding the destination of a redirect using cURL in PHP. This can be a useful function to use whenever:

you know the URLs with which you’re dealing are going to redirect,
you know that the number of redirects will be limited to one.

Granted, in the latter case, it’s becoming more difficult because sites like, say, Twitter, have multiple redirects before you get to the destination.

But that’s a topic for another post (unless you just want to implement a recursive or iterative way of working through requests until you find the final destination).

Anyway, there’s another thing that can also be useful whenever you’re working with redirects and with cURL, and that’s determining if the specified URL takes you to a valid page.

I’m Reducing Blog Content: The Newsletter

April 29, 2019 / Tom

Over the next few months, I’m planning to make a few changes to this blog and the tertiary content around it. This includes the newsletter, the podcast, membership content, and more.

And by changes, I don’t mean getting rid of everything. Somethings, maybe, but certainly not all.

Between life and work, I’m busier than I’ve ever been – a good thing, to be clear – but I’m looking to simplify things where I can. And the newsletter seemed like one of the clearest places to start.

The blog, as it stands, will continue to be about WordPress development and I’ll continue to share content regularly; however, this month’s newsletter will be the last one that I’ll be sending on the regular.

Using Functions in Place of Globals: get_post_field

April 24, 2019 / Tom

As PHP has continued to move forward and WordPress (and its developer-economy) works to begin using more of the more modern features, one of the things we still see happening is the use of globals within WordPress.

To some degree, it’s inevitable: Significant parts of the application were built using globals when that was the facility that was a primary feature; other parts, though, have moved forward by providing classes or functions that prevent us from needing to do that.

Case in point: get_post_field is a solid alternative to using the $post global that provides much of the same information in a slightly more modern (and arguably safer) way of reading the data.

Tom McFarlin

Using Direct Database Queries to Quickly Update Data, Part 1

WordCamp Atlanta 2019: Web Apps with WordPress

Using cURL to Determine If the Specified URL Is a Valid Page

I’m Reducing Blog Content: The Newsletter

Using Functions in Place of Globals: get_post_field