This is a short course designed to introduce you to how to use the jQuery AJAX method to populate a dropdown list.
This is a short course designed to get you started using the jQuery AJAX method to post data to a PHP script and work with the retrieved database records. It is a follow along style course, not one to teach you every aspect of PHP, jQuery or MySQL...there are other courses for that. This course is quite specific in its focus.
In the course you will learn how to create the database tables and populate with CSV files before learning how to use the jQuery AJAX method to post data to a PHP script to retrieve database records and populate a dropdown list. This is commonly seen when completing HTML forms and you have to select the country and the state will auto-populate from the selection.
The use of populated dropdown lists can be found on many websites and building them from a jQuery AJAX request and updating the second dropdown is a useful skill to have.
You will be taken through each step in a very careful manner and each line of code will be explained by Patrick.
Student feedback on the course:
"Great course on html dropdown lists using php, MySQL, AJAX. Short course to the point. The instructor is doing a great job explaining the topic in short lessons."
"Course was exactly as described. i was able to acquire new knowledge. teacher was excellent. concise and to the point. looking forward to other courses by this instructor"
"This course showed me a little bit of Ajax that I've seen used in some web applications and taught me how to have information or a drop down appear after it was selected. Very useful information from an excellent instructor."
I look forward to welcoming you to the course.
THE DEVELOPMENT ENVIRONMENT
IMPORTANT: Please read carefully
You are free to use ANY development environment including the one that you are already using (if any). In this course, I show you how to download and install Visual Studio Code and MAMP (both of which are FREE and available for Mac and Windows).
If you are unsure about which code editor option is best for you then I encourage you to contact me and I will be happy to discuss the options with you.
You can also follow this course using your own preferred code editor.
Once again, using Visual Studio Code with MAMP is OPTIONAL. You can use ANY suitable development environment of your choosing.
MY PROMISES TO YOU
As a registered teacher (yes, I teach in a real classroom every day), I strongly believe it is my job to ensure you feel totally supported when taking my classes. I therefore promise the following:
to respect you as a student and individual with your own learning needs
to be courteous and polite in our interactions
to answer your questions about the course content promptly
to fix any issues you may encounter with the lessons
to respond promptly to feedback
I really do look forward to welcoming you to this course. I am confident you will enjoy the approach of learning what each line of code actually means.
Join the course today.
You will be able to use jQuery AJAX calls to the server in order to update a HTML page
Create database tables and populate using CSV files
Use Emmet to quickly write HTML code
1 Lectures
2 Lectures
6 Lectures
3 Lectures
I have been teaching students for over 30 years and focus on delivering content in a clear and concise manner. As a national award-winning teacher, I am passionate about education and still teach in the classroom today. My online courses across subjects including coding, game development, and mathematics have attracted many thousands of students across over 120 countries.
For me this course was a great recap because I took all other courses. You wil find valuable informations and very good explanations.
really appreciate step by step guidance, since in the coding world it can get difficult to follow sometimes.
Well done Pattrick
I have been searching for this for quite a while.
Love the instructors pace. Examples are clear.
Would be nice to have a little more depth on the subject. e.g. like type ahead auto complete on searching the states and how to capture what state was selected.
Would like a little more depth on the vs code set up e.g. extensions being used.
Great course on html dropdown lists using php, MySQL, AJAX. Short course to the point. The instructor is doing a great job explaining the topic in short lessons. Intermediate level.
course was exactly as described. i was able to aquire new knowledge. teacher was excellent. concise and to the point. looking forward to other courses by this instructor
it quickly led me through going full-loop on an AJAX request / response with a PHP backend; will serve as a good reference.
This course showed me a little bit of Ajax that I've seen used in some web applications and taught me how to have information or a drop down appear after it was selected. Very useful information from an excellent instructor.
Your email address will not be published. Required fields are marked *
Jean L. G.
Wow, Everything is clearly explained !!!