PHP 5 and MySQL
Training
In Enfield
Description
-
Type
Training
-
Location
Enfield
-
Duration
1 Day
This course is designed to enable web developers and others with limited programming experience to build dynamic web sites using the PHP programming language with a MySQL database. Since PHP is such a rich and task-specific language, the course covers the most important range of functions in depth, and equips delegates to understand all the essential aspects. Suitable for: Designers who want to advance their skills and develop data driven web sites. Developers that want to get to grips with php programming language and mysql databases.
Facilities
Location
Start date
Start date
About this course
Experience of programming in any other type of language, i.e.HTML, Java, Javascript, C/C++, VisualBasic, etc
Reviews
Teachers and trainers (1)
P Rae
Trainer
Course programme
PHP 5 and MySQL
Course Features:
Introduction to PHP
- PHP tools and set up
- Creating a basic PHP script
- Server variables
Variables and Expressions in PHP
- Identifiers (names for variables)
- Data types (integers, floats,strings)
- Creating variables
- Variable assignment and scope
- Constants
Operators
- Arithmetic, Logical and Relational Operators
- Assignment Operators
Conditional Tests and Events
- If and else statement
- The switch statement
Flow Control
- The for loop
- The while loop
- The do… while loop
- break and continue statements
Storing & retrieving data with Arrays
- What are arrays?
- How and when to use arrays
- Indexed and Associative arrays
- Multi-dimensional arrays
- Loops with arrays
- Predefined arrays
PHP Functions
- What are functions?
- Built-in functions
- Declaring functions
- Functions and arguments
- The return keyword
- Global and local scope
- Variable function calls
Working with Strings
- Prebuilt string functions
- Regular Expressions
- Escaping strings
- echo vs print
- printf and sprintf
Dates and Times
- The date() function
- The getdate() function
- The mktime() function
- Using timestamps
Session Management
- What is a session?
- Understanding session variables
Using Cookies with PHP
- Cookie properties
- Setting and retrieving cookies
- Expiring/Deleting cookies
File and Directory Access
- Include and require
- Opening, reading and writing files
Handling Databases with PHP
- PHP's database APIs
- Error-handling strategies
- Connection/disconnection
- Common access functions
- Simple SQL queries
Objects in PHP
- Understanding Objects
- The Class Definition
- Class Inheritance
- Constructors and destructors
- __toString method
- Getter and Setter functions
- Accessing instance data and methods
Workshop
Creating a simple web application
Additional information
PHP 5 and MySQL