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

PHP Integrating PHP with Databases Databases and PHP Handling Exceptions

Riki Tiilikainen
Riki Tiilikainen
4,042 Points

Database connection keeps creating a new database

This tutorial works in the workspaces environment, but not when I test locally and I can see that a few other people have had the same problem, but no solution posted. When I test the connection, locally using MAMP it creates a new database whenever I break the connection. Does anyone know why this is happening? Also, won't let me post an underscore by the DIR here! AH

<?php

try{ $db = new PDO ("sqlite:". _ _ DIR _ _ ."/database.db"); $db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); var_dump($db); } catch (Exception $e){ echo 'Caught exception: ', $e->getMessage(); exit; } echo "Connected to Database";

?>

2 Answers

Jennifer Nordell
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Jennifer Nordell
Treehouse Teacher

Hi there, Riki Tiilikainen ! This is now the expected functionality. In newer versions of PHP/SQLite drivers, if the database cannot be found, it creates a new database for you. However, if you are working with legacy code, this may not be the case. There can also be other reasons for a connection to not be established.

On your local machine and using newer versions of PHP, you should expect that if the database file cannot be found, another database file matching the one you're trying to connect to will be created for you.

Hope this helps! :sparkles:

Hello Jennifer and Treehouse Team :smiley: it would be great to add this information to the teacher' s notes or to update the video. :pray: Thank you