Shelby Data Driven Web Page

Shelby Simmons Data Driven Web Page

Week 1

Week 2

WK2HW2
  1. I have a page with 3 headers with the titles Topics, Languages, and Problems. Topics has 26 items, Languages has 4 items, and Problems has 49 items.
  2. Honestly I somehow completely forgot to connect my newly made account with the database.
  3. I'm pretty sure I got it right but I might have missed something.

Week 3

Week 4

Week 5

  1. I did have issues, I think its because I don't have a set up for my login, logout, and register pages as it seems to be trying to take the session username for this code. I think that plus that pscodes doesn't have anything in the database.
  2. I could see myself possibly adding something like this to my project if I was to add a brief description of the organization to the database.

I'm getting an error and I'm not sure if its my code or if its because I don't have a username in this session because I don't have login, logout, or register pages.

  1. Preferrably I'd like to have a common topic interest with my group so I would like to see what they would like first. If I had to choose for myself it would be something video game related (I think).
  2. I think it would depend on how large the project is to balance out the team work. I think I would like having a group of 4 or 5 to balance out the possibility of a team member not being communicative.

Week 7

Week 7 Lab:

  1. One problem with limit clause is that PDO handles parameters as strings.
  2. Emulation mode must be turned off, otherwise it is on by default.
  3. The following code: '$conn->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );' can be used to turn emulation mode off.
  4. Instead of turning emulation mode off one can bind limits with a set param type.

Week 8

Week 8 Lab:

  1. Depending on the website PDFs can be very useful. For example when filing your taxes and let's say you have to mail them in, having the website input your data from a form and then copying all the input data into your tax sheets as a PDF file for print allows the IRS to quickly review your tax information. Another example could be going on a road trip and needing to print off directions from Google in the chance of losing cell service. Or needing to print off personal medication information from a healthcare website for a doctor's visit.
  2. I would say a challenge for maintaining PDF files on your website would be data changes and correct file referencing.

Week 9

Week 10

Week 11

Week 12

Week 12 Lab:

Week12Lab2 Week12Lab1

Week 13

Week 13 Lab:

  1. I can't think of anything missing specifically in this project we've been working on.
  2. I'm pretty sure I'm missing something but the only thing I could see as a security hole is how the hash is made. All the characters are the same for each user hash which could then me traced to an unhashed password given time. I think the username being hashed into the password also makes it easier to track by finding the password itself and removing the hashed characters.
  3. I would add the ability to see how long I had been logged in for while logging out. I think it'd be interesting to track a recorded amount of time while browsing a web application.

Week 13 Homework:

I regret to say I haven't done a lot on my projects so far. For this individual project I have added the chpwd.php, verify.php, and uname.php pages. I have then created a new email for user verification for this specific project. I also went in and altered my orgs database to match the registration process needed for these new tables. I edited my cfd (needed heavily for the myHash to work), and altered a couple of pages.


I plan to add subfolders for better organization seperating the registration files from the data display files. I need to fix the presentation of my login page. I need to fix some of the directional links when logging in and registering. I want to round some of the edges of the borders I used in display. I have a possible new idea for adding a visual display on each page to make the page visibly nicer. I plan on updating my ERD and documentation towards the end of my project to ensure I haven't missed any tables or pages.

Week 14

Week 14 Lab:

I think it is very important to learn PHP first instead of just PDO. When I had some issues with PDO anytime I looked up a way to code a specific thing or fix an error, I'd find PHP advice for what I wanted but not the PDO way. It made it easier to understand that "okay this is the regular PHP way so we've learned that it converts to this with PDO" and so on, if that makes any sense. I will say that I had some issues here and there because I got some things mixed up (mysql_query's get me all the time), but I feel like PHP is a lot more user friendly at least with how the code appears less intimidating at first glance. So I definitely think it was worthwhile learning without PDO first.

Week 14 HW:

I made some mistakes on my project this week while converting some of the pages to PDO so I have to go back and find why a lot of my pages aren't loading. I kind of got frustrated on what this issue was so I started working more on my Advanced Topics project 1 to cool off from the frustration and haven't gotten back to it since. I will absolutely reach out if I'm still having issues when I get back to it.

Week 15

Week 16