Web Developer Zone
Web Developer Zone is a code first section devoted to tools and techniques used in web development. Thematically, the main focus here is on PHP, Linux, BASH, JavaScript and a little bit of MySQL and Python.
Pick of the week
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.
Popular
03 Aug 2020 00:39:31
Piping JSON object to PHP script
Article about how to pass data from a shell to a PHP script with a pipe on the command line or directly using PHP system function.
21 Dec 2016 11:07:56
Genericons unicode values
List of Unicode code points for Genericons vector icon set and a BASH script that finds the codes.
14 Jul 2020 11:08:06
Recursively updating deeply nested arrays in PHP
An article on recursively updating deeply nested arrays using array_walk_recursive and custom nested array traversal function in PHP.
28 Jan 2022 12:34:11
06 Sep 2017 23:04:22
Mapping numeric score to feedback message in PHP
Article on mapping a numeric or percent score to a feedback message with code examples in PHP programming language.
18 Jul 2020 00:39:07
Transforming range of variable to 0 to 1 and custom ranges
Learn how to transform variable's range to [0,1] or a custom range.
Recent
04 Feb 2022 22:19:19
Performing inner and outer SQL joins in CodeIgniter 4
In this post I look at how to perform inner and outer SQL joins using CodeIgniter 4 prepared queries and Query Builder class. I assume you know what SQL joins are and when to use them in MySQL. This article describes a specific situation. There are three tables, posts, galleries ...
04 Feb 2022 00:47:56
Prepending an empty string key option to options array for form_dropdown function in CodeIgniter 4
A couple of sentences on how to prepend an options array, which contains numerical keys with a non-numerical key option for form_dropdown function in CodeIgniter 4. The option could be something like, '' => 'Choose ...' . One very good, probably the best, ...
02 Feb 2022 00:17:15
Adding, listing and dropping foreign keys in MySQL
This time a couple of words on how to add, list and drop foreign keys with ON CASCADE DELETE clause. What are foreign keys for? You define your foreign keys on tables to ensure integrity of your data. One particular case of this is a foreign key with ON CASCADE DELETE clause. ...
28 Jan 2022 21:39:38
Finding previous and next database table item with Query Builder in CodeIgniter 4
Imagine you have a database table Posts with items like blog posts, news and pages. Each of those items has its unique id and type like "page" or "news". Given an id of a database item, your goal is to find the previous and the next item of the same type ...
SWWW
SWWW is my place on the web where I write on stuff related to web development. Main focus here is on my own programs and scripts, but also websites I have developed over years or helped develop, improve or maintain. In the Web Developer Zone I take a closer look at various solutions related to web development and computer programming.
If you find any of my projects interesting, useful or would like to know more on it, do let me know. This website has a contact form. Altenatively, you can leave a comment under an article on the blog.
Need a web developer?
If you need a web developer for web development work drop me a line!
I am based in Wakefield, UK, but always happy to consider remote work opportunities.