Blog Home / SIDU

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:l
Dept: SIDU | Read: 12964 | 2019-01-01   7

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 | sq
Dept: SIDU | Read: 65571 | 2018-11-05   1
Tags: CMS, Wiki

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
F
Dept: SIDU | Read: 10070 | 2018-11-02
Tags: MySQL, Test

SIDU feature request and bug



This topic is a place to collect feedback for SIDU bugs and feature requests.
Dept: SIDU | Read: 11293 | Reply: 2 | 2018-10-28   1
Tags: SIDU, Bug, Feature

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
Dept: SIDU | Read: 56094 | Reply: 10 | 2013-01-11

  1. 1
  2. 2
  3. 3