Author: nayeon

To-do for today’s class

• Download starter file: https://drive.google.com/drive/folders/1Gw0hfGwr49N_4kJd9IXwAjoJYLuk7hAJ?usp=sharing
• Rellax JS: https://dixonandmoe.com/rellax/
• Lightbox JS: https://lokeshdhakar.com/projects/lightbox2/
• Draggabilly: https://draggabilly.desandro.com/

Slides

Link to download PDF version.

Completed Files

• Coming soon…

To-do for today’s class

• None

Slides

View Slides
Link to download PDF version.

Completed Files

No completed files.

To-do for today’s class

• Download starter file
• Some fun animations:
  • https://codepen.io/matchboxhero/pen/EwdmmP?editors=1100
  • https://codepen.io/benstanley/pen/icqok
  • https://codepen.io/nxworld/pen/ZYNOBZ
  • https://tympanus.net/Tutorials/OriginalHoverEffects/index.html

Slides

Link to download PDF version.

Resources

• https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Animations/Using_CSS_animations
• https://developer.mozilla.org/en-US/docs/Web/CSS/CSS_Transitions/Using_CSS_transitions
• https://developer.mozilla.org/en-US/docs/Web/CSS/transform

Completed files

• 12pm: https://github.com/nayeonk/itp303-spring-2022-12pm/tree/master/lect23-css-transitions/
• 4pm: https://github.com/nayeonk/itp303-spring-2022-4pm/tree/master/lect23-css-transitions/

To-do for today’s class

• Save this Google drive folder in the itp104 folder that you are saving all the lecture material in:
  https://drive.google.com/drive/folders/1RsaZ9G26riWms1DBLaRVKnu9qzwwBxD-?usp=sharing
  Click on the folder name -> Download to get a .zip of this folder.

Slides

View Slides
Link to download PDF version.

Completed Files

Completed files are stored in a GitHub repository. Links below will take you to a list of file(s) from today’s lecture. You can view the code via the browser through GitHub’s UI or clone/download the repo to open the code from your computer.

• https://github.com/nayeonk/itp104-spring-2022/tree/master/lect13-bootstrap

To-do for today’s class

• Download starter file: lect21-ajax-php/

Slides

Link to download PDF version.

Completed files

• 12pm: https://github.com/nayeonk/itp303-spring-2022-12pm/tree/master/lect21-ajax-php
• 4pm: https://github.com/nayeonk/itp303-spring-2022-4pm/tree/master/lect21-ajax-php

Overview

This assignment serves as a milestone to help you progress along with your final project. Now that you submitted a proposal and have an idea of what kind of web application you want to build for the final project, you can start writing code.

Requirements

1. Refer to the wireframes you created in your final project proposal. Your first step in building the final project will be writing HTML and CSS to build the front-end parts of your web application. In other words, you are building the “shell” of your web application. Later, you will need to insert PHP into these pages to connect to your database and run the necessary SQL queries, so keep in mind how you want the backend logic to flow as well.
2. Setup: Create a folder named assignment11 and add save all files in here. When ready to submit, upload this entire folder to the web server via FileZilla.
3. Create at least four (4) pages.
4. You may use CSS frameworks like Bootstrap but you may NOT use HTML templates. Layouts must be your own original work.
5. Must have a clear purpose and topic. All pages make up a cohesive website.
   1. Have a clear and obvious logo (can be text) or page title in the same area on every page.
   2. Have a clear and obvious navigation menu that makes it easy for users to navigate around the site.
6. All pages must meet the responsive web design requirements of the final project. The pages must look complete on the following three breakpoints:
   1. Mobile: 767px and smaller
   2. Tablet: 768px – 991px
   3. Desktop: 992px and larger
7. While you are not graded on the aesthetic value of the website, you will be docked points if there are any obvious issues such as:
   1. Unreadable text, due to:
      1. text is too small
      2. color of text blends in with the background
   2. Text or images get cut off at the edges of the screen
   3. Extraneous horizontal scrolling (i.e. don’t let the user scroll if you don’t need to).
8. You do not need to write any PHP or SQL at this point (although you can if you’d like).
9. Use hardcoded values and/or placeholders for data that you will eventually receive from the back-end (similar to the starter code provided for you for the CRUD lectures).

Submission/Upload to the server

Please follow the submission requirements below carefully. You will be deducted points for not following submission requirements to the teeth.

1. Open a browser and go to https://303.itpwebdev.com/cpanel (it will redirect you to https://54-148-150-30.cprapid.com:2083/).
2. Login with your username and password (this password does not sync with your USC NETID password. You set this password in Lab 1. If you don’t remember your password, post on EdStem and a course staff member will reset it for you).
3. Scroll down to Files section and click on File Manager. You will see a list of folders and files like below.
   
4. Double click to navigate inside the public_html folder.
5. Create a new folder inside the public_html folder by clicking on the +Folder button on the top left.
   
6. Name the folder assignment11. Double click it to navigate inside this folder.
7. Click on “Upload” to upload all assignment files to this folder.
   
8. Drag and drop all assignment files to upload into this folder.
9. In your browser, go to http://303.itpwebdev.com/~yourusername/assignment11/ to check that the assignment file has been uploaded correctly.
10. One last thing. In your computer, open up student_page.html that you created in Lab 2. Add a link to this assignment to student_page.html under the heading “Assignments” so that the graders can easily access your completed assignment.
11. Re-upload the updated student_page.html to the itpwebdev server via cPanel -> Files -> File Manager. If it asks you want to overwrite the previous file, click Yes.
12. If all the above is completed, go to your student page at http://303.itpwebdev.com/~yourusername/student_page.html and check that the link to this assignment is there. The TAs/graders use this link to access your assignment so make sure this is working! Below is a screenshot sample of what it should look like.
    
13. (Optional) If you are having trouble uploading to the server and cannot upload on time, add all files for this assignment in a folder, compress it as a .zip file and upload it to Blackboard. On Blackboard, go to Assignments -> Assignment 11: Final Project Front-end. You will get some points deducted for not uploading correctly but at least you will not get a zero.

To-do for today’s class

• Download starter file: lect20-membership-sessions/
• Log in to your cPanel and go to phpMyAdmin.

Slides

Link to download PDF version.

Helpful Readings

• Difference Between Hashing a Password and Encrypting it (StackOverflow)
• Adding Salt to Hashing: A Better Way to Store Passwords

Completed files

• 12pm: https://github.com/nayeonk/itp303-spring-2022-12pm/tree/master/lect20-user/
• 4pm: https://github.com/nayeonk/itp303-spring-2022-4pm/tree/master/lect20-user/

To-do for today’s class

• Save this Google Drive folder in the itp104 folder that you are saving all the lecture material in:
  https://drive.google.com/drive/folders/1PixTnHmHbvKXN8wjN57wvnIJmyE6u_xs?usp=sharing
  Click on the folder name -> Download to download a .zip file.
• Rellax Plugin – https://dixonandmoe.com/rellax/
• Lightbox Plugin – https://lokeshdhakar.com/projects/lightbox2/
• jQuery code – https://releases.jquery.com/
• Smooth Scrolling – https://mathiasbynens.be/demo/smooth-scrolling

Slides

View Slides
Link to download PDF version.

Completed Files

Completed files are stored in a GitHub repository. Links below will take you to a list of file(s) from today’s lecture. You can view the code via the browser through GitHub’s UI or clone/download the repo to open the code from your computer.

• https://github.com/nayeonk/itp104-spring-2022/tree/master/lect11-js-plugin

Overview

For this assignment, you will write up a proposal for your final project (PDF only, no .docx). Your final project needs to be a full-stack web application on any topic. While you need to design your own database, you may use data from different sources.

Requirements

1. Write up all the below requirements in a document (Word, Google doc, etc). You will need to export a PDF named final_project_proposal.pdf when you are done.
2. Read over the Final Project requirements and think about what web application you want to build for the final project.
3. Topic: discuss what your website is about in 1-2 sentences.
4. Audience: In 1-2 sentences, describe who the intended audience is for this application.
5. Design & Style:
   1. Discuss design and color scheme in 2-3 sentences.
      1. Don’t know where to start? Coolors.co is a great tool to help you generate color schemes.
      2. Design inspiration: dribbble.com, codepen.io, awwwards.com
   2. Provide links to 3 websites that inspired your design.
6. Scope:
   1. How many pages are you planning to have?
      1. What are the pages?
   2. If it is a single page website, how many sections are you planning to have?
      1. What are the sections?
7. Database:
   1. What data will be stored in the database?
   2. Where is data coming from?
8. Database Diagram:
   1. Design the database you will use for this project and create a database diagram using MySQL Workbench.
   2. You do not need to insert any records. Just the schema is sufficient.
   3. Include the database diagram of your database (image).
9. Wireframes (minimum of 4 wireframes total):
   1. Include wireframes of what the home page and one other major page of your web application will look like .
      1. You must include at minimum, one mobile version and one desktop version of each page (2 wireframes per page, 4 wireframes total).
   2. These wireframes can be hand-drawn or created digitally using a graphics tool like Figma (free), Sketch, or Adobe Photoshop. You can also use wireframe tools like Whimsical (free version available), Balsamiq or Omnigraffle.
   3. These wireframes do not need to have a ton of detail (placeholders are fine), but should still give you a good idea what the application will end up looking like. Wireframes that look like any of the three samples below are acceptable.
      1. Sample 1 – Hand-drawn
      2. Sample 2 – Wireframe created by Balsamiq
      3. Sample 3 – Wireframe created by Whimsical
   4. Of course, if you want to add more detail like colors, real images/text, etc, you are welcome to do so!
   5. Insert these wireframes to the document as well.
10. This proposal is not set in stone. You may change any aspect of your final project at any time. However, spending a big chunk of time thinking through the final project now rather than later is a wise idea. Don’t treat this assignment trivially.
11. Submission:
    1. Export this document as a PDF file (name it final_project_proposal.pdf).
    2. Login to cPanel -> Files -> File Manager.
    3. Create a folder (aka directory) named assignment10 and upload the PDF to this folder.
    4. Open up your student_page.html in the public_html folder and add a link to this PDF file.
    5. Re-upload the modified student_page.html to the itpwebdev server.

How to Delete

In class today we ran out of time to cover “delete.” Watch this video to learn how to implement the delete function: https://youtu.be/yN5twjglrHs

To-do for today’s class

• Download starter file: lect19-update-delete/ (Google Drive)
• Refer to song database diagram:
  

  

Helpful Readings

• Prepared Statements (php.net)
• PHP MySQLi Prepared Statements Tutorial (Website Beaver)

Slides

Link to download PDF version.

Completed files

• 12pm: https://github.com/nayeonk/itp303-spring-2022-12pm/tree/master/lect19-update-delete/
• 4pm: https://github.com/nayeonk/itp303-spring-2022-4pm/tree/master/lect19-update-delete/