Course Description
Students will learn PHP and MySQL tools and techniques. The course includes hands-on experience in Web application development using PHP to implement security, networks and protocol functions, authentication, personalization, image generation, debugging and logging. Students will learn proper coding techniques and become adept in developing websites using PHP while integrating them with internet databases.
Prerequisite(s)
ITSM 1113 or consent of instructor. -- Must be completed prior to taking this course.
At the end of this course, students will be able to:
- Combine front-end and back-end website development techniques.
- Apply language features like functional composition, prototypal inheritance, closures, event delegation, scope, and higher-order functions.
- Implement logic, database interactions, user authentication, and server configuration.
- Develop web storage for sessions, cookies, and cached data in a browser.
- Utilize best practices for designing and building large/complex web applications.
- Implement effective code structure, file organization, media file hosting, database structure, and client-side vs server-side computations.
General Education Distribution Area
AAS Business Elective
Topical Outline
Part I: Using PHP
- PHP Crash Course
- Storing and Retrieving Data
- Using Arrays
- String Manipulation and Regular Expressions
- Reusing Code and Writing Functions
- Object-Oriented PHP
- Error and Exception Handling
Part II: Using MySQL
- Designing Your Web Database
- Creating Your Web Database
- Working with Your MySQL Database
- Accessing Your MySQL Database from the Web with PHP
- Advanced MySQL Administration
- Advanced MySQL Programming
Part III: Web Application Security
- Web Application Security Risks
- Building a Secure Web Application
- Implementing Authentication Methods with PHP
Part IV: Advanced PHP Techniques
- Interacting with the File System and the Server
- Using Network and Protocol Functions
- Managing the Date and Time
- Internationalization and Localization
- Generating Images
- Using Session Control in PHP
- Integrating JavaScript and PHP
- Other Useful Features