Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $DB_HOST = 'localhost';
- $DB_LOGIN = 'root';
- $DB_PASS = 'password_here';
- $DB_NAME = 'Database_Name_Here';
- $charset = 'utf8mb4';
- $options = [
- \PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION,
- \PDO::ATTR_DEFAULT_FETCH_MODE => \PDO::FETCH_ASSOC,
- \PDO::ATTR_EMULATE_PREPARES => false,
- ];
- $dsn = "mysql:host=$DB_HOST;dbname=$DB_NAME;charset=$charset";
- try{
- $pdo = new PDO($dsn, $DB_LOGIN,$DB_PASS,$options);
- $connected = "You are successfully connected to the ".$DB_NAME." database";
- return $connected; //To Test echo $connected on home page to show connection
- }catch(PDOException $e){
- die ('Connection Failed: '.$e->getMessage());
- }
- ?>
RAW Paste Data
Copied