Skorpius

Basic PDO Connection

Feb 10th, 2023
1,147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. <?php
  2.  
  3.     $DB_HOST  = 'localhost';
  4.     $DB_LOGIN = 'root';
  5.     $DB_PASS  = 'YOUR_PASSWORD';
  6.     $DB_NAME  = 'DATABASE_NAME';
  7.  
  8.     $dsn = '';
  9.    
  10.     try{
  11.        
  12.         $dsn = 'mysql:host='.$DB_HOST.';dbname='.$DB_NAME;
  13.        
  14.         $pdo = new PDO($dsn, $DB_LOGIN,$DB_PASS);
  15.        
  16.         $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  17.        
  18.         echo "Connected to ".$DB_NAME; //Comment out when connection established
  19.        
  20.     }catch(PDOException $e){
  21.        
  22.         die ('Connection Failed: '.$e->getMessage());
  23.        
  24.     }
Advertisement
Add Comment
Please, Sign In to add comment