Working some PHP & mySQL magic here. :)

Claire’s accomplishments from this week.

  • Built a mySQL database in two ways (1. Using mySQL’s built-in command line, 2. Through a PHP function stored inside a variable)
  • Connected PHP input to the mySQL database, and wrote functions that would echo confirmation
  • Built a mySQL table and assigned the fields (whether it was primary key, null, etc.) through PHP exclusively
  • Created a front-end user-friendly UI for other employees in the company to use 🙂

Below is just test material. The real form is more detailed than this, but I just created a database that would accept “First Name”, “Last Name”, and “Age” as fields. So, office workers will never have to touch PHP code, or mySQL syntax to update the database, thanks to my front-end UI form! (´・ω・`)I’m feeling really proud. Or maybe its just that day-old scone I ate…..

mysqlphpscript

mysqlprogress

mysqlUI

Basic front-end UI for the other employees to use. This was just a test form, the real database will have document name, date of creation, directory, etc.