MIS3501-Data Centric Application Development

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

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

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

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

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

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

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

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

Hi Class,

Good work last night.  To recap: We covered For and While loops as well as a comprehensive review of what we have covered so far including forms, conditional logic, variables etc.  I have posted all of the solutions to the challenges and exercises we have covered so far.

Next week we will be taking Exam 1 which will cover everything we have covered so far in the class.  Please see the following MIS3501-Exam-1-Study-Guide, which contains everything that will be covered in Exam 1.  To prepare be sure you understand how to complete all of the challenges and exercises as they are very similar to what will be covered in Exam 1.

Please let me know if you have any questions at all about the Exam.

Pat

Hi Class,

Good work on the HTML quiz last night.  To recap: We took the HTML quiz and then began the PHP conditional statements presentations.  Because it took us a little longer to setup/wrap up the quiz I have recorded a Webex Presentation containing the remainder of the PHP conditional statements presentations, challenge 2.1 and exercise 2.2.  Please be sure to view the webex as it contains very important information which will be covered in the exam.

For next week: 1) Complete the Murach reading 2) View the week 3 webex 3) Complete challenge 2.2 and 2.3

Next week we will go over PHP Loops and Counters, review challenge 2.3 and 2.3 and complete exercise 2.3 and 2.4, and review for Exam 1.

I am targeting to have your HTML quiz grades posted by 2/15/17.  We will then review in-class.

Have a great week!!

Pat