Hello.
I am trying to make my own mysql wrapper that i can use for my small projects.
I have a class MySQLWrapper that has all the methods concerning queries, sanitation, etc. as well as some statistics about the last query performed. I am declaring the instance on the index page using $DbCon = new MySQLWrapper(); All required files are included through index page, somewhat like front controller. Generally it works fine, but obviously i cannot access $DbCon from within other functions or classes unless i do something ugly like $GLOBALS['DbCon']->query($
sqlCheckUs
er). Passing $DbCon as a parameter increases the number of required parameters for all the function/method which isn't pretty either. How else can DB be accessed by any class that needs it, while confirming with good coding practices?
P.S
I once tried to create an instance within the class which does work everywhere, something like:
private $instance_MySqlDb = null;
public function Instance() {
if(self::$instance_MySqlDb
== null) {
self::$instance_MySqlDb = new self();
}
return self::$instance_MySqlDb;
}
and then access the DB through mysqlwrapper::Instance->qu
ery but got many warnings about bad practice or something.
I am still new to OOP.
btw:
I want to create my own because others miss out what i need or have something i don't need, frameworks are too big for small projects and just for practice. So suggestions about using a premade one won't be accepted. However, i will consider looking at premade ones if i am to learn from them only.
Thank you.
Start Free Trial
