Course Overview

Learning Outcome

Upon successful completion of Programming with PHP and MYSQL course, students will be able to:

• Understand how server-side programming works on the web.
• PHP Basic syntax for variable types and calculations.
• Creating conditional structures and Storing data in arrays
• Using PHP built-in functions and creating custom functions
• Understanding POST and GET in form submission.
• Read and process data in a MySQL database.
• Secure your connections to the MySQL server
• Guard against SQL injection
• Investigate and handle errors and warnings
• Create database-driven web applications and Enable fast text search
• Modify table data and Use temporal and numeric functions in expressions
• Use NoSQL and JSON document stores

Create MySQL client programs using Connectors

Prerequisite

• Must have good knowledge of Basic HTML and JavaScript

Course Content

• Introduction to PHP
• Basic PHP Development
• Control Structures
• Functions and Arrays
• Working with the File System
• Working with Forms
• Working with Regular Expressions
• Classes and Objects
• Introduction to Database
• Cookies and Sessions
• Disk Access, I/O, Math and Mail
• Introduction to MySQL
• Connectors and APIs
• Using Connectors
• Prepared Statements
• Handling Errors and Warnings
• Building Database-Driven Web Applications
• Tables and Views
• Working with Strings
• Working with Numeric and Temporal Data
• Subqueries
• Modifying Table Data
• Transactions
• Query Optimization
• Stored Routines