Designing solutions through programming - March 2 Lesson Notes: Difference between revisions

From Computer Science Wiki
No edit summary
Line 7: Line 7:
# Watch this video and ensure your PHPStorm connection settings are correct. Pay attention to detail. https://youtu.be/mm1pnvjgxgU
# Watch this video and ensure your PHPStorm connection settings are correct. Pay attention to detail. https://youtu.be/mm1pnvjgxgU


# We will review our exam
# Hello wonderful students. Today you will have two things to do. One easy (but annoying) and one kind of difficult.
# We will review our web application and get into the last bits to know and understand
 
# Easy but annoying:
## you should have a project in PHP storm named login.
## the files in this project should EXACTLY like the files here:  https://github.com/bmackenty/login
## you can copy and paste them into your project
## Please pay careful attention to database_connect.php !!
## Please also make sure the tables we reference are the correct names
## ALWAYS TEST to make sure anything you change works.
 
# a little difficult:
## note the file user_edit.php.
## this file is where we can change a users email address.
## however, we call a file named "update_user.php" but it doesn't exist.
## you will need to create this file and use the following SQL syntax to update a record:
 
<syntaxhighlight lang="sql">
UPDATE users SET email = new_value_here WHERE id LIKE $user_id
</syntaxhighlight>
 
This is hard. Good luck.
 
</td>
</td>


Revision as of 07:12, 1 March 2017

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

Use an idea, equation, principle, theory or law in relation to a given problem or issue.

Retrieved from "https://computersciencewiki.org/index.php?title=Designing_solutions_through_programming_-_March_2_Lesson_Notes&oldid=5135"