BRAND NEW COURSE: In this course you will learn how to use PHP and the jQuery AJAX method to populate a dropdown select field based on another select field. This is commonly used for countries and states dropdown select lists. This may seem like a simple tasks but it involves a host of very useful skills.
You will learn how to:
create MySQL database tables
populate the database tables using CSV files
link to Bootstrap and jQuery
use Emmet to quickly create HTML code
connect to a database using a PDO connection
auto-populate the dropdown select options with data pulled from the database
populate the states dropdown without refreshing the page
use the jQuery AJAX method to send data to a PHP script
read data from a database using prepared statements
send data from a PHP script back to the jQuery AJAX method
This short course has been specifically designed to cover the basics of each of the above topics.
CONTENTS OF THE COURSE
The course should take you approximately 2 hours to complete if you plan to follow along and code.
The example within the course uses a country select dropdown with a list of states which is populated without a page refresh (using jQuery).
The course contains:
all require code files available for download
CSV files for the population of the database
16 video lessons detailing each stage of the process
access to the instructor for help
WHO IS THIS COURSE FOR?
You will already have a good understanding of PHP and HTML structures. You will already have a code editor on your computer or know how to download and install one. Links are provided within the course. You must have an internet connection to allow you to access and watch the course videos.
HOW MUCH IS THE COURSE?
The course is only $29 and includes full video tutorials with every step explained in detail. Head on over for a free preview of the course.
