WEB DEVELOPMENT / WEB DESIGN
LINUX, PHP, HTML5, CSS (SASS), JS, (SYMFONY), JAVASCRIPT, WP, PRESTASHOP …

DevWL – Blog

Wiktor Liszkiewicz

Hire Me

Blog

Tip 1 – Looking for code examples?
Check https://hotexamples.com and search whatever you’re looking for!

Tip 2 – Join Grepper to quickly find and resolve programming issues.
Join community now at codegrepper.com

Tip 3 – Learn Docker by examples
See GitHub repo. Also read our docker blog

Online PHP sandbox
onlinephp.io

Blog Posts:

Openssl – Generate private and public keys using PHP in Windows 10/11

IT, PHP

In Windows 10/11, you will need to set config path to openssl (openssl.cnf file). You can find this file in PHP directory. If you have installed gash shell you can run: php.exe -i | grep 'Configuration File' In my case, I have installed PHP under C:/php/php. Your path...

How to securely store passwords in a database.

IT, mysql, PHP

Keeping your passwords in a database in a plane format is a very bad idea. So why not to use hashing? Sure you can use hash, end it is totally OK to compare hash against hash. Especially if the password you want to store are not yours. Then this is the way to do it...

Install Mysql Or MariaDB on WSL ubuntu

IT

sudo apt update && sudo apt upgrade Install MySQL sudo apt install mysql-server mysql --version sudo /etc/init.d/mysql start If you want to secure MySQL by setting up the user pass, you can also run sudo mysql_secure_installation Allow remote access Allow...

SQL (MariaDB) add numbering column to a results of sorted and unsorted query

IT, MariaDB, MSQL, SQL

Adding numbering to not sorted query. If your query is not sorted, adding a number to a query can be as easy as: SELECT ROW_NUMBER() OVER() AS num, This will work if you will not use ORDER BY clause in your query: If you add ORDER BY clause, things work differently....

Connecting PHP with MariaBD on Windows

IT

Install NgineX start nginx Configure NgineX PHP CGI section like here: https://devwl.pl/nginx-php-on-windows-10/ Install PHP-CGI Navigate to PHP directory and run: php-cgi.exe -b 127.0.0.1:9999 Install MariaDB Run MariaDB Change default port number 3036 to 3333 at...

How to retrieve forgotten WP custom login url/ login path from database, set in All-In-One Security (AIOS) – Security and Firewall plugin.

IT, IT Help Desk, WordPress

Login to your database and run query: SELECT * FROM wp_mds_options WHERE option_name = 'active_plugins'; The result would look like:...

NginX + PHP on Windows 10

DevOps, IT, NginX, PHP, PHP tools, WebDevelopment

Installing Nginx on Windows Download NginX files from: https://nginx.org/en/docs/windows.html. Unzip to C\{name-version} (in my case it would be C:\nginx-1.25.4 directory). Open PowerShell as an Administrator and lunch server by typing cmd: start nginx Every time you...

MariaDB SQL Recursive call to self (single table)

IT, MariaDB, mysql, SQL

If you need to recursively query data based on child / parent relation between rows, you can achieve that using WITH RECURSIVE & UNITE ALL query instructions. Let's have a look at example “software table”. Software can be declared as virtual machine, virtualizer,...

How to find large file/directory in a Linux system?

Admin, Bash, Direct Admin, IT Help Desk, Linux, Linux CLI

There easy way to find large folders on Linux is to use du command. See the example commands: sudo find / -xdev -type f -size +1000M -exec du -sh {} \; The above command list all files larger than 1000M with it size. du -h -x / | sort -h -r | head -10 This command...

Backup Linux server to local machine with rsync

Admin, Backup, DevOps, Linux, Unix

The most popular way of backing up your Linux system are rsync and dump. The difference is that when using dump you need to work on a full image, where the rsync allows you to access individual files. Backup using RSYNC command From your local machine: rsync -chavzP...

Bubble sort Explained

IT

Bubble sort complexity: O(n^2) Pseudocode: src: https://www.youtube.com/watch?v=xli_FI7CuzA Bubble sort PHP code example: function bubble_sort($arr) { $size = count($arr)-1; for ($i=0; $i<$size; $i++) { for ($j=0; $j<$size-$i; $j++) { $k = $j+1; if ($arr[$k]...

Different free and paid software solutions for managing web hosting

IT

Control Panel Basic Features Comparison Are you searching for an alternative to cPanel, or perhaps you're looking to switch from DirectAdmin? Are there any other alternatives then Pleks? Let's find out. The table below represents a basic overview of commonly known web...

« Older Entries

CodePen – JS Mini Projects

Scroll up button

JavaScript ES5 mini project

Slide in nav menu

logo swap on section scroll. JavaScript ES6 mini project.

Reveal Phone Number

Run callback on phone display

Tabster jQuery Plugin Project

Display content when click and auto rotate content

Animated text box grid

JavaScript trigered text grid animation

SVG chart content box on click

CodePen – CSS components

Hamburger animation

CSS & jQuery

PHP Design Patterns book recommendations

Favourite Books

If you thinking about good lecture, you might consider one of those books.

Love to code

We Are

Passion for coding and learning new things.

PHP

HTML5

Java Script

Work Tools

PHP OOP Symfony
JS ES6 React
MySQL / MariaDB / PostgresSQL

We Do

More

Other technologies