Designing solutions through programming - March 2 Lesson Notes

From Computer Science Wiki
Revision as of 06:10, 1 March 2017 by Mr. MacKenty (talk | contribs) (Created page with " # Watch this video and ensure your PHPStorm connection settings are correct. Pay attention to detail. https://youtu.be/mm1pnvjgxgU # Hello wonderful students. Today you wil...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


  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.