Home SIDU
  1. Read
  2. Vote
  3. Old
  4. New
  5. Hot
  6. Reply

Localhost SIDU ssh connect remote site localhost

The following line is a handy tip to allow SIDU from localhost to ssh connect remote site's localhost, when remote database is not allowed connection from a remote IP:

Open a terminal and input the following line:

# ssh -fCTMNS /tmp/sidu_tunnel -p 22 user@remote.ip -L 3307:localhost:3306

u
Cat: SIDU | Read: 57248 | 01/01/2019 | Like: 11

Wiki: Topnew DB helper

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
Cat: SIDU | Read: 183975 | 05/11/2018 | 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: 13732 | 02/11/2018

SIDU feature request and bug



This topic is a place to collect feedback for SIDU bugs and feature requests.
Cat: SIDU | Read: 18583 | 28/10/2018 | Like: 2

SIDU import/export data clean

Topnew note: content lost:due to so many spam, delete bulk lost.please check old blog arc, possible has a copy there
Cat: SIDU | Read: 62189 | 11/01/2013
  1. 1
  2. 2
  3. 3

Category