Topnew Blog

Secure PHP login with database js for http sites

Topnew CMS uses secure PHP login with database, such as MySQL, PostgreSQL, SQLite or CUBRID.

Topnew CMS 3.0 uses almost perfect secure PHP login algorithm with https site, which is unhackable, well at least the algorithm. However we need to take care of those http sites. The following

Cat: CMS | Read: 31254 | 29/12/2012

Wiki: Topnew Data Docs

TODO

Cat: CMS | Read: 6325 | 11/11/2018

SIDU hotkey list

SIDU provides a full list of hotkeys to work without a mouse

When you mouse over a button in SIDU and shows something like "Fn+R", it is a SIDU hotkey.

It has nothing to do with the key "fn" in recently-manufactured laptop keyboard.

Fn in SIDU means browser hotkey shortcut

Hotkey shortcut

Cat: SIDU | Read: 25858 | 03/01/2013 | Like: 1

SQL row sum

Given an SQL table

ID Amt
-- ---
1 100
2 200
3 300

Please write a MySQL statement to produce the following result:

ID Amt Total
-- --- -----
1  100 100
2  200 300
3  300 600

And here is an example SQL:

SELECT a.ID, a.Amt, sum(b.Amt) AS Total
FROM tab AS a
JOIN tab AS b ON a.ID >= b.ID
GROUP BY 1,2

Cat: SIDU | Read: 13721 | 02/11/2018

BensonBank Tutorial 1 - Get started

Assume you have installed Benson Bank correctly. If not, here is howto:

1 - goto Benson Bank website and download the zip
2 - unzip and upload to your site, eg localhost/bank

By default there are 2 example accounts installed: user/password=100/pass and 101/pass

Just login Bens

Cat: BensonBank | Read: 15628 | 28/10/2013

Secure PHP login with database js for http sites

Wiki: Topnew Data Docs

SIDU hotkey list

SQL row sum

BensonBank Tutorial 1 - Get started

Category