The frontend - Topnew CSS v 2023

1. Grid system
2. Box
3. Colors
4. Shapes
5. Text
6. JS related

Install ubuntu 24.04 LAMP via wsl, PHP 8 MySQL 8 PostgreSQL 13 etc

A - Install Git Bash for windows

If you are already on Linux or Mac, this is optional.

Tool "Git Bash", on "gitforwindows.org", it says "Git for windows", when installed, it is called "MINGW64".

This tool for window

Wiki: Topnew DB Helper v 2018.08.08
Topnew DB provides a full list of database functions for PHP PDO only. Generally there are 5 groups of functions:

A - General duties:

1. Database connection

$conn = [
'eng' => 'mysql', // pgsql | sqlite | m

Here is an example of Fibonacci numbers:

0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, ...

Write a function f(x) so that return the following eg:

f(2) = 1 f(4) = 2 f(6) = 5 f(8) = 13 etc

And here is the code: function f($x = 0) { if ($x < 2) { return $x; } else { return f($x - 2) + f($x - 1); } }

Use your existing user table, and only import user_id in to blog_cat.cat = 1001 eg

REPLACE INTO blog_cat(cat,name,info) VALUES
(1001,'blog_staff','{"1":[1,2],"181130":[102,108]}');

staff user id is a json of: catetory and user ids, above means:

cat = 1 (all categories i.e. Admin staff)
user_id = 1, 2

cat = 181130 (i.e. staff or moderators for cat = 181130)
user_id = 102, 108 etc