Designing solutions through programming - March 2 Lesson Notes

From Computer Science Wiki

Class plan.png What are we going to learn today?[edit]

  1. Watch this video and ensure your PHPStorm connection settings are correct. Pay attention to detail. https://youtu.be/mm1pnvjgxgU
  1. Hello wonderful students. Today you will have two things to do. One easy (but annoying) and one kind of difficult.
  1. Easy but annoying:
    1. you should have a project in PHP storm named login.
    2. the files in this project should look EXACTLY like the files here: https://github.com/bmackenty/login
    3. you can copy and paste them into your project
    4. Please pay careful attention to database_connect.php !!
    5. Please also make sure the tables we reference are the correct names
    6. ALWAYS TEST to make sure anything you change works.
  1. a little difficult:
    1. note the file user_edit.php.
    2. this file is where we can change a users email address.
    3. however, we call a file named "update_user.php" but it doesn't exist.
    4. you will need to create this file and use the following SQL syntax to update a record:
UPDATE users SET email = new_value_here WHERE id LIKE $user_id

This is hard. Good luck.

Homework.png What is our homework?[edit]

Target.png How am I being assessed today?[edit]

  1. You will get a formative mark for your work today.

Ourstandards.png Standards we are covering today[edit]

Computer1.png As a computer scientist, you have:[edit]

  • Confidence in dealing with complexity
  • Persistence in working with difficult problems
  • Tolerance for ambiguity
  • The ability to deal with open-ended problems
  • The ability to communicate and work with others to achieve a common goal or solution

Credit.png Credits[edit]