/blog

I realised pretty quickly that a straight LIKE query wasn't going to work for search as it caught things like parts of URLs where the search term wasn't in the actual text.

Switching to a REGEXP query has resolved this although it took me some time last night to work out the correct regex pattern to exclude what I need. Looking at this introduced me to regex character classes like [:punct:] which came in handy.

This morning I have added highlighting of the search term within results using a preg_replace to only include the correct parts (i.e. not breaking any HTML) in styled <span> tags. If no results are found there is a link to search the archive AKA the WordPress posts.

It's coming together nicely.

Pro tip: don't put your fingers in the boiling water when poaching eggs.

Liked: Really excited to have the first inst... – James Van Dyne...

Another #CustomCMS

After adding a number of pages (grandchildren) to the Garden recently performance has absolutely tanked. The nested queries are obviously struggling.

I'm looking at replacing the queries with wp_list_pages() but need to sort out a custom walker for changing the output to include the additional functionality I had built.

It feels a bit weird working on WordPress stuff again.

Jean Tubridy celebrated ten years of blogging yesterday by listing "10 things I would say to beginner blogger me."

Consider:

"You will meet many fascinating people through this and many who you will count as true friends."

and:

"Treasure those who take the time to engage with you. This is valuable time they could have been using some other way."

But don't forget:

"Don't try to be someone you aren't. It isn't sustainable long term in blogging."

Via David Kanigan.