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 Using Relational Tables Preparing SQL Statements

tomsteward
tomsteward
550 Points
Posted by tomsteward
tomsteward
550 Points

SQLite to PHPMyAdmin

Does anybody know what steps need to be taken to move this to PHPMyAdmin rather than SQLite?

1 Answer

Jason Anello
Jason Anello
Courses Plus Student 94,610 Points

Hi tomsteward,

The zip file download included with the videos contains a .sql file which you can import into phpmyadmin. Once you execute the sql file it should create the database and all the tables populated with the data.

The first video in this course has some instructions in the Teacher's Notes.

https://teamtreehouse.com/library/integrating-php-with-databases/databases-and-php/getting-to-know-the-project

Let me know if you get stuck.

tomsteward
tomsteward
550 Points
tomsteward
tomsteward
550 Points

Sorted. Thanks Jason.

For anyone who looks at this post for help, you can see details about connecting to a mysql database in the teachers notes here https://teamtreehouse.com/library/integrating-php-with-databases/databases-and-php/getting-started-with-pdo