Confused with SQL

Question

So Im doing the SQL lessons and Im getting pretty confused. The word "commands" keeps getting used in these lessons. Where are we supoosed to use the commands? Do they go in the file with your code? Or in your terminal? If we're supposed to do it in the terminal, then how does all that get setup? Like if I had a database created thru phpmyAdmin, how would I link that to my actual application to be able to use these commands? I feel like the SQL lessons are poorly structured, not enough info.

Answer 1

Hi @Garrett, well I suppose the word "command" in the lesson would refer to the SQL commands, the instructions we can use to "command" the database server to respond to our request.

I see you mentioned phpMyAdmin, then I would assume you already have a PHP package installed in your machine, the next step you will take would be to begin writing code in PHP, as it is through PHP we can access the database. I cannot provide you a detail on everything, as I'm also still learning, so I guess I'll just pass you this link, where you can see examples of how to connect, and manipulate data by using PHP, hope it helps somehow:

http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

Answer 2

Ipang PHP package? I just created a database in my web hosting control panel with PHPMyAdmin but I have no idea what I am doing. Which is why I started the SQL lessons on here.