Create a Mysql Database Connection Using PDO

Example: Create a MySql Connection using PDO (PHP Data Object)

<?php
	// Creating MySql PDO Connection 
	$servername = "localhost";
	$username = "username";
	$dbname = "databasename";
	$password = "password";

	try {
		$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
		// set the PDO error mode to exception
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		echo "Connected successfully"; 
    }
	catch(PDOException $e) {
	    // error handling
		echo "Connection failed: " . $e->getMessage();
    }
?>

Example: Closing PDO Connection

<?php
	// Closing MySql PDO Connection 
	$conn = null;
?>