I’m trying to create a simple to use singleton class to connect to mysql database and do queries, the code works fine and i haven’t had any problems with it, but since I’m new to OOP I’m wondering whether this is bad practice or not.
I’ve been working on a small project using PHP and MySQL. I’ve read a lot around about best practices on managing a connection and so on.
I am new in react-native coding but have experienced on objective-c and swift coding and want use singleton pattern in react-native.
I have tried to find out the solution from other StackOverflow answer but most of them are creating only singleton functions as below code:
I was looking at this code where a class instance is exported in a little bit weird way.
How would one create a Singleton class using PHP5 classes?
I access my MySQL database via PDO. I’m setting up access to the database, and my first attempt was to use the following:
What is the benefit of using singleton instead of global for database connections in PHP? I feel using singleton instead of global makes the code unnecessarily complex.
Possible Duplicate:
Who needs singletons?
Why is testing singletons or registry pattern hard in a language like PHP which is request driven?
In Codeigniter, get_instance() is a globally available function that returns the Controller super-object which contains all the currently loaded classes (it returns the Controller class instance). I’ll include the current source code:
