Comments
Price
$120
Course Type
Online
Duration
3 hours
Date
Various dates throughout the year
Entry Requirements
All Levels
About this course
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.
What are the requirements?
- PHP web server with MySQL (either local or remote)
What am I going to get from this course?
- Over 26 lectures and 2 hours of content!
- Learn how to create a functional search form for the online application
- Learn how to use JOIN statement
- Learn how to build simple relationship between database tables in mysql
- Learn how to fetch data from the database using standard php mysql extension
- Learn how to display data fetched from the database
What is the target audience?
- Anyone who is interested in learning how to build the search from with PHP and MySQL
- Very basic knowledge of PHP and MySQL would be an advantage
