IB Comp Sci SL - March 2 2017 Lesson Notes

From Computer Science Wiki

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

  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 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?

  1. Please really start to think about your IA.
  2. watch this video: https://www.youtube.com/watch?v=NvrpuBAMddw
  3. review this presentation prior to our next class
  4. review this presentation prior to our next class
  5. It is time for you to dedicate at least 30-45 minutes every evening to working on your app.

Target.png How am I being assessed today?

  1. You are not.

Ourstandards.png Standards we are covering today

Computer1.png As a computer scientist, you have:

  • 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