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 PHP & Databases with PDO Getting Started With PDO Introductions

Elena Paraschiv
Elena Paraschiv
9,938 Points

Can I write all this using MySQL Workbench?

I want to take this course on local computer

2 Answers

Justin Kraft
Justin Kraft
26,327 Points

You could but if you look into installing mamp, wamp, or xampp depending on your os, they have MySQL, PHP, and Apache server so you can test your webpages on localhost.. Free of charge.

In this course, Hampton uses an sqlite database. Sqlite and MySQL are two different types of database, so you won't be able to use MySQL Workbench to follow along with the course.

But there is a lot of free software that will provide the same sort of GUI as MySQL Workbench. Just search 'sqlite gui' using your favourite search engine and you'll find something.

Alternatively you can use the command line tool Hampton uses in the video. Sqlite lives inside your php install and should work out of the box with MAMP/WAMP.

You can also be totally awesome and follow along with the course using a MySQL database instead of sqlite!