PHP and MySQL – Head First Book

Chapter 1: Adding Life to Web Pages with PHP

  • Goals
    • Learn the basic syntax and commands of PHP
  • Terms
    • HTML
    • PHP
    • Web Form
    • Browser
    • <?php ?>
    • Variable
    • Quotes
    • Echo
    • $_POST
    • Web Server
    • Array
    • Superglobal
    • Mail()
  • Concepts
    • HTML on Client side
    • PHP on Server side
    • PHP Syntax and command structure
  • Resources
  • Projects
    • Aliens Abducted Me HTML Form
      • Build a HTML form
        • Read pages 1 – 7 in book
        • Create report.html
          • You can download from the Head First web site linked above.
          • It’s in the chapter 1 download titled cho1
          • within the initial folder
        • Publish the initial folder, with the report.html file in it, on your hulk account
        • Post a blog entry detailing what you learned and place a link to your report.html file on hulk
    • Aliens Abducted Me PHP Form
      • Build aPHP form
        • Read pages 8 – 57 in book
        • Create report.php
          • You can download from the Head First web site linked above.
          • It’s in the chapter 1 download titled cho1
          • within the final folder
        • Publish the final folder, with the report.php file in it, on your hulk account
        • Post a blog entry detailing what you learned and place a link to your report.php file on hulk
    • Quiz at end of exercises
      • Be prepared to Answer all three of the Brain Power questions and both Sharpen Pencil challenges

Chapter 2: Connecting to MySQL with PHP

  • Goals
    • Learn how to connect PHP to MySQL database and enter data from a web form
  • Terms
    • MySQL database server
    • Database
    • Table
    • query
    • mysqli_connect()
    • mysqli_close()
    • mysqli_query()
    • mysqli_select_db()
  • Concetps
    • Database interactivity with PHP scripts
  • Resources
  • Projects
    • Build the alien_abduction table in MySQL
      • Pages 64-69 in the book
    • Modify Report.php to submit entries into database
      • Pages 65-95
      • Publish to hulk
      • Create a blog entry with link to working report.html form in the CH02 folder
    • Use queries to look at the information in the database
      • Pages 96-98

Chapter 3: More MySQL Basics

2 thoughts on “PHP and MySQL – Head First Book

Leave a Reply

Your email address will not be published. Required fields are marked *