PHP/MySQL
Course Overview: The PHP/MySQL course provides a comprehensive introduction to server-side scripting using the PHP language, and its use with MySQL databases.
By the end of the course, you will be able to perform essential web development tasks using PHP and MySQL.
Pre-requisite knowledge: Basic HTML and programming
Related Job roles: Programmer, Web Designer, Web Developer
Course Duration: 6 weeks (weekends) or 4 weeks (evenings)
Price: £540
Course Contents:
PHP Fundamentals:
- Syntax
- Data Types
- Variables and Scope
- Operators
- 'if' statements and loops
Storing and Retrieving Data:
- File Manipulation
- Writing to a file
- Reading from a file
- File locking
Using Arrays:
- Creating arrays
- Using arrays with loops
- Associative arrays
- Array manipulation
- Accessing form variables
String Manipulation:
- Trimming and case-conversion
- Magic quotes
- Joining and splitting strings
- String Comparison
- Substrings
Code Re-use and Functions::
- The include() function
- Calling functions
- Function declaration and definition
MySQL Essentials:
- Designing a Database
- Creating a Database
- Data manipulation: inserting, retrieving, updating and deleting
Accessing MySQL with PHP:
- Connecting to a database
- Querying a database
- Presenting the results
- Authentication
Beyond the Basics:
- Interacting with the File system and the Server
- Session Control
- Security
