JSON AJAX data transfer to MySQL database using PHP

Name: JSON AJAX data transfer to MySQL database using PHP
Rating: 4.1 (226 reviews)

Create a dynamic input form that can add data and retrieve data from a MySQL database!

Created byLaurence Svekis

Last updated 1/2022

English

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

6 sections • 35 lectures • 2h 28m total length

JSON MySQL Data course introduction4:18
Explore JSON data transfer to a MySQL database using PHP through JavaScript and AJAX, building a dynamic front end that reads and writes data.
JSON MySQL Data course setup5:49
Set up a local server and connect to a MySQL database to output JSON data via PHP and JavaScript Ajax, using phpMyAdmin, Zap, and Brackets for front-end development.
Resources for course content0:01
JavaScript DOM setup output3:07
Set up the JavaScript DOM output by grabbing the output element with getElementById, initialize an output variable, and prepare to pull JSON data via AJAX for output into the page.
Setup AJAX Javascript9:56
JSON Looping Data7:16
Source Code for JavaScript AJAX0:08
JSON data file0:05

CSS HTML setup form5:18
Get form data3:44
Learn how to update a web form to send data via AJAX to a PHP script, using a submit function, form data, and console inspection to populate a MySQL database.
AJAX sending form data to PHP11:22
JavaScript send POST to mySQL5:16
Update the PHP form to capture first name, last name, and age, insert into the users table, and use ajax with post to load updated records on page load.
Source Code0:23

Tweak update code for AJAX Post to MySQL5:06
Clean submit data in PHP3:32
PHP MySQL Data insert for php 5.5 and up8:07
Learn to perform PHP MySQL data inserts with prepared statements and bound parameters, ensuring data types like strings and integers and guarding against injection.
Updated add.php file with newer PHP code0:03
Redo in JQUERY5:02
JQUERY AJAX to PHP server5:13
Post serialized form data via jQuery ajax to a PHP server and handle the response to confirm insertion, while troubleshooting data transfer issues.
JQUERY AJAX to get MYSQL data2:17
JQUERY version of AJAX submit and retrieve4:36
Update the output div to feed content into the email code using the jQuery AJAX submit and retrieve, looping through the response to append first name, last name, and age.
JQUERY source CODE0:15
JQUERY naming update2:10

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

JSON AJAX data transfer to MySQL database using PHP

What you'll learn

Explore related topics

Course content

Introduction to course content8 lectures • 31min

Using PHP MySQL7 lectures • 26min

Making it Interactive with AJAX and MySQL5 lectures • 26min

Tweaks updates and different coding to create the same AJAX calls10 lectures • 36min

Bonus resources details2 lectures • 9min

Bonus Section3 lectures • 21min

Requirements

Description

Who this course is for: