Category:Mathematics textbooks
Category:Real analysisQ:
How to move the code responsible for resetting the database connections to a.init.php file?
In the following code, I believe I have initialized all the database connections inside the application, and then run the code that handles data insertion and retrieval.
I've tried to move the SQL Insert & Retrieve code into a.php file (database.php) and call it from the index.php file, but this doesn't seem to work.
class Model
{
private $db;
function __construct()
{
$this->db = new PDO('mysql:host=localhost;dbname=test_db', 'root', '', []);
}
function insert($table, $data)
{
$this->db->prepare("INSERT INTO $table ($table) VALUES ($data)");
$this->db->execute();
}
function select($table, $where)
{
$this->db->prepare("SELECT * FROM $table WHERE $where");
$this->db->execute();
$result = $this->db->fetchAll();
return $result;
}
}
A:
Database connections are not shared across class instances. A single connection is used for the entire life of an instance, and new instances are simply sharing the same connection as the original one.
What you can do is make your connection and query methods static, and you can still inject the connection via a property:
class Model
{
private static $db;
function __construct()
{
self::$db = new PDO('mysql:host=localhost;dbname=test_db', 'root', '', []);
}
public static function insert($table, $data)
{
self::$db-> ac619d1d87
Related links: