Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host='localhost';
- $db='canda';
- $user='root';
- $pass='123456789';
- try{
- new PDO("mysql:host=".$host
- ."; dbname=".$db,
- $user, $pass);
- }catch (PDOException $e) {
- echo $e;
- }
- $host = DB_HOST; // just ignore constants //
- $user = DB_USER;
- $pass = DB_PASS;
- $dbname = DB_NAME;
- $dsn = 'mysql:host=' . $host . ';dbname=' . $dbname;
- // Set options
- $options = array(
- PDO::ATTR_PERSISTENT => true,
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
- );
- // Create a new PDO instanace
- try{
- $this->dbh = new PDO($dsn, $user, $pass, $options);
- }
- // Catch any errors
- catch(PDOException $e){
- $this->error = $e->getMessage();
- }
Add Comment
Please, Sign In to add comment