README

Generate web app to view, add and edit data in any MySQL table or Query in just 4 lines of code, with pagination auto generated as well, as are the media queries, to build a truly responsive app that is mobile friendly and works accross all platforms and screen sizes.

There are in fact 2 main functions, sqlEdit and sqlBrowse. As explained. sqlEdit has the ability ot add.modify data, however sqlBrowse can only generate view only apps.

Requirements and Dependencies

PHP Classes

sql.class.phpMySQLi Database abstraction and helper class, required in order for forms.class.php to work
forms.class.phpMain class that implements all the functionality. Dependent on sql.class.php

Server Operating Systen

CentOS 7 64 Bit Server OS
Windows Server, Windows XP, Windows 7, Windows 8, Windows 10 OS
MacOS
MySQL sercer, MariaDB

Server Operating Environment

PHP > Ver 7.0
MySQL
GD

Development Languages

PHP, MySQL

Features

Pagination

The automatic pagination uses a truly unique approach to seemless handle datasets ranging from 10 rows to 2 million rows, all without any complicated juggling of page numbers or special case handling code - and what resulys is one of the cleanest pagination implementations that you will see, that handles 10 pages the same way it handles 2,000,000. See examples or screenshots for examples.

Pagination may be turned off or on at any time by seeting the config values in the settings.ini file.

Styling

User has full athority of look and feel etc and may set their own styles and class at the desgnated sections that handless css rules.

Flexibility and ease of Configuration

Even though it is ridiculously simple to use, we still need to tell it where to find your databse/tables etc. This is done through the configuration file ('settings.ini'). It also has a bunch of other optional parameters, which if not set by you, have little impact on the proper functioning of the object.

Data View Management

Easily switch back and forth between the 2 available views - Boxed layout or full width layout, used in order to ease cluttering and conjestion when working on tables with a large nuber of colums or fieldsets.

There exists a trigger point, beyond which, if exceeded, the number of colums is exceeded, the display format switches automatically from the default 'grid view' to the row based 'fieldlist' mode, and each field is displayed on a new page row, and showing only one table record at a time. Subsequent rows are fetched upon the user requesting pages higher in number, using generated page links in the pagination area or by manipulating the page selctoe widget at the bottom of the screen.

User Experience.

Data is, without exception, loaded using the jquery ajax library, and as a rtesult, the user is never put through the experience of being constantly interrupted, while waiting for pages reloading over and over, and circumventing the creation of unnecessay high amount of stress externally in the network, and internally on the webserver filesystem i/o operations.

Global Properties Set via INI File

Here is a full last of parameters that you can set in the settings.ini file.


#Database user name
db_user=

#Database password
db_pass=

#Name of the database trying to connect to
db_name=

#Database Server IP Address without any quotes
db_server=

#Represents the root folder where this application wa installed, in absolute form.
host=sugardaddyscam.com/form

#Represents the webroot folder, as in the external public web URL in absolute form.
app=/form

#Represents the publically accesible web url that holds the generated PHP files
out_full=/sites/home/scam/public_html/form/output

#Represents the internal folder locatiion generated PHP files
out=/form/output

#Max number of items to be displayed per page
items_per_page=5

#Max number of items to be displayed per page
pagination=on

#Max number of items to be displayed per page
image_upload_folder=5

#Autocomplete catalog table
    catalog_db_name=terra
    catalog_tb_name=autocomplete

Installation

OPTION 1: COMPOSER

This the easiest way; Run the following code in shell


composer require gangsterforms/sqledit

`OPTION 2: GIT`

`Step by Step Insructions for Usage`

`Real World Code Samples`


	$db_name="Enter database name";
	$table="Enter name of table you want to edit";
	parse_str(http_build_query($_GET));
	include "class/utils.class.php";
	$c=new utils;
	$c->connect(DB_SERVER,DB_USER,DB_PASS,$db_name);
	echo $c->SQLEdit($db_name,$table);
	include "paginate.php";

gangsterforms / sqledit

Maintainers

Details