CREATE TABLE blog_cat (
cat int NOT NULL DEFAULT 0 PRIMARY KEY,
name varchar(99) NOT NULL DEFAULT '',
info varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE blog_file (
id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,

Filesystem: copy these 5 files anywhere on your web eg /blog/ :

/blog/.htaccess -- catch all url to index.php
/blog/index.php -- start of the blog
/blog/blog.css -- customer css if needed
/blog/blog.js -- customer js if needed
/blog/file/ -- folder for attachme

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

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

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