Show sourcecode
The following files exists in this folder. Click to view.
.gitattributes
.gitignore
classes/
comments.php
credentials.env
dbconnect.php
envparser.php
exercises/
exercises.php
filefinder.php
img/
incl/
index-no-include.php
index.php
myexercises.php
source.php
style/
viewsource.php
dbconnect.php
26 lines ASCII Windows (CRLF)
<!-- dbconnection.php -->
<?php
require __DIR__ . '/envparser.php';
$envFilePath = __DIR__ . '/credentials.env'; // Replace with the actual path to your .env file
$envVars = parseEnvFile($envFilePath);
$dbname = 'antonlm';
$hostname = 'localhost';
$DB_USER = $envVars["user"];
$DB_PASSWORD = $envVars["password"];
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8'");
try {
$dbconn = new PDO("mysql:host=$hostname;dbname=$dbname;", $DB_USER, $DB_PASSWORD, $options);
$dbconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
/*** echo a message saying we have connected ***/
echo 'Connected to database.<br />';
} catch (PDOException $e) {
// For debug purpose, shows all connection details
echo 'Connection failed: ' . $e->getMessage() . "<br />";
// Hide connection details.
//echo 'Could not connect to database.<br />');
}