function getCon() { $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } return $conn; }
function getCon() { $dsn = "mysql:host=localhost;dbname=myDB"; $username = "username"; $password = "password"; try { $conn = new PDO($dsn, $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $conn; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } }In this example, the "getCon" function uses the PDO extension to establish a connection with a MySQL database. The function takes no parameters and returns the connection object. If the connection fails, an error message is displayed. Package/Library: Both examples are using PHP extensions (mysqli and PDO) to interact with the database, which are built-in and part of the PHP standard library.