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 Querying the Database with PHP Integrating Database Results

Posted by Mike Hansen
.a{fill-rule:evenodd;}techdegree
Mike Hansen
Python Web Development Techdegree Student 3,419 Points

What program can i use to edit the database.db ?

Hello everyone, I am currently making this website in Brackets and everything works great! But i kinda can't open the database.db, i am using Brackets and it just says it only can support utf-32. What can i use to edit the database.db?

1 Answer

Kevin Korte
Kevin Korte
28,149 Points
Kevin Korte
Kevin Korte
28,149 Points

You would import that db file into mysql, and than you could use your command line, or another popular solution would be to use phpmyadmin to give you a GUI (graphic user interface) to work with, edit, and delete the database data.

I'm assuming you have something like xampp, mamp, or wamp installed, and know how to start apache and mysql

Mike Hansen
.a{fill-rule:evenodd;}techdegree
Mike Hansen
Python Web Development Techdegree Student 3,419 Points

I found out i had another file called database.sql and i can edit that so problem solved! :)

Kevin Korte
Kevin Korte
28,149 Points
Kevin Korte
Kevin Korte
28,149 Points

Very cool! Good to here