Article of the week

Updating WordPress database URLs - part 2

Updating WordPress database URLs - part 2

03 Jan 2017 13:03:49


Second part of the series on the subject of replacing URLs in WordPress database.


In this second part on the updating WordPress database URLs I'll concentrate on a database-wide approach. All tables will be scanned and old URLs updated to new ones. Also serialized data will be properly dealt with. In this part, mysql utility will not be involved ( but ...

Read full article »

Recent articles

Sorting UTF-8 strings in PHP

29 Apr 2017 16:41:28

Web development

Sorting UTF-8 strings in PHP

When trying to sort a list of strings in PHP, one needs a reliable way of comparing the strings first. PHP has some nice comparison functions, notably strcmp. Strcmp function works fine for ASCII character set, in which the same number of bits ( 7 ) is used to encode a ...

Read more »

Secondary database query and shortcodes in Wordpress

20 Apr 2017 11:14:15

Web development

Secondary database query and shortcodes in Wordpress

Secondary database queries are queries that you do in Wordpress once the main, URL-based query has been performed. Typically, these extra queries are used to fetch data like featured or category post and embed it on in a section of a template file. Alternatively, the data goes ...

Read more »

Quicksort algorithm implementation in PHP

13 Apr 2017 09:56:52

Maths

Quicksort algorithm implementation in PHP

Quicksort algorithm, as the name of it suggests, is yet another piece of code for sorting ( lists of ) items. The algorithm has been in use for nearly 60 years ( Anthony Hoare - its inventor - published it in 1961 ), and is still one of the fastest ways of sorting large lists ...

Read more »

Recursive bubble sort algorithm in PHP

06 Apr 2017 17:48:19

Maths

Recursive bubble sort algorithm in PHP

In this article I'm going to take a quick look at arranging elements of a list in a chosen order, or simply speaking - sorting, with a twist, though. Many algorithms have been devised for the purpose of sorting over the last sixty or so years. Arguably, one of the oldest ...

Read more »