Prof Patrick J Wasson, MS

Uncategorized

Week 10 Update

Hi Class,

To recap we covered PHP function and wrapped up PDO.

For next week 1) Review Exercise PDO 3 and Challenge 4.1 2) Read the assigned Murach pages 3) Complete Challenge 4.2 4) Ensure you can configure debugging on your pc

Next week we will review the Challenge 4.2 solution and review for Exam 2.  Please be sure to bring any questions you have about Exam 2 to class, so we can cover them.  This class will be your time to go over anything that you would like further explanation on in regards to Exam 2.

I have posted a preliminary MIS3501-Exam-2-Study-Guide for your review.

Exam 2 will be on 4/5/17.

Have a great week.

Pat

Update to Schedule – Exam 2 Will be on 4/5/17

Hi Class,

I hope everyone had a great Spring Break!

I have made some changes to the schedule to help us balance out the remaining topics for the semester and ensure everyone can do as well as possible on Exam 2.

Exam 2 will be held on 4/5/17.

Please see the course schedule on our website for more information about what we will cover each week for the remainder of the semester.

Thanks,

Pat

MySQL Quiz Grades Posted

Hi Class,

I have posted the results from the MySQL quiz to the grade book.  The class average for the quiz was a 78%.  The grade posted is out of 33 points, so divide the points posted by 33 to get your percentage grade.  In addition, I have posted your current course grades given both quizzes and exam 1.

As a reminder: The last day to withdraw from the class is 3/22/17.  Please contact me before 3/22/17 if you have any questions.

Pat

Enable Debugging in Apache

  1. Go to: http://xdebug.org/files/php_xdebug-2.5.1-7.1-vc14.dll and download the .dll file
  2. Rename the file: php_xdebug.dll
  3. Copy the file to: C:\xampp\php\ext\
  4. Open the XAMPP Control Panel->Click the Apache Config button->Select php.ini file
  5. Add the following code to the bottom the file and save.
[XDebug]
zend_extension = "C:\xampp\php\ext\php_xdebug.dll"
xdebug.remote_enable=1
xdebug.remote_handler=dbgp
xdebug.remote_host=127.0.0.1
xdebug.remote_port=9000
xdebug.remote_autostart=0
xdebug.remote_connect_back=0
xdebug.profiler_enable=0
xdebug.profiler_enable_trigger=0
xdebug.profiler_output_name=cachegrind.out.%s.%t
xdebug.profiler_output_dir="C:/Temp/xdebug"
xdebug.trace_output_dir="C:/Temp/xdebug"

6. Stop and Start the Apache service in the XAMPP control panel

Week 8 Update

Hi Class,

To recap: Last night we covered PDO, which involved writing PHP that both inserted, updated, deleted and selected data stored in a MySQL database.  I have posted solutions to all of the exercises and challenges we covered.

Next week will be Spring Break!  We will not have class on 3/15/17.

For 3/22/17: 1) Read the Murach assigned pages 2) Practice everything we covered with PDO 3) Attempt challenge 4.2 4) Take a look at the Debugging post above and see if you can enable debugging on your own pc.  Once you have debugging enabled you can test it out in netbeans.  Please see the following tutorial: https://netbeans.org/kb/docs/php/debugging.html

I will have your MySQL quiz grades posted early next week.

As a reminder: The last day to withdraw from the class is 3/22/17.  Please contact me before 3/22/17 if you have any questions.

Have a great spring break and see you all on 3/22!

Pat

Week 7 Update

Hi Class,

To recap: Last night we took the MySQL quiz and reviewed the solution to Exam 1.  Grades up to this point have been posted.

Next week we will cover connecting our PHP code to a MySQL database using PDO.

To prepare for next week: 1) Read the assigned pages in Murach 2) Complete Challenge 4.1 3) Take a look at the exercises we will cover next week

If you have any questions please let me know!

Have a great week!

Pat

Week 6 Update

Hi Class,

To recap: last night we covered MySQL, interpreting an ERD, and writing SQL queries based on an ERD.  We also went through a number of exercises writing SQL queries.

Next week we will have the MySQL quiz, which will require you to write numerous SQL queries based on a database schema diagram I provide.  The format will be very similar to the exercises in that I will provide you with a starter .sql file which you will need to import into phpmyadmin.  You will then be asked to write a number of SQL queries using the ERD as a guide.  At the end of the exam you will then e-mail me the file containing your SQL queries.  To practice be sure to go through all of the readings, videos and exercises.  There may be some questions that ask for functions that we may not have directly covered in the exercises (Some examples could include: substr, like, datediff, str_to_date etc…), but you will be expected to perform with a working foundation knowledge of MySQL queries.

After the quiz we will will review the results and go over the solution for Exam 1.

Have a great week

Pat

Week 5 Update

Hi Class,

To recap: Last night we took Exam 1, reviewed the HTML quiz and began on the MySQL Presentation.  I have posted your HTML quiz grades.  We will review Exam 1 and I will have your grades back to you on 3/1/17.

For next week: 1) Go through the MySQL Training videos posted in the syllabus 2) Ensure you can access http://www.mis3501.xyz/phpmyadmin/index.php using the credentials provided in the gradebook 3) Take a look at the exercises we will be covering next week

As a reminder: the MySQL Quiz will be on 3/1/17.

Have a great week!

Pat

Exam 1 Prep Exercise

Hi Class,

I am posting an Exam 1 Prep Exercise that will help you practice for the exam next week.  Please download the following files and read the instructions in the pdf file.  You will set up your starter code just like you will in the exam.  I have then attached the solution code so you can compare your work.

MIS 3501 Exam 1 Preparation

Exam1Prep

Exam1PrepSolution

Note: I was informed that there is no review session held by the ITA for MIS3501 for Exam 1.

 

Pat

Exercise 2.4 Video Walkthrough

Hi Class,

I am posting a video walk-through of exercise 2.4 created by my colleague Jeremy Shafer.  Please use it as a supplement to the portions of exercise 2.4 that we covered in class.

Exercise 2.4

MIS3501 – Leap Year Calculator

Part 1 – https://youtu.be/-ZI5PdeGpuY (8 minutes)
Part 2 – https://youtu.be/MKyb85dH3pU (6 minutes)
Part 3 – https://youtu.be/Sn-zDqwuzsA (18 minutes)
Part 4 – https://youtu.be/UQZUWY_Kb3Q (15 minutes)

 

Pat