JSON AJAX data transfer to MySQL database using PHP
3.8 (181 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,660 students enrolled

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!​
3.8 (181 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
11,660 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 8 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • 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
Course content
Expand all 32 lectures 02:09:12
+ Introduction to course content
7 lectures 30:36
Resources for course content
00:01
JavaScript DOM setup output
03:07
Setup AJAX Javascript
09:56
JSON Looping Data
07:16
Source Code for JavaScript AJAX
00:08
+ Using PHP MySQL
7 lectures 25:38
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
00:08
+ Making it Interactive with AJAX and MySQL
5 lectures 26:03
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
00:23
+ Tweaks updates and different coding to create the same AJAX calls
10 lectures 36:22
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
00:03
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
00:15
JQUERY naming update
02:10
+ Bonus resources details
2 lectures 09:16
How to setup Localhost on your computer
08:50
AJAX form validation source code
00:26
Requirements
  • basic javascript
  • basic HTML CSS and PHP
  • desire to learn
  • computer access
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.




Who this course is for:
  • web developers
  • application develoeprs
  • frontend coders