Posted on Leave a comment

Learning Reflection Journal Post #8

This is the minimum requirement for each weekly entry for the first half of class:

A quick summary of the topics learned for the week.

write a PHP script that will connect to a MySQL database
create a SQL query to retrieve information from a table
create a SQL query to insert data into a table
write PHP code that outputs query results to a web page

Links to your lab and homework assignments with a reflection on the process.

https://devjamie.com/COSW30/webproject4/

This was challenging working with the database. Still having issues with adding from my site. The rest of it is functioning. Listing Departments as easy as it was the same as listing users but accessing another table. Things are starting to make some sense but not as I would like them to be and not keeping up with the class. Looking at the other student’s pages I see I can improve on a lot of things for my website.

Posted on Leave a comment

Learning Reflection Journal Post #7

Setting up an SQL database seems to be pretty straightforward with my classwork assignment besides the few quirks in my provider Hostinger. I did notice something that I had issues with on my sight and that was I could only seem to have only one user per database. Only admin accounts that wouldn’t work if I wanted a proper database. I looked up why this was so.

https://support.hostinger.com/en/articles/1583542-how-to-create-a-new-mysql-database

What it comes down to is that I need to have an additional service with my web hosting account. “Each database can only have one user. If you need multiple users, you can consider a VPS plan” is what I found on the page. So I guess I need to spend more per month for the ability to have a proper database.