JSON AJAX data transfer to MySQL database using PHP
4.2 (73 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,854 students enrolled
Wishlisted Wishlist

Please confirm that you want to add JSON AJAX data transfer to MySQL database using PHP to your Wishlist.

Add to Wishlist

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.2 (73 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,854 students enrolled
Created by Laurence Svekis
Last updated 4/2017
English
Current price: $10 Original price: $150 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 7 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • web developers
  • application develoeprs
  • frontend coders
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:07:57
+
Introduction to course content
7 Lectures 30:45


Resources for course content
00:05

JavaScript DOM setup output
03:07

Setup AJAX Javascript
09:56

JSON Looping Data
07:16

Source Code for JavaScript AJAX
00:13
+
Using PHP MySQL
7 Lectures 25:44
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:14
+
Making it Interactive with AJAX and MySQL
5 Lectures 26:11
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:31
+
Tweaks updates and different coding to create the same AJAX calls
10 Lectures 36:32
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:04

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:24

JQUERY naming update
02:10
+
Bonus resources details
2 Lectures 09:26
How to setup Localhost on your computer
08:50

AJAX form validation source code
00:36
About the Instructor
Laurence Svekis
4.2 Average rating
11,973 Reviews
270,872 Students
179 Courses
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!"