Skip to main Content

PHP & MariaDB for Web Development

  • Course Code PHPMARWD
  • Duration 2 days

Course Delivery

Additional Payment Options

  • GTC 12 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Company Event Price

Please call

Request Group Training Add to Cart

Jump to:

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Download Course Details

Course Overview

Top

The PHP & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain HTML/PHP code that utilises the MariaDB Database system.

Company Events

These events can be delivered exclusively for your company at our locations or yours, specifically for your delegates and your needs. The Company Events can be tailored or standard course deliveries.

Course Schedule

Top

Contact us for dates

Request Group Training Dates in Other Countries

Target Audience

Top

UNIX and Windows Users,Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.

Show me more

Course Objectives

Top

On completion of the PHP & MariaDB for Web Development course the delegate will have a good practical knowledge of how to write successful HTML/PHP code utilising a MariaDB database.

Show me more

Course Content

Top

PHP & MariaDB for Web Development Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: PHP CONFIGURATION

  • Working with External Files
  • Error Reporting
  • Interacting with External Programs

Session 2: BASIC SQL STATEMENTS

  • Creating Databases and Tables
  • Inserting Data into Tables
  • Viewing Tables
  • UPDATE
  • Drop

Session 3: CONNECTING TO MariaDB/MySQL

  • mysqli_connect
  • mysqli_error
  • Die

Session 4: USING PHP TO PERFORM DATABASE FUNCTIONS

  • Inserting Data into a Database
  • Creating Queries
  • Executing Queries
  • Processing the Returned Query Data
  • Updating the Database

PHP & MariaDB for Web Development Training Course

Course Contents - DAY 2

Session 5: GENERATING HTML USING PHP

  • PHP Inside HTML
  • HTML Form with Embedded PHP
  • Multiple HTML Pages/Forms with PHP

Session 6: EMAIL AND COOKIES USING PHP

  • Generating Email using PHP
  • Generating Cookies using PHP
  • Using Cookies

Session 7: PHP AND DATABASE SECURITY

  • Designing Databases
  • Connecting to Database
  • Encrypted Storage Model
  • SQL Injection
  • Security Techniques
  • Error Reporting
  • User Submitted Data
Show me more

Follow on Courses

Top
  • Apache Web Server (APH)
  • Perl Programming (PERL)
  • Python Programming 1 (PYP1)
  • Ruby Programming (RUBYP)
  • Ruby on Rails (RUBYR)
Show me more

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

Please only use paragraphs and links in this rich text field. A link to page with cookie info

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

These are optional and you can turn them off and on. Please only use 2 to 3 lines of text here and if needed link to a page with more cookie info in Intro.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Cookie Control toggle icon