This course will provide you with a comprehensive knowledge of PHP & MySQL and will allow you to develop data driven websites using the PHP & MySQL open source platform.
Suitable for All Levels
3 Day Course
Certification Awarded
Study materials
Learning options for this course
Classroom
This course can be taken at our Training Centre in Dublin 2. Socially distanced learning. Full interaction with expert trainers.
Virtual Classroom
Daytime or evenings using iLiveLearning. Full interaction with the trainer, just like in the classroom. Software provided.
Skills You will have at the end of the Course
Understand the PHP language
Manipulate web form data
Work with sessions
Understand how to use and exploit cookies
Build databases and work with MySQL
Build dynamic web pages
Populate web sites with data from MySQL
Access and work with open source resources
Course overview
PHP and MySQL have become the development platform of choice for many professional web designers. PHP and MySQL combine to create a simple yet powerful way to create dynamic web pages that actually interact with your visitors. PHP is widely supported and hosted on commercial websites without the need for expensive licences.
There is a wealth of free resources and support tools to help you fully exploit PHP and MySQL and take advantage of open source projects. The PHP language is intuitive to learn and supported on both Windows and Linux platforms. Users familiar with languages such as C, Java, Visual BASIC and JavaScript will find the transition to PHP intuitive.
MySQL is a powerful and scalable database. MySQL provides a real alternative to commercial databases such as Oracle and SQL. Server at a fraction of the usual costs
Requirements
Knowledge of HTML is required
Certification
At the end of the course, you’ll be an Certified by the Irish Academy of Computer Training
Who would benefit
Existing web designers that are familiar with XHTML coding techniques. It is assumed that Introductory programming experience is present.
Why take the Course
To be able to build and manipulate dynamic web pages using PHP and MySQL. To be able to setup a web database and use it in the construction of a dynamically built websites.
Course curriculum
What's covered
- Language Fundamentals
- Encapsulating PHP within XHTML
- Using scalar variables
- PHPs different operators
- Control Structures
- Arrays in PHP
- Variable Scope
- Using References
- Manipulating Form Data
- POST vs GET for form input
- Retrieving data from forms
- Hidden Fields
- Validating Input
- Returning results to the user
- Calling pages from themselves using forms
- Variables, Expressions & Functions
- Functions
- Identifiers and Data Types
- Accessing Environment Variables
- Cookies
- Setting and retrieving Cookies
- Drawbacks of Cookies
- Security implications of using Cookies
- An Introduction to MySQL
- Relational databases
- Different versions of MySQL
- Basic MySQL Management
- Database Interaction
- Storing data to a database
- File Management
- Working with files.
- Opening files. R
- Using file contents to populate web page
- Include/Require
- Array, date/time, filesystem and directory, mail, string
- Regular expressions functions
- Session variables
- Managing Sessions
- Registering session variables
- Putting sessions IDs in pages
- Creating a login system
- PHP sessions and databases
- Hiding PHP
- Encrypting Passwords
Contact us.
We'll reply quickly.
Enquiry
I understand that my personal data is being processed in accordance with the privacy notice and accept the terms and conditions of use.