Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- class DB {
- private $conn;
- private $servername = "localhost";
- private $username = "user";
- private $password = "pass";
- private $charset = "UTF8MB4"; // if your db does not use CHARSET=UTF8MB4, you should probably be fixing that
- private $options = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, // highly recommended
- PDO::ATTR_EMULATE_PREPARES => false // ALWAYS! ALWAYS! ALWAYS!
- ];
- public function __construct(){
- try {
- $dns = "mysql:host=$this->servername;dbname=$this->username;charset=$this->charset";
- $this->conn = new PDO($dns, $this->username, $this->password,$this->options);
- } catch(PDOException $e){
- echo "Connection failed: " . $e->getMessage();
- }
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement