PHP Database Tables Class: Store and retrieve class objects in database table

# PHP-Database-Tables-Class
---------------------
OOP Database class for PHP MySQL connection and insert, update, delete and select query for easier manipulating with tables

### CONFIG File

All database configurations are stored in seperate config.php file, which can be kept off document root.

### TABLE CLASSES

Whole idea is to create separate class for each table in the database and to manipulate data with ease.
e.g.

**class Article extends MySqlHelper {**

**public $id = 0;**

**public $title = "";**

**public function __construct(int $id = 0) {**

**$this->table = "articles";**

**$this->primaryKeyColumn = "id";**

**$this->columns = ["id" => MySqlHelper::type_int,"title" => MySqlHelper::type_str];**

**$this->loadRegular($id);**

**}**

**}**

### LOADING SINGLE ROW FROM A TABLE AND ASSIGN VALUES

e.g:

**$article = new Article(3);**

this will load row with id 3 in article class and convert all values appropriately. $article->id and $article->title in this case will be set

**$article->title = "New title";** //changing class value

**$article->update();** //updating article class values to table or

**$article->update(["title"]);** //updating just title value


### CUSTOM DATABASE CONNECTION AND QUERIES, IF NEEDED

Database class loads configuration file and establishes a MySQLi connect in constructor so just creating an instance of class connects you with database.


e.g:

**$db = new MySql();** // would connect to database

There are plenty of query types, reading whole tables, single rows, array of single column values, 
updating and deleting rows with or without where clause, counting row numbers, etc.

e.g:

**$db->insert("tablename",["column1","column2","column3"],[$value1,$value2,$value3]);** //inserting values in table

**$db->update("tablename",["column1","column2"],[$newvalue1,$newvalue2],$id);** // updating two columns to row with primar key value $id

**$db->updateWhere("tablename",["column1"],[$newvalue1],"id>?",[3]);** // updating column `column1` with value $newvalue1 to rows with `id` greater than 3

**$db->deleteWhere("tablename","id>?",[3]);** // deleting all rows with `id` greater than 3

Examples of Use:
---------------
index.php has a sample loading & editing values from tables, as well as reading POST and GET variables and assigning values to database.