1 config.php PDO::ERRMODE_EXCEPTION, 12 13 PDO::ATTR_DEFAULT_FETCH_MODE => PDO:: FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, 14 ]; 15 16 try { 17 18 19 $pdo = new PDO($dsn, $user, $pass, $options); } catch (\PDOException $e) { throw new \PDOException($e->getMessage(), (int)$e->getCode()); 20 } 21 22
1 config.php PDO::ERRMODE_EXCEPTION, 12 13 PDO::ATTR_DEFAULT_FETCH_MODE => PDO:: FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, 14 ]; 15 16 try { 17 18 19 $pdo = new PDO($dsn, $user, $pass, $options); } catch (\PDOException $e) { throw new \PDOException($e->getMessage(), (int)$e->getCode()); 20 } 21 22
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Hi good day i'm getting this error when trying to access localhost for my
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1049] Unknown database 'car_sales_db' in C:\xampp\htdocs\Tutorial\config.php:19 Stack trace: #0 C:\xampp\htdocs\Tutorial\index.php(2): require() #1 {main} thrown in C:\xampp\htdocs\Tutorial\config.php on line 19
![1
config.php
<?php
2 $host
= 'localhost';
3
$db
=
'car_sales_db';
4
$user
=
5
$pass
6
$charset
7
8
$dsn =
'terre'; // Replace with your MySQL username
// Replace with your MySQL password
'utf8mb4';
"mysql:host=$host; dbname=$db; charset=$charset";
9
10
$options [
11
PDO::ATTR_ERRMODE
=> PDO::ERRMODE_EXCEPTION,
12
13
PDO::ATTR_DEFAULT_FETCH_MODE => PDO:: FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES
=> false,
14
];
15
16
try {
17
18
19
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
throw new \PDOException($e->getMessage(), (int)$e->getCode());
20
}
21
22](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4cdae6ad-cbeb-4ce2-bd08-01028f7a85ec%2Fbaac2640-b0e8-4153-a339-973e7c8065d6%2Fhe27s3v_processed.png&w=3840&q=75)
Transcribed Image Text:1
config.php
<?php
2 $host
= 'localhost';
3
$db
=
'car_sales_db';
4
$user
=
5
$pass
6
$charset
7
8
$dsn =
'terre'; // Replace with your MySQL username
// Replace with your MySQL password
'utf8mb4';
"mysql:host=$host; dbname=$db; charset=$charset";
9
10
$options [
11
PDO::ATTR_ERRMODE
=> PDO::ERRMODE_EXCEPTION,
12
13
PDO::ATTR_DEFAULT_FETCH_MODE => PDO:: FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES
=> false,
14
];
15
16
try {
17
18
19
$pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
throw new \PDOException($e->getMessage(), (int)$e->getCode());
20
}
21
22
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education