Breaking News: Grepper is joining You.com. Read the official announcement!

PDO connect

Add Answer

Powerful Pygmy answered on August 9, 2020 Popularity 9/10 Helpfulness 5/10

answer PDO connect

related pdo connection

related connect pdo

PDO connect

Comment

-1

<?php
$db = new PDO('mysql:host=myhost;dbname=mydb', 'login', 'password');

Popularity 9/10 Helpfulness 5/10 Language php

Source: www.php.net

Tags: connect pdo php

Link to this answer
Share Copy Link

Contributed on Aug 09 2020

Powerful Pygmy

0 Answers Avg Quality 2/10

Closely Related Answers

pdo connection

Comment

<?php
$servername = "localhost";
$username = "root";
$password = "";

try {
  $conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  echo "Connected successfully";
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}
?>

Popularity 9/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Jul 20 2022

hussein asadi

0 Answers Avg Quality 2/10

pdo connection

Comment

//In this PHP DATA OBJECT (PDO) CONNECTION I am gonna use 
//the exception code that will help hide your database login 
//details from your users if there is an exception (error).
 //dbname(database name)
 //charset(characters encoding )

  try {
    $pdo = new PDO('mysql:host=localhost;dbname=joke;charset=utf8','username','password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
  echo 'Successfully Connected to the database';
  } catch (PDOException $e) {
    echo 'ErrorException'.$e->getMessage().'in'.$e->getFile().$e->getCode().$e->getLine();
  }

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: connection c

Link to this answer
Share Copy Link

Contributed on Apr 24 2022

Omo Junior

0 Answers Avg Quality 2/10

connect pdo

Comment

$host = '127.0.0.1';
$db   = 'test';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
try {
     $pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
     throw new \PDOException($e->getMessage(), (int)$e->getCode());
}

Popularity 8/10 Helpfulness 3/10 Language whatever

Source: phpdelusions.net

Tags: connect pdo

Link to this answer
Share Copy Link

Contributed on Jun 13 2022

Pua Jing Sheng

0 Answers Avg Quality 2/10

PDO connect

Contents

More Related Answers

PDO connect

Closely Related Answers

pdo connection

pdo connection

connect pdo

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.