Advanced search form with PHP
Created by Sebastian Sulinski, Last Updated 23-Jun-2020, Language:English
Advanced search form with PHP
Learn how to code a set of reusable component to filter your records
Created by Sebastian Sulinski, Last Updated 23-Jun-2020, Language:English
What Will I Get ?
- How to make good use of the design patterns
- How to make design decisions
- Build a simple database Object Relational Mapper
- Build a reusable search component to filter collection of records
- Write tests using PHPUnit
Requirements
- Intermediate OOP PHP knowledge
Description
During this course you will learn how to use the best practice and how to make use of the Design Patterns in order to code the reusable component, which will allow you to filter your records.
We will build a simple Object Relational Mapper - to be used with Model classes representing entities of our project.
For each sub-component will write a set of tests using PHPUnit.
This course is for anyone who has a fundamental understanding of PHP programming language in its Object Oriented environment.
Who this course is for:
- Intermediate PHP developers or simply those who want to improve their knowledge of the subject
Course Content
-
Introduction
1 Lectures 00:01:34-
Introduction
Preview00:01:34
-
-
Setup
2 Lectures 00:23:30-
Exercise files and dependencies
Preview00:12:58 -
Environment and PHPUnit
Preview00:10:32
-
-
Database component
9 Lectures 02:13:18-
Database manager test
Preview00:09:08 -
Database drivers
00:21:22 -
Database execute method
00:11:11 -
Inserting new record
00:15:12 -
Database insert method
00:15:09 -
Database update and fetchObject method
00:20:16 -
Fetch object tests
00:08:12 -
Remove and count methods
00:13:08 -
Fetch objects and bootstrap
00:19:40
-
-
Container
1 Lectures 00:15:31-
Container
00:15:31
-
-
Models
12 Lectures 02:59:32-
Abstract model class
00:11:58 -
Update, delete and all methods
00:08:25 -
Order By and Limit methods
00:08:59 -
Lookup model test case
00:17:10 -
Update and remove tests
00:20:08 -
Model refactoring
00:18:06 -
Form dropdown
00:11:20 -
Year class
00:10:33 -
Book class
00:19:39 -
Testing update, remove, all and books methods
00:12:36 -
List of books
00:25:16 -
Group concatenation
00:15:22
-
-
Search and Sticky
3 Lectures 01:23:19-
Search class
00:33:05 -
Sticky (Part 1)
00:25:55 -
Sticky (Part 2)
00:24:19
-
-
Filter
6 Lectures 01:40:40-
Concatenators
00:20:00 -
Abstract Query
00:16:35 -
Pivot classes
00:17:22 -
Pivot under test
00:17:10 -
Query classes
00:11:10 -
Filter class
00:18:23
-
-
Filter tests
6 Lectures 01:34:45-
Equals tests
00:16:40 -
Filter equals tests
00:19:59 -
Exists tests
00:17:03 -
Filter exists tests
00:19:47 -
LikePercentBoth tests
00:10:06 -
Filter like percent both tests
00:11:10
-
-
Filtering records
4 Lectures 01:00:28-
Filter set
00:15:36 -
Model search method
00:14:54 -
Filter manager
00:16:17 -
Search tests
00:13:41
-
-
Pagination
8 Lectures 01:50:59-
Pagination class
00:15:17 -
Accessor methods
00:08:14 -
Pagination under test
00:21:35 -
Pagination view
00:22:12 -
Pagination view tests
00:18:33 -
Pagination test refactoring
00:11:54 -
Paginator
00:05:27 -
Paginator and view
00:07:47
-

Sebastian Sulinski
Founder of SSD Tutorials
A passionate web developer with experience spreading over a decade. Founder of SSD Tutorials where he publishes his free and premium tutorials on how to build modern web applications. Currently living and working in UK as a Senior Web Developer. Hobbies include snowboarding, mountain biking, hiking, gardening, travelling and macro photography.