Blog Docs 2 - Database Setup

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,
Dept: Blog | Read: 8691 | 2019-01-20   2

Blog Docs 1 - Basic and quick setup

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
Dept: Blog | Read: 58407 | 2019-01-10   2

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: 12781 | 2019-01-01   7

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: 60402 | 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: 65413 | 2018-11-05   1
Tags: CMS, Wiki

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

Category

Top Tags

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