Login   Register  
PHP Classes
elePHPant
Icontem

Current class features - MySQL Access Wrapper package blog

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  All package blogs All package blogs   MySQL Access Wrapper MySQL Access Wrapper   Blog MySQL Access Wrapper package blog   RSS 1.0 feed RSS 2.0 feed   Blog Current class features  
  Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  
>> Next: Soon to be PDO, MySQL...

Author: Bogdan Lupandin

Posted on:

Package: MySQL Access Wrapper

A list of current features the class holds.




Current Features

1) Filtering of SQL query functions passed through the class (SELECT, JOIN, TRIM, etc)
2) Filtering of SQL functions passed through the class (CREATE, DROP, ALTER, INSERT, etc).
3) private functions, variables... protected SQL credentials
4) Error Handling
5) Automatically cleans user input (from form submittions)
6) SQL Caching
7) Debug Capabilities
     A) Configurable debug
     B) Admin debugging or user debugging
     C) Turning the debugging on/off
8) View tabular SQL content right from the package
9) Error logging
9) Fetch a row or a rowset as objects, array, associative array, row.
10) Restarting a database connection, ending it, starting it
11) Separate variable file (XML or PHP file)
     A) What this is, you hold the server, username and password in a separate file and the database class includes it to use those credentials.
12) Extensive comments in class voids any reason to need a documentation file for the class

Planned Features

1) Expiration dates for cache files (Right now if you cache an SQL results it'll stay there forever until you manually delete the cache files)
2) PDO and MySQL(i) compatible
3) Better OOP (means better security... not like it's bad now)
4) Better filtering of SQL functions, query functions and input validation

That's as far as I can think of right now... and feature requests could be sent to me by email (email found in db.php in my database class submittion).

You need to be a registered user or login to post a comment

Login Immediately with your account on:

Facebook ConnectGmail or other Google Account
Hotmail or Microsoft Windows LiveStackOverflow
GitHubYahoo


Comments:

No comments were submitted yet.


>> Next: Soon to be PDO, MySQL...


  Post a comment Post a comment   See comments See comments (0)   Trackbacks (0)  
  All package blogs All package blogs   MySQL Access Wrapper MySQL Access Wrapper   Blog MySQL Access Wrapper package blog   RSS 1.0 feed RSS 2.0 feed   Blog Current class features