WEB306 - PHP: Databases, CMS and Framework

Outline info
Last revision date 2018-07-20 12:01:53.282
Last review date 2018-07-20 12:02:08.608

Subject Title
PHP: Databases, CMS and Framework

Subject Description
This course is designed to provide students with a solid foundation of PHP and MySQL and will allow them to create database driven websites. Topics include: installing and configuring PHP, MySQL and Apache, PHP basics, PHP with MySQL and usage of the Laravel framework.

Credit Status
1 Credit towards the Web Programming & Development R.O.A.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

  1. Set up a local development server for creating web sites and web applications
  2. Create basic scripts and programs using PHP
  3. Learn how to read and understand the PHP.net documentation
  4. Create databases and tables using MySQL
  5. Understand the basics of relational databases and how to query data using the MySQL language
  6. Create database driven websites using HTML / CSS and basic PHP code
  7. Understand the basics of MVC frameworks and how to use them
  8. Learn how to develop using CLI (Command Line Interfaces) with Gitbash
  9. Develop database driven web applications using the PHP framework Laravel
  10. Create web applications that can handle user accounts and passwords

Essential Employability Skills
Apply a systematic approach to solve problems.

Use a variety of thinking skills to anticipate and solve problems.

Manage the use of time and other resources to complete projects.

Take responsibility for one's own actions, decisions, and consequences.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at student.conduct@senecacollege.ca.

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

WDC100 or previous HTML/CSS experience

Topic Outline
Topic Outline
Introduction to the PHP language and the basics of scripting languages
Learn how to troubleshoot errors and use error reporting
Introduction to MySQL and databases
PHP driven websites with HTML / CSS / Bootstrap
Fundamentals of processing HTML form information and saving it into a database
Conceptual understanding of MVC frameworks
Basic of CLI (Command Line Interface) using Gitbash
Installing and using NodeJS and npm
Installing and using Composer
Installing the Laravel web framework
Connecting the Laravel framework with a standard MySQL database
Learn how to create database tables using Laravel migrations
Learn how to create Models and Controllers using Laravel
Learn how to create and design Views using Laravel Blade
Understand how to create Models that understand relational databases
Understand how user accounts are handled using Laravel

Mode of Instruction
Classroom instruction and extensive hands-on experience will be provided with each participant having exclusive use of a computer, reinforced by assigned reasearch and assignments between classes.

Prescribed Texts

Reference Material

Required Supplies

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online (http://www.senecacollege.ca/academic-policy) or at Seneca's Registrar's Offices.

Modes of Evaluation
This is a project oriented class. Grading will be based on two assigned, in-class projects.

Project 1 50%
Project 2 50%
Total 100%

Approved by: Sharon Estok