44b9a1cb583381a8461e26c5de66c7456a1e8337 Public Databases Repo
Updated: 3/5/18
<<<<<<< HEAD Started work on the HTML/PHP front end and finishing up the final touches on the db_setup.sql. Still need to figure out the order/orderitems and products tables so that they all link up correctly so that orders can reference the products table and not the different types of product tables individually.
Also need to take the 210 code and get it all tied up nicely to work with the new MySQL database and fix the queries to prepared statements.
3/7/18
Changed the entire database schema to simplify things. By doing this I will have to forego lots of the detailed specifics of the different products and use the same attributes (color, weight, etc.) for each one. I might change this later but we will see.
Started work on the HTML/PHP front end and finishing up the final touches on the db_setup.sql. Still need to figure out the order/orderitems and products tables so that they all link up correctly so that orders can reference the products table and not the different types of product tables individually.
Also need to take the 210 code and get it all tied up nicely to work with the new MySQL database and fix the queries to prepared statements.
3/7/18
Changed the entire database schema to simplify things. By doing this I will have to forego lots of the detailed specifics of the different products and use the same attributes (color, weight, etc.) for each one. I might change this later but we will see.
44b9a1cb583381a8461e26c5de66c7456a1e8337
3/10/18
Finished up the php scripts for insertion, deletion, and update of database table entries. Now the admin has the ability to add, delete, and update different customers and products in the database. I also chagned all of the SQL statements to prepared statements for a security measure and practice in using prepared SQL statements in PHP.