Designing Solutions Through Programming

Friday 25 September 2020 - Block 1, Room C152

← previous note | most current note | next note →

Daily Note

1. You must copy the files below into visual studio code
2. You must make sure the file names are EXACTLY the same as noted in the points below
3. You must replace your files with the files linked below
   
    
4. We are going to add a special file that allows us to connect to a database! (database_inc.php)
   1. please copy this file to Visual Studio Code,EDIT THE FILE AS DIRECTED, and save / upload the file. 
       
5. We are going to add pages that make login and registration page work: 
   1. add store_login.php
   2. add or replace store_register.php
   3. add store_register_process.php
   4. add store_login_process.php
   5. add store_logout.php
   6. please copy these files to Visual Studio Code and save / upload the file. 
       
6. We are going to add a setup file that creates a database for us (link to template here)
   1. You must run this file until all the alerts are green. There are 4. 
       
7. We are going to add a page that let's us ADD an item to our database. You need two files for this:
   1. template store_add_new_item.php is here.
   2. template store_add_new_item_process.php is here. 
   3. please copy these files to Visual Studio Code,EDIT THE FILE AS DIRECTED, and save / upload the file. 
       
8. We are going to add a page that works like a control panel You need one file for this:
   1. template store_control_panel.php
   2. please copy these files to Visual Studio Code,EDIT THE FILE AS DIRECTED, and save / upload the file. 
       
9. We are going to add a page that let's us EDIT an item to our database. You need three files for this:
   1. template store_edit_item.php
   2. template store_edit_item_process.php
   3. template store_update_edited_item.php
   4. please copy these files to Visual Studio Code,EDIT THE FILE AS DIRECTED, and save / upload the file. 
       
10. We are going to add a page that let's us have only one navbar. 
    1. template store_navbar.php
        
11. We are going to add store inventory page, where you can see all your inventory items
    1. template is here: store_inventory.php
        
12. We are going to add delete an item functionality. There are TWO files here:
    1. template store_delete_item.php
    2. template store_delete_item_process.php
       
        
13. We are going to add a user control panel. there are FOUR files:
    1. template store_user_control_panel.php
    2. template store_user_delete_process.php
    3. template store_user_edit.php
    4. template store_user_edit_process.php
        
14. To test: 
     
    1. always run store_setup.php to see if there are any problems or missing files. 
    2. register a user
    3. login as that user
    4. create a new item. Verify you can see this new item in store_inventory.php
    5. edit an item. Verify the item has been edited in store_inventory.php
    6. delete an item. Verify the item has been deleted in store_inventory.php
        
15. Please add 8 items to your store. Please make sure your image links to a file that ends with .jpg, .jpeg, or .png
     
16. Please download this file and run it in your browser:
    1. the name of the file should be store_database_example.php
    2. We will discuss how this file works
17. Please follow along so you can see how html, databases, and php all work together
     
18. Homework is always posted on google classroom (and only google classroom)

Tags

Reminders & routines:

IF (today ==  testing_day_for_me) {
     remember to go get tested!;
}

IF (this_block == first_block_day) {
     read_daily_bulletin;
}

IF (today == Friday) {
     current_event_activity();
}

As I am taking attendance:

1. For students who are physically at ASW: Please check now: am I connected to the American School of Warsaw wireless network
2. Please check now: is visual studio code working from my programming folder?
3. test

Our learning

This is a beta feature. Please let me know if you have any feedback.

Please click here to reflect on our learning for today's class.