PHP Programming & MariaDB for Web Development [STA_PHPPMARWD]
Starting dates and places
placeLive Virtual 22 Apr 2024 until 26 Apr 2024 |
placeLive Virtual 3 Jun 2024 until 7 Jun 2024 |
Description
OVERVIEW
PHP Programming & MariaDB for Web Development Course Overview
The PHP Programming & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MariaDB database system and HTML.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
OBJECTIVES
Course Objectives
On completion of the PHP Programming & 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.
AUDIENCE
Who will the Course Benefit?
UNIX and Windows Users,Web Developers and Programmers wishing to …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
OVERVIEW
PHP Programming & MariaDB for Web Development Course Overview
The PHP Programming & MariaDB for Web Development course is designed to give delegates the knowledge to develop/maintain PHP scripts utilizing the MariaDB database system and HTML.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
OBJECTIVES
Course Objectives
On completion of the PHP Programming & 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.
AUDIENCE
Who will the Course Benefit?
UNIX and Windows Users,Web Developers and Programmers wishing to create web based systems utilising PHP and MariaDB.
NEXT STEP
Further Learning
- Apache Web Server
- Perl Programming
- Python Programming 1
- Ruby Programming
- Ruby on Rails
CONTENT
PHP Programming & 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 LANGUAGE BASICS
- Programming Basics
- Comment markers
- PHP Tags
- Output Commands
- Using STDIN STDOUT and STDERR
- Using Files
- Include_path
- Opening files
- Reading files
- Writing to Files
- RTRIM
- Operators
- Assignment Operators
- Increment/Decrement Operators
- Arithmetic Operators
- String Operators
- Comparison Operators
- Logical Operators
Session 2: PHP VARIABLES AND ARRAYS
- Naming Rules
- Data Types
- Numerical
- Integer
- Floating Point Numbers
- Floating Point Precision
- Single Quoted Strings
- Double Quoted Strings
- Creating and Assigning Variables
- Assigning Values to Variables
- Type Conversion
- Super Globals
- Constants
- Variable Variables
- Creating/modifying indexed and associative arrays
- Multi-Dimensional arrays
- Using array functions
- Sorting an array
PHP Programming & MariaDB for Web Development Training Course
Course Contents - DAY 2
Session 3: CONTROL STRUCTURES
- Statement Blocks
- If Construct
- Else Keyword
- Elseif Keyword
- Switch
- Looping Constructs
- While Loop
- Do-while Loop
- For Loop
- Foreach Loop
- Loop Control Words
- Break
- Continue
Session 4: PHP FUNCTIONS
- Overview
- Variable Scoping
- Global Keyword
- Static Keyword
- Argument Passing by Value
- Argument Passing by Reference
- Returning Values
- Including External PHP Functions
- Conditionally Created Functions
- Functions Created Inside Functions
Session 5: REGULAR EXPRESSIONS
- Meta-Characters
- Sequences
- Sets
- Pattern Matching with ereg and eregi
- Pattern Matching with preg_match
- Splitting Text - preg_split
- Replacing Text - preg_replace
PHP Programming & MariaDB for Web Development Training Course
Course Contents - DAY 3
Session 6: PHP OBJECT ORIENTED
- PHP Object Orientated Concepts
- Creating Classes and Objects
- Constructor and Destructor functions
- Inheritance
- Access Modifiers
Session 7: PHP & PEAR
- What is PEAR?
- Command Line Package Installer
- Fully-Automatic Installation
- Semi-Automatic Installation
- What is PECL?
Session 8: PHP & HTML
- HTML/PHP Examples
PHP Programming & MariaDB for Web Development Training Course
Course Contents - DAY 4
Session 9: PHP CONFIGURATION
- Working with External Files
- Error Reporting
- Interacting with External Programs
Session 10: BASIC SQL STATEMENTS
- Creating Databases and Tables
- Inserting Data into Tables
- Viewing Tables
- UPDATE
- Drop
Session 11: CONNECTING TO MariaDB/MySQL
- mysqli_connect
- mysqli_error
- Die
Session 12: USING PHP TO PERFORM DATABASE FUNCTIONS
- Inserting Data into a Database
- Creating Queries
- Executing Queries
- Processing the Returned Query Data
- Updating the Database
PHP Programming & MariaDB for Web Development Training Course
Course Contents - DAY 5
Session 13: GENERATING HTML USING PHP
- PHP Inside HTML
- HTML Form with Embedded PHP
- Multiple HTML Pages/Forms with PHP
Session 14: EMAIL AND COOKIES USING PHP
- Generating Email using PHP
- Generating Cookies using PHP
- Using Cookies
Session 15: PHP AND DATABASE SECURITY
- Designing Databases
- Connecting to Database
- Encrypted Storage Model
- SQL Injection
- Security Techniques
- Error Reporting
- User Submitted Data
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.