Sometimes, we want to set up a PDO connection with PHP.
In this artoicle, we’ll look at how to set up a PDO connection with PHP.
How to set up a PDO connection with PHP?
To set up a PDO connection with PHP, we can use the PDO
class.
For instance, we write
$provider = function()
{
$instance = new PDO('mysql:......;charset=utf8', 'username', 'password');
$instance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$instance->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
return $instance;
};
$factory = new StructureFactory($provider);
$something = $factory->create('Something');
$foobar = $factory->create('Foobar');
to create the $provider
function.
In it, we create a PDO
object with the connection string and the username and password.
And then we call setAttribute
to set a few settings for error mode and disable the emulation of prepared statements.
Next, we create a StructuredFactory
object with the $provider
function.
And then we call $factory->create
to create the connections.
Conclusion
To set up a PDO connection with PHP, we can use the PDO
class.