I am using MAMP as a local server. I downloaded the database.sql from the tutorial here and imported it into my phpMyAdmin database. In connection.php file in my editor, the code I have written is: ```php $db = new PDO("sqlite".DIR."/database.db"); var_dump($db); ``` I cannot see anything when I preview this in the browser by typing "inc/connection.php". Can anyone please help, What am I doing wrong here.??

Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Watch Video

Posted January 29, 2019 9:52am by

PDO is not connecting to the Database. Please help

I am using MAMP as a local server. I downloaded the database.sql from the tutorial here and imported it into my phpMyAdmin database. In connection.php file in my editor, the code I have written is:

$db = new PDO("sqlite".__DIR__."/database.db");

var_dump($db);

I cannot see anything when I preview this in the browser by typing "inc/connection.php". Can anyone please help, What am I doing wrong here.??

1 Answer

January 29, 2019 4:29pm

There should be a colon : after sqlite. Also that is a connection for sqlite. You'll need a connection for MySQL.

The teacher's notes here MAMP and PDO:

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.