Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy CBT Cognitive Behavioral Therapy Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing

DevelopmentWeb DevelopmentjQuery

PHP for Beginners Part 5: PHP, PDO, MySQL, jQuery AJAX

This is a short course designed to introduce you to how to use the jQuery AJAX method to populate a dropdown list.
Rating: 4.7 out of 54.7 (35 ratings)
288 students
Created by Patrick Morrow
Last updated 4/2022
English

What you'll learn

  • 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
  • Connect to a MySQL database using a PDO connection
  • Read data from a database table

Requirements

  • You should be familiar with HTML, CSS, PHP, and MySQL
  • You will need a PHP code editor and access to a MySQL database. I use Visual Studio Code and MAMP in the course. Any equivalent for your computer setup should be OK. Feel free to ask if unsure.

Description

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.



Who this course is for:

  • Beginners to PHP, MySQL and jQuery who want to extend their understanding through a simple practical application. You should already have a fairly good grasp of PHP, HTML, MySQL or be confident enough to follow the lessons easily.

Instructor

Patrick Morrow
Premium Instructor | National Award-winning Teacher
Patrick Morrow
  • 4.7 Instructor Rating
  • 1,696 Reviews
  • 7,906 Students
  • 7 Courses

Patrick Morrow is a national award-winning teacher (Outstanding Teacher of the Year) who has over 30 years of coding experience. He has been featured in the Financial Times, Computer Weekly, ISP World, and other publications. His teaching frameworks have been used by Her Majesty's inspection team as examples of best practice. Patrick still teaches in the classroom and uses his wealth of experience to find ways for students to maximise their potential. If you want to learn PHP then his PHP for Beginners course has been followed by over 8000 students and is perfect for beginners.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.