PHP Classes
elePHPant
Icontem

Trigves Arm: Create database tables from array

Recommend this page to a friend!
  Info   View files Documentation   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2017-03-14 (2 months ago) RSS 2.0 feedNot enough user ratingsTotal: 119 All time: 8,560 This week: 675Up
Version License PHP version Categories
trigves-arm 1.0The PHP License5PHP 5, Databases
Description Author

This class can create database tables from array.

It takes an array with the definition of database tables and executes SQL statements to install the defined tables in MySQL database using MySQLi.

The class checks for existing tables to determine if the listed tables already exist and may need to be altered, or just creates the tables.

Name: Trigve Hagen <contact>
Classes: 2 packages by
Country: United States United States
Age: ???
All time rank: 3990458 in United States United States
Week rank: 991 Up96 in United States United States Up

Details

trigves-arm

This is a Rapid Application Development tool designed to speed up the work flow by taking out the need to run back and forth from the database. It works on database tables and rows by mapping a multidementional array to the relational database the same way an Orm maps an object. Once installed place the $this_>ArmCheckTables(); function somewhere where it will be ran everytime your page refreshes. If updates are needed it does them automatically. This branch is for custom php projects that run on your home made architectures. I will be updating it with new features and creating other branchs for symfony, laravel and code-igniter.

YOU REALLY HAVE TO WATCH WHEN YOU ARE CREATING YOUR TABLES AND FIELDS * NAMING TWO ROWS THE SAME WILL HALT EXECUTION AND CREATE AN ERROR * NO TWO FIELDS IN A TABLE CAN HAVE THE SAME NAME * NAMING TWO TABLES THE SAME WILL HALT EXECUTION AND CREATE AN ERROR * NO TWO TABLES CAN HAVE THE SAME NAME * THE DATABASE WILL TURN THE UPPERCASES TO LOWER CASES AND YOUR ARRAY WON'T MATCH THE DATABASES * STICK TO LOWER CASE IN THE SECTIONS THAT HAVE LOWER CASE AND ONLY USE UPPER CASE WHEN TYPING THE ROW * UNLESS YOU WANT TO MESS WITH IT FOR YOUR PURPOSES!!!

* IT WAS ERRORING ON LOCALHOST BECAUSE I HAD THE TABLE NAMES INCLUDING UPPER CASE CHARACTERS. WHEN IT CREATED THE DATABASES IT TURNED THEM TO LOWER CASE. THEN WHEN I CHECKED MY $_tablesArray (UPPER CASE) AGAINST THE DATABASE ARRAY(LOWWER CASE) IT RETURNED NOT IN THE ARRAY AND DELETED THEM BOTH. - users_c3p0r2d2007OG - has to be users_c3p0r2d2007og

Due to adding new features to the class last week I was running into new errors. When debbugging I realized the new error was not a new error at all but this. If you had named two databases the same they would both be erased when dropping a table. I added new logic for reporting the error. I also adding logic to report having two rows with the same name and errors and messages for everything else. PLease be carefull anyways. I take no responsibility for lost data! Use at your risk. If I have no new problems to report in the next month of developing with it than it is done. Happy Coding!!

INSTALLATION 1) Put class where you can inherit it through extends or include it. 2) Fill in database connection variables,

private $_db_host;  
private $_db_name;  
private $_db_user;  
private $_db_pass;  

3) Call $this->ArmCheckTables();

3/10/2017 - updates * added support for adding multiple rows in a table that are next to each other. * added support for droping unneeded tables - just erase them from the array.

3/13/2017 - updates * added support for changing row names * added error reporting

  Files folder image Files  
File Role Description
Plain text file Arm.php Class Class source
Accessible without login Plain text file README.md Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:119
This week:0
All time:8,560
This week:675Up