Designing solutions through programming - March 2 Lesson Notes

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.