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

Daniel Hildreth
Daniel Hildreth
16,170 Points
Posted by Daniel Hildreth
Daniel Hildreth
16,170 Points

PDO PHP/MySQL and Blog/Forum

Hey Treehouse students and teachers. Does anyone know of a good tutorial base for non-deprecated code for making a blog/forum using PDO PHP; preferably a video tutorial? I've looked a few tutorials up and some are hard to understand. Also, most I've seen like on YouTube are using deprecated code, or are using the mysqli format and not PDO PHP. I've been told PDO PHP is the best route on this project, but can't seem to find good sources. I really so far only need help with the pagination and the login page. You can find my current work on GitHub.

https://github.com/HanSolo0001/Blogging-System

Also, is this something maybe Treehouse could make a tutorial for us (without it being a WordPress blog)?

1 Answer

Robert Walker
Robert Walker
17,146 Points
Robert Walker
Robert Walker
17,146 Points

I feel your pain, sadly there are not a huge amount of great videos out there to explain PDO and how to use it for actual tasks like building a blog or a forum but there are great videos here on Treehouse that combine well and give you everything you would need to build your own blog.

It wont be easy and there will be a lot of things you will need to figure out yourself but the end result will be worth it, not only will you have a great blog to use but you will of also gained a huge amount of knowledge in how to plan, build out and refine / refactor your project.

PDO with MYSQL.

Randy! Using PHP and MySQL

This one by Hampton is super useful.

Hampton! PHP databases with PDO

These are the same thing but Randy is the man so worth watching! love to Alena too though!

Randy! Build a simple php application

Alena! Build a basic PHP website

You could also look at Database Foundations by Andrew a really helpful course if you want to build database applications like a forum or blog.

Andrew! Database Foundations

Together these will give you everything you need to build out a blog or forum.

There are a huge amount of other courses that will walk you through JavaScript too so you can deal with AJAX requests too, adding more functionality to your project.

I often find myself looking for ways to build something and always end up going back over videos and courses I have completed here on Treehouse.