Connecting PHP with MariaBD on Windows

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

NginX + PHP on Windows 10

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)

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

Bubble sort Explained

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

Open PowerShell terminal as Administrator from CLI

Type PowerShell and select run as Administrator from windows context menu. Open PowerShell terminal as Administrator (GUI) On keyboard, press Windows button ([win]) and [x]. The windows tool menu will pop up. [win] + x Open PowerShell terminal as admin from CMD (CLI)...

How to get Windows 10 activation KEY for my PC?

Perhaps you already tried to obtain Windows 10 key from CMD with a command you found on the Internet, but it did not work. I had the same problem. CMD simple did not work. I got blank output. So I tried to look for different solution. Below, I present a solution that...