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

Databases

Alexandra Cianciara
Alexandra Cianciara
2,465 Points
Posted by Alexandra Cianciara
Alexandra Cianciara
2,465 Points

My Sql and PHP

Hi, I’m trying to understand the process. If I want to include subscription form on my HTML. Do I need to connect to my Sql/ PHP to store the database and retrieve it when I need to? I correct thinkin that these are free? I need this for small businesss.

Thank you

2 Answers

Jonathan Grieve
MOD
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Alexandra,

It should be free to develop a database on mySQL on a local server (i.e. something like XAMPP or Desktop Server. You'll use a web application called phpMyAdmin to create and manage mySQL databases.

But at some point, you're going to have to transfer the database over to a web server. Web Hosting companies will host these for you and for that, it'll be the cost of a monthly subscription to the web host that you choose. Take some time to research what's out there and see if it fits your needs. Every web host should offer mySQL databases but it depends on availability and payment plans. Web hosts should have an equivalent phpMyAdmin which you can use to import the database you created in mySQL.

Hope this makes sense. There's Treehouse content available that'll help you out when you're exporting and importing your databases. :)

Alexandra Cianciara
Alexandra Cianciara
2,465 Points
Alexandra Cianciara
Alexandra Cianciara
2,465 Points

That’s very helpful. So for the server, would I purchase this normally at the same point as I purchase server for my website (web hosting)?

Thank you

Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points
Jonathan Grieve
Jonathan Grieve
Treehouse Moderator 91,253 Points

Yes it'll all be included as part of their packages. Any reputable web host will be able to guide you on the best hosting services for your needs. And if you're not happy with any web host, you can switch any time you like! :-)