S.Wojnowski - web development

Helping make the web work for everyone.

Welcome to my website. My name is Sylwester Wojnowski. I am a full stack web developer who started programming for the internet in 1998. As a web developer I plan, design and implement intereactive internet technologies and applications for individuals and organisations.

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

JSON object in asynchronous HTTP request

JSON object in asynchronous HTTP request

23 Feb 2020 16:24:10


A few words on how to transfer and receive JSON objects using JavaScript and PHP's standard input stream respectively.


Read full article »

Recent

Performing inner and outer SQL joins in CodeIgniter 4

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 ...

Read more »

Prepending an empty string key option to options array for form_dropdown function in CodeIgniter 4

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, ...

Read more »

Adding, listing and dropping foreign keys in MySQL

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. ...

Read more »

Finding previous and next database table item with Query Builder in CodeIgniter 4

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 ...

Read more »

SWWW

S.Wojnowski - web developer

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?

S.Wojnowski - Hire 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.

Contact Me