|Student Learning Outcomes -|
- The student will be able to download, install, configure and test the MySQL system on a local operating system.
- The student will be able to write web pages that have PHP scripts embedded for access to MySQL databases.
|Description - |
|Course Objectives - |
|The student will be able to: |
- Manage MySQL databases using the phpMyAdmin web interface
- Create Web forms and pages that properly use HTTP GET and POST protocol as appropriate.
- Develop applications with a programming language PHP that interact with MySQL Database
- Design SQL language within MySQL and PHP to access and manipulate databases.
- Create PHP code that utilizes the commonly used API library functions built in to PHP
- Demonstrate use of cookie, session, and authentication programming in PHP.
- Design and create a complete web site that demonstrates PHP/MySQL client/server design.
|Special Facilities and/or Equipment - |
- Access to MySQL and PHP.
- A website or course management system with an assignment posting component (through which all lab assignments are to be submitted) and a forum component where students can discuss course material and receive help from the instructor). This applies to all sections, including on-campus (i.e., face-to-face) offerings.
- When taught via Foothill Global Access on the Internet, through which the instructor and students can interact.
- When taught via Foothill Global Access on the Internet, students must have currently existing e-mail accounts and ongoing access to computers with internet capabilities.
|Course Content (Body of knowledge) - |
- Connecting to MySQL using a client such as phpMyAdmin or MySQL Workbench
- Creating Tables for a web application
- Basic SQL Queries for a web application
- Description, data requirements and transaction requirements for the MySQL database.
- Overview of PHP
- Control Structures
- Embedded PHP in HTML5
- Strings and Regular Expressions in PHP
- Object-oriented PHP
- Introduction to objects
- Using objects
- Utilizing the commonly used API library objects and functions built in to PHP
- Database Design Considerations for Web Applications
- Table structure
- Foreign and Primary Keys
- Database Access From PHP Web Pages:
- Connecting to a Database using PHP
- Creating Web forms and pages that properly use HTTP GET and POST protocol as appropriate.
- Authentication with PHP and MySQL
- PHP Sessions
- Cookies and sessions
- Authentication programming in PHP
- Fundamentals of security, securing information
|Methods of Evaluation - |
- Exams and quizzes
- PHP and MySQL programming assignments
- Team project to design and implement a database-driven web application for a real-world scenario
|Representative Text(s) - |
|Yank, Kevin, PHP & MySQL: Novice to Ninja. Edition: 5th. Publisher: Sitepoint. Year: 2012. ISBN: 0987153080 |
Murach, Joel & Harris, Ray. PHP and MySQL. Edition: 1st. Publisher: Murach. Year: 2010. ISBN: 978-1-890774-56-1.
|Disciplines - |
|Computer Science |
|Method of Instruction - |
- On-line labs (including sections meeting face-to-face/on campus) consisting of:
- An assignment web-page located on a college-hosted course management system or other department-approved Internet environment. Here, the students will review the specification of each assignment and submit their completed lab work.
- A discussion webpage located on a college hosted course management system or other department-approved Internet environment. Here, students can request assistance from the instructor and interact publically with other class members.
- Detailed review of assignment that includes model solutions and specific comments on the student submissions.
- In person or on-line discussion, which engages students and instructor in an ongoing dialog, pertaining to all aspects of database-driven web application development.
- When course is taught fully on-line:
- Instructor-authored lecture materials, handouts, syllabus, assignments, tests, and other relevant course material will be delivered through a college hosted course management system or other department-approved Internet environment.
|Lab Content - |
- Use MySQL to create and populate a database.
- Use PHP to connect a web page to the database.
- Use PHP to query the database with SQL statements submitted to the database.
- Use PHP to insert, delete and modify data using SQL statements submitted to the database.
- Implement login capabilities for webpages that insert, add or modify data in the database.
- Use strings and regular expressions in PHP to improve the data quality for the database.
- Implement the database-driven web application that includes:
- Fabricating data for the database.
- Create a website with multiple pages that draw dynamic data from the database as a response to queries.
- Create one or more pages to insert, delete and/or modify data in the database through the website.
- Implement security for the database-driven website.
|Types and/or Examples of Required Reading, Writing and Outside of Class Assignments - |
- Textbook assigned reading averaging 30 pages per week.
- Reading on-line resources as directed by instructor though links pertinent to databases.
- Reading library and reference material directed by instructor through course handouts.
- Writing Technical prose documentation, that supports and describes the database-driven web application assignments that are submitted for grades. The document would include the following aspects of the database application.
- A description of the web application including functional and data requirements.
- A description of the database including data type, valid data ranges, constraints and keys.
- A help page for users of the web application. This may be an FAQ or user manual style help page.