Top
Email
Bottom
PHP 8 and MariaDB 10
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Download our latest
Android and iPhone apps ...
Click on whichever one of our Apps you are interested in

PHP 8 and MariaDB 10 course at a glance

Pages
870No of slides in the Manual
Exercises
23Total No of Exercises
Sections
38No of main topics, see index below
Public
NoPublic course in the UK and Ireland
On-Site
YesWe can come to your venue
Level
11 - Beginners
2 - Intermediate
3 - Advanced
Days
5Week days but we can put on weekend courses
Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
5 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
38
23
870
None
Essential CSS 3 Essential JavaScript
Contact us for the latest pricing

PHP 8 and MariaDB 10 Programming course
Exercise highlights

Joining tables in MariaDB
Connecting to MariaDB using PHP
Exporting data from MariaDB to a flat file
Looping Arrays in PHP

Index of PHP 8 and MariaDB 10 Programming training course

PHP 8
 
 

Section
Section Name
Page

One
PHP Introduction
2

 
- PHP: Hypertext Preprocessor
3

 
- Some of its main uses
4

Two
PHP Structure
5

 
- Basic Structure of PHP
6

 
- PHP Version etc
15

 
- Use of Echo
17

 
- Concatenating Echo
19

 
- Use of Echo with Escape Characters
21

 
- Use of Echo with Calculations
27

 
- Echo versus Print
30

 
- Use of Echo with HTML
32

 
- Commenting code in PHP
34

Three
Defining PHP Variables
37

 
- Introduction
38

 
- Defining PHP Variables
39

 
- Naming PHP Variables
40

 
- Declaring PHP Variables
43

 
- Flexibility of Datatypes
45

 
- Casting Datatypes
46

 
- Using gettype() with PHP Variables
50

 
- Using var_dump() with PHP Variables
52

 
- Using settype() with PHP Variables
53

 
- Using unset() with PHP Variables
55

 
- Using Heredoc
56

 
- Using Newdoc
58

 
- Using Define for Constants in PHP
59

Four
Manipulating Variables in PHP
61

 
- Introduction
62

 
- Mathematics
63

 
- Incrementing Values
67

 
- Prefix and Postfix
69

 
- Concatenation
72

 
- Exercise One
76

Five
Using PHP built in String Functions
81

 
- Introduction
82

 
- Miscellaneous String Functions
84

 
- Changing Case of Strings
89

 
- Substringing Strings
90

 
- Searching Strings
92

 
- Trimming Strings
100

 
- Nesting Functions
101

Six
Using PHP built in Number Functions
102

 
- Introduction
103

 
- Number Rounding
104

 
- Exercise Two
108

Seven
Introduction to PHP Arrays
111

 
- Introduction
112

 
- Numeric Arrays
114

 
- Populating Numeric Arrays
115

 
- Populating Numeric Arrays with range()
118

 
- Populating Numeric Arrays with array_pad()
120

 
- Populating Associative Arrays
123

 
- Using count() or sizeof()
129

 
- Using var_dump()
130

 
- Using print_r()
132

 
- Manually traversing Arrays
133

 
- Converting Arrays
135

 
- Using implode() and explode()
136

 
- Using unset()
138

 
- Multi-Dimensional Arrays
139

 
- Using var_dump() on multi-dimension arrays
142

 
- Using count() on multi-dimension arrays
145

 
- Three dimensional arrays
146

 
- Accessing Three Dimensional Arrays
148

 
- Alternative declaration of Arrays
149

 
- Exercise Three
150

Eight
Using Array Functions
156

 
- Introduction
157

 
- Using array_sum() / array_product()
158

 
- Sorting Arrays
159

 
- assort() and arsort()
165

 
- ksort() and krsort()
166

 
- array_multisort()
167

 
- array_reverse()
171

 
- array_flip()
172

 
- array_fill() and array_fill_keys()
173

 
- array_combine()
178

 
- array_intersect()
179

 
- array_diff()
180

 
- array_merge()
181

 
- array_unique()
182

 
- Exercise Four
183

Nine
Conditional PHP Statements
187

 
- Conditional tests
188

 
- Comparison Operators
189

 
- If statement structure
191

 
- Grouping processes in an 'If' statement
193

 
- Alternative processing
195

 
- Multiple 'If' statements
196

 
- Testing different datatypes
200

 
- Testing Strings
202

 
- Testing Booleans
206

 
- Testing for nulls
208

 
- Alternative Colon syntax
209

 
- Multiple Condition tests (and)
211

 
- Multiple Condition tests (or)
212

 
- Multiple Condition tests (xor)
213

 
- Nested If Conditions
214

 
- Ternary Operator
215

 
- Using PHP built in Functions for testing
218

 
- Exercise Five
220

Ten
Alternative Condition Testing
223

 
- Introduction to Switch
224

 
- Switch Syntax
225

 
- Using Break with Switch
227

 
- Using Default with Switch
229

 
- Using Switch with Colon Syntax
230

 
- Advanced Switch Testing
231

 
- Mixing If Conditions with Switch
234

 
- Introduction to Match
236

 
- Match Syntax
237

 
- Using Default with Match
239

 
- Advanced Match Testing
240

 
- Match with Functions
241

 
- Exercise Six
242

Eleven
Looping through values in PHP
244

 
- Introduction
245

 
- Foreach processing of Arrays
246

 
- Foreach processing with Colon syntax
250

 
- Multidimensional Arrays with Foreach
251

 
- While Loops
253

 
- While Loops with Colon Syntax
255

 
- Using Break to exit Loops
256

 
- Do .. While Loops
257

 
- Do .. While and While Loops with Arrays
259

 
- For Loops
260

 
- For Loops with Colon Syntax
262

 
- For Loops with empty expressions
263

 
- For Loops with more than one variable
265

 
- For Loops with Arrays
266

 
- Advanced Breaking of Loops
268

 
- Using Continue with Loops
275

 
- Exercise Seven
278

Twelve
Using Dates within PHP
282

 
- Introduction
283

 
- Creating String of Dates
284

 
- Converting Strings to Dates using strtotime()
285

 
- Limitation of using strtotime()
292

 
- Using Format Masks with date()
293

 
- Comparing Dates
295

 
- Adding to Dates
296

 
- Using mktime()
297

 
- Using getdate()
298

 
- Other Date Functions
299

 
- Exercise Eight
300

Thirteen
Regular Expressions using PCRE
302

 
- Introduction
303

 
- Testing for 'Contains' within a String
305

 
- Starts or Ends using Line Anchors
306

 
- Starts and Ends using Line Anchors (or)
308

 
- Using the Dot (Any Character)
309

 
- Using {Intervals}
311

 
- Using Character Lists []
313

 
- Using Character Lists to exclude matches
316

 
- Using Escape Sequences
317

 
- Using the Question Mark (Optional)
319

 
- Using the Plus sign (Mandatory)
321

 
- Using the Star sign (Optional)
322

 
- Backreferencing
323

 
- POSIX
325

 
- Using preg_replace()
327

 
- Using preg_replace() with arrays
329

 
- Using preg_filter()
331

 
- Using preg_replace_callback()
332

 
- Using preg_match()
333

 
- Preg_match() with PREG_OFFSET_CAPTURE
334

 
- Using preg_match_all()
335

 
- Using preg_grep()
337

 
- Using preg_last_error()
339

 
- Using preg_quote()
340

 
- Using preg_split()
341

 
- Using preg_split() with arrays
343

 
- Exercise Nine
344

Fourteen
PHP Functions
347

 
- Introduction
348

 
- Rudimentary Functions
349

 
- Function Positioning
351

 
- Passing Parameters to Functions
352

 
- Passing Multiple Parameters to Functions
354

 
- Defaulting Parameters in Functions
355

 
- Returning Values
356

 
- Returning Values in an Array
358

 
- The scope of Variables
359

 
- Global Variables
361

 
- Passing Arguments by Reference
362

 
- Dynamic Function Calls
363

 
- Calling Functions from other Functions
366

 
- Calling PHP Functions in other files
367

 
- Structure of the PHP file
368

 
- Calling the PHP file
369

 
- Calling the PHP file using include()
370

 
- Passing Parameters to another PHP file
373

 
- Exercise Ten
374

Fifteen
PHP Cookies
377

 
- Introduction
378

 
- Creating Cookies in PHP with setcookie()
379

 
- Setting the expiry date for Cookies
381

 
- Setting the path for Cookies
383

 
- Setting the domain/security for Cookies
384

 
- Reading Cookies with $_COOKIE
385

 
- Using Arrays with Cookies
387

Sixteen
PHP Sessions
388

 
- Introduction
389

 
- Creating Sessions
390

 
- Testing Sessions
391

 
- Using Arrays with Sessions
392

 
- Deleting Sessions
393

Seventeen
PHP Form Processor
394

 
- Introduction
395

 
- Anatomy of a HTML form
397

 
- Reading input using $_POST/$_GET
400

 
- Reading input using $_POST
401

 
- Reading input using $_GET
402

 
- $_GET versus $_POST
403

 
- Using $_REQUEST
404

 
- Using $_SERVER
405

 
- Preventing Invalid HTML in Forms
409

 
- Emailing in PHP
410

 
- Emailing HTML in PHP
412

 
- Emailing with attachments in PHP
414

 
- Exercise Eleven
415

Eighteen
PHP Errors
418

 
- Introduction
419

 
- Typical Errors
420

 
- Suppressing Errors
422

 
- $php_errormsg
425

 
- Using die to end the processing
427

 
- Using exit to end the processing
428

 
- Using isset() $php_errormsg
429

 
- Alternative way to use $php_errormsg
430

 
- Using error_reporting()
431

 
- Using error_reporting() report levels
434

 
- Custom error handling
436

 
- Raising Errors using trigger_error()
440

 
- Using error_log
442

 
- Using a centralised error handler
445

Nineteen
Exceptions
447

 
- Introduction
448

 
- Exception Syntax
449

 
- The 'try'
450

 
- The 'throw'
451

 
- The 'catch'
452

 
- Standard Exceptions
453

 
- Developer Defined Exceptions
456

 
- Processing the Exceptions
457

 
- Exception Methods
458

 
- set_exception_handler()
460

 
- Re-throwing Exceptions
462

 
- Finally
463

 
- Exercise Twelve
465

Twenty
PHP File I/O
467

 
- Introduction
468

 
- Using fopen()
469

 
- Access Modes
470

 
- Using fgets()
472

 
- Using fgetc()
475

 
- Using file()
476

 
- Using file_get_contents()
477

 
- Using fopen() with URLs
479

 
- Using fputs() / fwrite()
480

 
- Using file_put_contents()
482

 
- Working with Comma Separated Files (CSV)
485

 
- Using fgetcsv()
487

 
- Using fputcsv()
489

 
- Working with Binary Files
494

 
- Checking the Size of Bytes written
486

 
- Operating System Functions
495

 
- Using exec()
497

Twenty One
Creating HTML with PHP
499

 
- Introduction
500

 
- Why use PHP
501

 
- HTML example
502

 
- PHP simulating the HTML example
504

 
- Using PHP_EOL
508

 
- Using PHP to create dynamic HTML
509

 
- Using htmlspecialchars()
516

Twenty Two
PHP Object Orientated Programming
517

 
- Introduction
518

 
- Terminology
519

 
- Instances
520

 
- Extending Classes
522

 
- Using '$this'
524

 
- Private and Public Methods
526

 
- Creating new Classes
527

 
- Referencing via Variables
529

 
- Exercise Thirteen
530

MariaDB 10
 
 

Section
Section Name
Page

One
Introduction to MariaDB
2

 
- What is SQL used for ?
3

 
- Why use MariaDB with PHP ?
4

 
- Definition of a Database
5

 
- Using MariaDB with PHP
6

Two
Simple MariaDB Queries in PHP
8

 
- Introduction
9

 
- Show Tables
10

 
- Show Columns
14

 
- Describe
17

 
- Selecting Data from a Table
18

 
- Counting records in a Table
21

 
- Selecting Data from a Table
23

 
- Selecting Columns from a Table
24

 
- Selecting Literals from a Table
25

 
- Selecting Literals from Dual
26

 
- Exercise One
27

 
- Manipulation with Functions
29

 
- Concatenating Columns
33

 
- Performing Calculations
34

 
- Using Variables
35

 
- Using mysqli_fetch_array()
37

 
- Using Aliases
38

 
- Ordering Data
41

 
- Ordering more than One Column
43

 
- Manipulating Dates using date_add()
44

 
- Displaying Dates using date_format()
46

 
- Exercise Two
48

Three
MariaDB Errors
56

 
- Determining Errors in the SQL
57

 
- Using mysqli_errno() and mysqli_error()
58

Four
Limiting Data Selected with a Where Clause
59

 
- Limiting Data
60

 
- Different types of MariaDB Where Clauses
62

 
- Using Table Aliases
73

 
- Combining Where Clauses
75

 
- Different types of MariaDB Where Clauses
76

 
- Handling Nulls in Where Clauses
77

 
- Using Functions in Where Clauses
78

 
- Using PHP Variables in Where Clauses
80

 
- Exercise Three
81

Five
Aggregating Values
85

 
- Introduction
86

 
- Using Group By
88

 
- Using Having with Group By
90

 
- Using With Rollup to Total Grouping
91

 
- Using Distinct()
92

 
- Exercise Four
93

Six
Regular Expressions
96

 
- Introduction
97

 
- Testing for 'Contains' within a String
98

 
- Starts or Ends using Line Anchors
99

 
- Starts and Ends using Line Anchors (or)
100

 
- Using the Dot (Any Character)
101

 
- Using {Intervals}
102

 
- Using Character Lists []
104

 
- Using Character Lists to exclude matches
107

 
- POSIX
108

 
- Using the Question Mark (Optional)
110

 
- Using the Plus sign (Mandatory)
112

 
- Using the Star sign (Optional)
113

 
- Exercise Five
114

Seven
Joining Tables in a MariaDB Statement
116

 
- Introduction
117

 
- Linking Tables in an SQL Statement
118

 
- Theta style of SQL
123

 
- ANSI style of SQL
124

 
- Problems with Data matching
125

 
- Problems with Joining Tables in SQL
126

 
- Ansi SQL Standards (Natural Joins)
127

 
- Ansi SQL Standards (Cross Joins)
128

 
- Ansi SQL Standards (Joins/Using)
129

 
- Ansi SQL Standards (On)
130

 
- Ansi SQL Standards (Multiple On)
131

 
- Ansi SQL Standards (Left Outer Joins)
132

 
- Ansi SQL Standards (Right Outer Joins)
133

 
- Merging Tables
134

 
- Using Union to Merge Tables
135

 
- Using Union All to Merge Tables
136

 
- Using Intersect to Merge Tables
137

 
- Using Minus to Merge Tables
138

 
- Knowledge Check
139

 
- Knowledge Check - Union
140

 
- Union Syntax in MariaDB
141

 
- Knowledge Check - Union All
142

 
- Union All Syntax in MariaDB
143

 
- Knowledge Check - Intersect
144

 
- Intersect Syntax in MariaDB
145

 
- Knowledge Check - Minus
146

 
- Minus Syntax in MariaDB
147

 
- Using the Merge Syntax in MariaDB
148

 
- Exercise Six
149

Eight
Advanced MariaDB Query Techniques
154

 
- Using Limit
155

 
- Using If()
157

 
- Using Ifnull()
158

 
- Using Nullif
159

 
- Using Case Function
160

 
- Using Sub-queries
164

 
- Using Set to create variables
167

 
- Populating a Variable from a Query
168

 
- Exercise Seven
170

Nine
MariaDB Datatypes
173

 
- Introduction
174

 
- Numeric Datatypes (Integer)
175

 
- Numeric Datatypes (Decimal)
176

 
- String Text Datatypes
177

 
- String Blob Datatypes
178

 
- String List Datatypes
179

 
- Date Datatypes
180

Ten
Creating Database Objects
181

 
- Creating Tables
182

 
- Mandatory Columns
183

 
- Creation Syntax for Tables
184

 
- Column Creation
187

 
- AUTO_INCREMENT
189

 
- Last_insert_id
190

 
- Drop Table Syntax
191

 
- Temporary Tables
192

 
- Creating Indexes
194

 
- Primary Key Creation
197

 
- Unique Key Creation
200

 
- Foreign Key Creation
203

 
- On Delete / On Update
205

 
- Cascade
208

 
- Set Null
209

 
- NO ACTION
210

 
- RESTRICT
211

 
- SET DEFAULT
212

 
- Creating Views
213

 
- Renaming Views
216

 
- Dropping Views
217

 
- Exercise Eight
218

Eleven
Altering Elements
220

 
- Altering Tables
221

Twelve
Inserting and Altering Data
224

 
- Rules
225

 
- Syntax for Populating Tables
226

 
- Inserting using the Set syntax
232

 
- Multiple Inserts
233

 
- On Duplicate Key Update
234

 
- Using Replace for Inserting Records
235

 
- General Comments
238

 
- Updating Records Rules
239

 
- Updating Data
240

 
- Deleting Data
243

 
- Inserting Large Objects
245

 
- Views
247

Thirteen
Prepared Statements
251

 
- Introduction
252

 
- Preparing the Statement
253

 
- Removing Prepared Statements
254

 
- Using Parameters
255

 
- Using mysqli_prepare()
257

 
- Using mysqli_stmt_bind_param()
258

Fourteen
Committing Records
259

 
- DDL and DML
260

 
- mysqli_commit() and mysqli_rollback()
262

 
- What happens if disconnected ?
264

 
- Exercise Nine
265

Fifteen
Importing and Exporting in MariaDB
271

 
- Outfile
272

 
- Problems with Outfile
276

 
- Using Dumpfile
278

 
- Selecting into Variables
279

 
- Importing Data using Infile
280

 
- Ignoring Lines using Infile
282

 
- Using the Set command with Infile
283

 
- Using the Lines option with Infile
286

 
- Loading comma separated files
287

 
- Loading XML file
289

 
- Loading XML file using Ignore
291

 
- Loading XML file naming Columns
292

 
- Loading XML file using Set
293

Sixteen
Using XML with PHP
294

 
- Introduction
295

 
- Reading XML files with PHP with DOM
296

 
- Reading XML with getElementsByTagName()
304

 
- Looping with getElementsByTagName()
306

 
- Writing XML files with PHP
315

 
- Writing XML files with PHP Arrays
320

 
- Writing XML files with PHP from MariaDB
326

 
- Exercise Thirteen
331


Sections of PHP 8 / MariaDB 10

PHP 8

1
PHP Introduction

2
PHP Structure

3
Defining PHP Variables

4
Manipulating Variables in PHP

5
Using PHP built in String Functions

6
Using PHP built in Number Functions

7
Introduction to PHP Arrays

8
Using Array Functions

9
Conditional PHP Statements

10
Advanced Condition Testing

11
Looping through values in PHP

12
Using Dates within PHP

13
Regular Expressions using PCRE

14
PHP Functions

15
PHP Cookies

16
PHP Sessions

17
PHP Form Processor

18
PHP Errors

19
Exceptions

20
PHP File I/O

21
Creating HTML with PHP

22
PHP Object Orientated Programming

MariaDB 10

1
Introduction to MariaDB

2
Simple MariaDB Queries in PHP

3
MariaDB Errors

4
Limiting Data Selected with a Where Clause

5
Aggregating Values

6
Regular Expressions

7
Joining Tables in a MariaDB Statement

8
Advanced MariaDB Query Techniques

9
MariaDB Datatypes

10
Creating Database Objects

11
Altering Elements

12
Inserting and Altering Data

13
Prepared Statements

14
Committing Records

15
Importing and Exporting in MariaDB

16
Using XML with PHP


Synopsis for PHP 8 and MariaDB 10 Programming training course

Seer Computing is not geographically constrained, the world is our oyster, wherever our clients need us we will go to them, in the case of training courses we travel with all the equipment needed for the Delegates to have a machine each with individual comprehensive manuals as well. Our usual range is anywhere from Lands End to John O'Groats, Belfast to Cork and all points in between, in fact we have been known to visit Switzerland and Luxembourg to English speaking clients to give them the benefit of our

wisdom and knowledge

.

Think of us as nomadic Consultants ready to come to you rather than you going through the expense of hotel bookings, travel costs as well as overtime for your staff. All prices we quote are inclusive of any expenses we may incur, it’s a

one price solution

and even though the costs of fuel fluctuate we will not charge any more than the agreed price.

If you need further details, read the page regarding our

Public IT training courses

, it lists the locations and courses which we perform, they are a mere fraction of our available courses, so maybe contact our Training co-ordinators and let them prepare your quotations.

On the subject of the price, whether it's for Consultancy or for a Training Course, with the exception of the VAT charge (the rate of which is out of our control), our quotations are valid for 6 months following the day we email it to you. Another factor to bear in mind that the more days you book for Consultancy or the more delegates you book on a course the lower the average price will be. For example, four delegates on a course joined by a further four colleagues would mean the additional delegates are charged a third of the price of the original four.

This course combines PHP 8 and MariaDB 10

, the first three days concentrate on programming PHP, including standard techniques such as variables, looping, arrays and functions (as well as a lot more). The second part of the course deals with using PHP to communicate with the MariaDB database, programming techniques used in the previous three days will be used to create tables, populate them and extract the data from within them. This data can be used to populate websites as well as download the data into a flat file.

The course can be performed at your site, at a venue close to your offices or ours; the

PHP course available as a public course

is combined with the MySQL Database and is available all year round in various locations throughout the UK and Ireland.

Contact the Seer Computing Training Assistants and they will be delighted to help you with your requirements,

quotations are free

and are valid for 6 months after issue, changes in VAT an exception of course.

Request for detailsClick for the contact form for the PHP 8 and MariaDB 10 training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
Public
Yes
On-Site
Yes
Public Courses
Essential JavaScript
Days
4
Pages
660
Exercises
16
Sections
31
Public
Yes
On-Site
Yes
Public Courses
Essential CSS 3
Days
4
Pages
800
Exercises
15
Sections
30
Public
Yes
On-Site
Yes
Public Courses
Essential SQLite 3
Days
3
Pages
550
Exercises
12
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential MySQL 8
Days
4
Pages
533
Exercises
16
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential Python 3
Days
5
Pages
955
Exercises
17
Sections
41
Public
Yes
On-Site
Yes
Public Courses
Oracle Application Express 20
Days
0
Pages
0
Exercises
0
Sections
0
Public
Yes
On-Site
Yes
Public Courses
PHP 8 and MySQL 8
Days
5
Pages
870
Exercises
23
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 17 Programming with Eclipse 2021-12
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 17 Swing with Eclipse 2021-12
Days
5
Pages
756
Exercises
19
Sections
35
Public
Yes
On-Site
Yes
Click on the course name to see full details, left and right to view other courses