PHP and MySQL

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.

g

Suitable for All Levels

3 Day Course

Certification Awarded

i

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

 

 

Looking for a course for yourself? Please visit our site for individuals: MyTraining.iact.ie

Contact us.

Telephone.

+353 1 4347600.

email.

business@iact.ie

 

Business Enquiry Form

  • This field is for validation purposes and should be left unchanged.