Category: COSW 30

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.

Number Formatting and Random Number Generation. It feels like I’m not keeping up with the class. Maybe it is the format of the class where there are no meetings.

The learnings week 1 was one the was not new to me. The topics where very similar to the things I have done over the years with other languages but a different syntax. Here is the list of the learnings for the week.

• Understand the basics of static versus dynamic web pages 
• Setup a REPL.it account  to use as a beginning PHP language code editor.
• Practice writing some basic PHP statements embedded into HTML code using php, echo, and print.
• Write comments in PHP code.
• Create a variable in PHP and assign a value to it.
• Output a PHP variable to a webpage. 
• Work with string data types in PHP.
• Work with numeric data types in PHP.
• Work with CONSTANTS.
• Understand the difference between single and double quotation marks.
• Identify how to use escape sequences.

Dynamic versus static websites. Dynamic websites are can change and are adjustable with scripts and the information the database provides. Content management systems helps how the website pages are arranged. Static websites do load faster and quicker to create but once made they are not as flexible to new data.

Replit account I had already from my previous classes and not much there to discuss about what I have learned. I do have issues with the site with my browsers and this site and constantly have to log out and back in to make it work properly.

Practicing writing statements in PHP. Have did that with My first Lab Assignment and currently with my second lab Assignment. This very similar to other programing languages so these concepts are not new to me.

The single and double quotes took working out a few examples to see what the difference made.

$string = 'He said "What\'s up?"';
$string = "He said \"What's up?\"";

Still a newbie with this language but it should come to me.