JSON AJAX data transfer to MySQL database using PHP

Create a dynamic input form that can add data and retrieve data from a MySQL database!​
4.5 (52 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,717 students enrolled
$19
$75
75% off
Take This Course
  • Lectures 30
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Create a dynamic input form that can add data and retrieve data from a MySQL database! Learn to create this project from Scratch

Instructor of this course is a web developer with over 15 years of experience working on hundreds of projects. Sharing real world coding experience.

This course is ideal for anyone who wants to see multiple programming languages working together. The end product will be a HTML form the can submit data via AJAX to a mySQL database. Using JSON formatted data we display all of the MySQL table contents within our webpage.

JavaScript > AJAX > PHP > MySQL vs MySQL > PHP > JSON > JavaScript

Learn how to use HTML, CSS, JavaScript, Jquery, JSON, AJAX, PHP, MySQL together in one project.

Topics covered include

  • JavaScript Objects
  • JSON formatted data
  • JavaScript AJAX to retrieve data
  • PHP database connection
  • PHP arrays
  • MySQL database with PHPmyAdmin
  • MySQL query strings
  • CSS form and HTML
  • AJAX to PHP JSON formatted data
  • JQUERY AJAX

I know that not everyone prefers JavaScript for AJAX, so I also show you how to re-code the JavaScript AJAX to be JQUERY AJAX. Also some tweaks and code updates are included. In addition I transform the old PHP data code to newer formats so that students can see the different ways of writing PHP.

All the source files and top resource links are included, so that you too can work along with the code practice and learn better.

This course is full of amazing content you won't see anywhere else.




What are the requirements?

  • basic javascript
  • basic HTML CSS and PHP
  • desire to learn
  • computer access

What am I going to get from this course?

  • learn to send data from the frontend to backend code
  • create dynamic input forms
  • update mysql database content with AJAX
  • get mysql content in JSON format
  • use mysql data in javascript

What is the target audience?

  • web developers
  • application develoeprs
  • frontend coders

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to course content
JSON MySQL Data course introduction
Preview
04:18
JSON MySQL Data course setup
Preview
05:49
Resources for course content
Article
JavaScript DOM setup output
03:07
Setup AJAX Javascript
09:56
JSON Looping Data
07:16
Source Code for JavaScript AJAX
Article
Section 2: Using PHP MySQL
JSON Data from PHP get files
04:03
JSON MySQL setup table and database
03:29
JSON PHP array data
03:23
JSON PHP arrays json encoding
03:32
JSON MySQL Data connection
05:15
JSON MySQL Data output to JavaScript object
05:48
Source Code for PHP
Article
Section 3: Making it Interactive with AJAX and MySQL
CSS HTML setup form
05:18
Get form data
03:44
AJAX sending form data to PHP
11:22
JavaScript send POST to mySQL
05:16
Source Code
Article
Section 4: Tweaks updates and different coding to create the same AJAX calls
Tweak update code for AJAX Post to MySQL
05:06
Clean submit data in PHP
03:32
PHP MySQL Data insert for php 5.5 and up
08:07
Updated add.php file with newer PHP code
Article
Redo in JQUERY
05:02
JQUERY AJAX to PHP server
05:13
JQUERY AJAX to get MYSQL data
02:17
JQUERY version of AJAX submit and retrieve
04:36
JQUERY source CODE
Article
JQUERY naming update
02:10
Section 5: Bonus resources details
How to setup Localhost on your computer
08:50

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Laurence Svekis, Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"

Ready to start learning?
Take This Course