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

PHP for Beginners Part 5: PHP, PDO, MySQL, jQuery AJAX, available at $49.99, has an average rating of 4.4, with 15 lectures, based on 39 reviews, and has 340 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful 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.

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

Summary

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

Price: $49.99

Average Rating: 4.4

Number of Lectures: 15

Number of Published Lectures: 15

Number of Curriculum Items: 15

Number of Published Curriculum Objects: 15

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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.

Target Audiences

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.

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 MySQLthere 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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Overview of the Development Environment

Chapter 2: The Database

Lecture 1: How to Create the MySQL Database Connection using PDO

Lecture 2: Populating the Database with the CSV Files

Chapter 3: The Frontend

Lecture 1: Creating the index page

Lecture 2: Creating the HTML form using Emmet

Lecture 3: Hiding the State dropdown

Lecture 4: Populating the countries dropdown

Lecture 5: Picking up the ID of the selected country

Lecture 6: Posting data using the jQuery AJAX method

Chapter 4: The Backend

Lecture 1: Testing the jQuery AJAX data

Lecture 2: Reading the States from the Database

Lecture 3: Populating the States dropdown

Chapter 5: The next steps

Lecture 1: Security considerations

Lecture 2: Code used in the course

Lecture 3: Bonus Lecture

Instructors

Coding Academy
Instructor at Udemy

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 1 votes

4 stars: 6 votes

5 stars: 31 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!