Wiki: Topnew Form Helper

Wiki: CMS Form Helper v 2018.09.09

Topnew Form helper generates html form, with data validation. It also generates SQL based on input values. Let's start with an example:


Let's start with a quick Example:

/* Define all for
Dept: CMS | Read: 60182 | 2018-11-08
Tags: CMS, Wiki

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

Finding the Nth Fibonacci number via PHP

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 th
Dept: General | Read: 54409 | 2018-11-01
Tags: PHP, Test

Benson Bank Feature Request and Bug Report



This is a place to collect feature request and bug report for BensonBank CMS
Dept: BensonBank | Read: 242504 | Reply: 1 | 2018-10-29   1
Tags: Bank, Bug, Feature

  1. 1
  2. 2
  3. 3
  4. »

Category

New Replies

» Optional sidu_fk table
» SIDU SQL in charts: howto
» Godaddy Magic Quotes Problem
» SIDU import/export data clean
» How to install databases
» SIDU feature request and bug
» Benson Bank Feature Request and Bug Report