Designing solutions through programming - March 2 Lesson Notes

From Computer Science Wiki
Jump to navigation Jump to search

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.
  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:
    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]