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
Database queries with bindings and Query Builder essentials in CodeIgniter 4
23 Jan 2022 01:25:58
Basics of fetching data from database using queries with bindings and Query Builder class in CodeIgniter 4
Popular
27 Jan 2022 12:25:32
Creating URL-safe slugs in CodeIgniter 4
Build URL-secure slugs using URL and Text helper functions in CodeIgniter4
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.
07 Apr 2022 00:55:48
MongoDB mongod server fails to start after installation and solution
MongoDB server not starting after installation due to missing dependencies and how to solve this problem.
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.
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.
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.