Source

---

Quick Reference

PHP

• $_GET - this tag holds an array of the data that has been set in the URI (URL), data is set after the URI file name, after the questionmark, first is the name of the variable, follwed by "=" and the data.
• Double and Single quotes - To echo or define raw data (like html or just text) you have to put the data between brackets so that PHP knows where the data starts and where it ends.
  • Single Quotes - Data between single quotes is printed out EXACTLY the way it's inside those quotes.
    eg. in this case $test = 'jack', the following: echo 'hello $test'; becomes hello $test
  • Double Quotes - Data between double quotes can contain variables, these variables will be evaluated.
    eg. in this case $test = 'jack', the following: echo "hello $test"; becomes hello jack

MySQL

uppercase characters are MySQL commands, lowercase characters are custom data.

• WHERE - This specifies what rows you want to receive from the table, in the example we're getting a specific identification number from the id row.
  So we're getting data from the table WHERE the id is a specific number.