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

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.

• web developers
• application develoeprs
• frontend coders

Course content

• Introduction to course content
  • JSON MySQL Data course introduction
  • JSON MySQL Data course setup
  • Resources for course content
  • JavaScript DOM setup output
  • Setup AJAX Javascript
  • JSON Looping Data
  • Source Code for JavaScript AJAX
• Using PHP MySQL
  • JSON Data from PHP get files
  • JSON MySQL setup table and database
  • JSON PHP array data
  • JSON PHP arrays json encoding
  • JSON MySQL Data connection
  • JSON MySQL Data output to JavaScript object
  • Source Code for PHP
• Making it Interactive with AJAX and MySQL
  • CSS HTML setup form
  • Get form data
  • AJAX sending form data to PHP
  • JavaScript send POST to mySQL
  • Source Code
• Tweaks updates and different coding to create the same AJAX calls
  • Tweak update code for AJAX Post to MySQL
  • Clean submit data in PHP
  • PHP MySQL Data insert for php 5.5 and up
  • Updated add.php file with newer PHP code
  • Redo in JQUERY
  • JQUERY AJAX to PHP server
  • JQUERY AJAX to get MYSQL data
  • JQUERY version of AJAX submit and retrieve
  • JQUERY source CODE
  • JQUERY naming update
• Bonus resources details
  • How to setup Localhost on your computer
  • AJAX form validation source code