MySQLm

From Cosmic Wiki
Jump to: navigation, search

MySQLm is a PHP 5/7 wrapper for MySQLi developed by ATVG-Studios.

MySQLm was developed to easy up the use of MySQL connections in PHP.

It is open source.

Version

Legend: Old Version Old Version (Ext. Support) Old Version (Supported) Current Version Future Version

Info: "Ext. Support" ("Extended Support", "ES") means that that version (called "Legacy Version") is still being used in some of ATVG-Studios' Applications, thus they still get some sort of support.

Important: We do NOT recommend using Legacy versions, as they are old and may have security issues. ATVG-Studios is activly rewriting software that uses Legacy versions to use the Current version.

Release Version Date Changelog
Testing 2.0.0
  • New dataworks framework with JSON
Stable 1.5.11 21.11.2018
  • GetConnection function
  • GetStats function
Stable 1.5.10 19.11.2018
  • DieAfterError setting
  • Prevent force die on error
  • Keeping last error when throwing an error
Stable 1.5.9 30.06.2018
  • Fixing UserAgent Bug
Stable 1.5.8 30.06.2018
  • Account Registration
  • Custom UserAgent
  • Updates now run from GitLab
Stable 1.5.7 01.06.2018
  • Unsafe Query Execution (UQE)
  • Default charset param
Stable 1.5.6 01.06.2018
  • Added echo loggin for Updating
  • Beautifyed update test
Stable 1.5.5 12.12.2017
  • Added API Auth for more than 60 Requests from one pc (Usefull if the Update check is called on multiple sites)
Stable 1.5.4 12.12.2017
  • Changed CheckForUpdate Function
  • Added New Update System
    • Added Auto Update Function
    • Added Update Available Test Function
    • Added Make Update Function
    • Added Internal Function for cURL Github API Requests
  • Made Bugfix 6
    • Removed Password Empty Check from every Connection Function
  • Added 'php-zip' to extension check
    • [Moved Query Test]
    • [Created Updating Test]
Stable 1.5.3 10.12.2017
  • Changed Extension check
    • Added 'Curl'
    • Added Connection Check
    • Changed Error Message for MySQLi
Stable 1.5.2 10.12.2017
  • Added Input Check for execute Query
  • Added Function to execute a Query multiple times
  • Versioning
    • Added extra Version variable
    • Added Version Check with link for a new Version
    • Changed the way how the version Function returns the Version
Stable 1.5.1 10.12.2017
  • Made Bugfix 5
    • Added Escape String Trim Function call to all Query Functions to prevent SQL Injection by default
Stable 1.5.0 10.12.2017
  • Added Extension Check Fucntion
  • Changed all Connection Functions to use the Extension Check
Stable 1.4.9 03.12.2017
  • Added Default Charset
  • Splitted Query Function:
    • Added Function for Stored Querys
    • Added Function for non Stored Querys
Stable 1.4.8 30.11.2017
  • Made Bugfix 7
    • Added/Changed Charset integration for Charset in Reconnect
  • Made Bugfix 8
    • Added Connection check in close Connection
Stable 1.4.7 27.11.2017
  • Made Bugfix 3
    • Added Function to Trim and Escape Strings
  • Made Bugfix 4
    • Added Function to set Charset
    • Final Charset integration
  • Made Bugfix 5 and Bugfix 6
    • Added Function to get Information about Client and Server
    • Added Function to get Version from Client and Server
Stable 1.4.6 27.11.2017
  • Added Connection Checks
  • Added/Chaged Charset integration in __construct
Stable 1.4.5 15.11.2017
  • Changed the second return type check
Stable 1.4.4 14.11.2017
  • Added Versioning in the Code
  • Added Charset selection
Stable 1.4.2 10.11.2017
  • Added Function for Escaping Strings to top SQL Injections
Stable 1.4.1 09.11.2017
  • Execute Select
    • Input Check
    • Return Type Check
  • Added Return Type Enum Class
Stable 1.4.0 03.11.2017
  • Added Command Begin to query functions
    • executeQuery
    • executeDrop
    • executeInsert
    • executeSelect
    • executeUpdate
Stable 1.3.8 27.10.2017
  • Release with the new Internal Error System
Stable 1.3.7 25.10.2017
  • Removed Internal Error from Value Check
  • Added Internal Error to connect ndb
  • Added Internal Error to execute drop
Stable 1.3.6 25.10.2017
  • Added Function getLastInternalError
  • Added Variable lastInternalError
  • Changed many Functions to use lastInternalError
Stable 1.3.5 24.10.2017
  • Function: connect_ndb();
  • Function: selectDatabase();
  • Function: executeCreate();
  • Function: executeUse();
  • Constructor:
    • Added saving of Connection data
    • Added Input check
    • Added Error Throw on connection fail
    • Added check for empty input
  • Error Throw:
    • Changed dispose Function call to close connection
  • Dispose:
    • Added Input check
  • Execute Query:
    • Changed Throw error call for no success
  • Execute Select:
    • Added Input check
    • Added Throw error call for closed connection
    • Changed Throw error call for no success
  • Execute Insert:
    • Added Input check
    • Added Throw error call for closed connection
    • Changed Throw error call for no success
  • Execute Delete:
    • Added Input check
    • Added Throw error call for closed connection
    • Changed Throw error call for no success
  • Execute Drop:
    • Added Input check
    • Added Throw error call for closed connection
    • Changed Throw error call for no success
Stable 1.3.4 24.10.2017
  • Changed Version notation
Stable 1.3.3 24.10.2017
  • Fixed wrong function call
Stable 1.3.2 24.10.2017
  • Value Check Function
  • Added Value Check Function call to all Functions
Stable 1.3.1 24.10.2017
  • Check to only execute querrys on open connections
  • Added Error Throws when connection is closed
Stable 1.2.0 24.10.2017
  • MySQLm is now going Public

License

MySQLm is Licensed under OSPL and can be found here: https://github.com/AtjonTV/MySQLm

Support

MySQLm has been listed as a LTS Support Application, that means ATVG-Studios serves Support for that Application for 3 years since creation.

Support Start: October 2017, Support End: October 2020