Skip to content

Instantly share code, notes, and snippets.

@samsargent
Last active December 16, 2015 11:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samsargent/5429552 to your computer and use it in GitHub Desktop.
Save samsargent/5429552 to your computer and use it in GitHub Desktop.
PHP: SlimPHP PDO database connection
<?php
function getConnection() {
$dbhost="127.0.0.1";
switch(ENV){
case 'dev':
$dbuser="username";
$dbpass="password";
$dbname="databasename";
break;
case 'prod':
$dbuser="username";
$dbpass="password";
$dbname="databasename";
break;
}
$dbh = new PDO("mysql:host=$dbhost;dbname=$dbname", $dbuser, $dbpass);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $dbh;
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment