Blog Home / SIDU

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: 65223 | 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: 9732 | 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: 10766 | 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: 55620 | Reply: 10 | 2013-01-11

SIDU SQL in charts: howto

There are 3 types of bar-charts to show according to the structure SQL result:

1. show chart - data horizontal: columns are x-axis
data horizontal
Dept: SIDU | Read: 12635 | Reply: 2334 | 2013-01-05   1

  1. 1
  2. 2

Category

Top Tags

wiki, test, CMS, feature, bug, bank, ticket, news, PHP, MySQL, blog, SIDU, forum