Udemy - Advanced search form with PHP and MySQL

In this course you will learn how to create the advanced search form for your website with PHP and MySQL. We will learn how to build the form with the text field for the search phrase, dropdown menus and radio buttons for single and checkboxes for multiple selection of the search criteria. We will create a database and define the relationships between the tables using Primary and Foreign keys. You will learn how to use SQL JOIN statements in order to retrieve data based on the submitted request.

1: Introduction
1
What we are going to be building

00:39
2: Building database
2
Database and lookup tables

07:40
3
Joint tables

03:12
4
Understanding relationships between the tables

03:20
5
Lookup table relationship
03:09
6
Joint table relationships
04:01
7
Importing records
01:06
3: Layout
8
Structure of the page
03:27
9
Form structure
06:08
10
Labels and input tags
03:31
4: Functions
11
Database connection
03:37
12
Languages dropdown menu function
09:37
13
Authors, Categories and Years functions
05:36
14
Displaying radio buttons function
04:49
15
Multi select check boxes function
05:35
16
Sticky form fields function for multiple form elements
06:31
17
Applying sticky form fields to all functions
07:29
18
Default selection for radio button
03:07
5: Displaying results
19
Results table
02:27
20
Populate records using JOIN statement
09:10
21
Displaying results using DO { } WHILE loop
04:23
22
Preparing URL parameters for processing
09:03
23
Putting queries into arrays
09:57
24
WHERE statement
05:22
25
Displaying messages
03:39
6: Conclusion
26
Project summary
00:33