English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 2 Hours | 546 MB
Create a dynamic input form that can add data and retrieve data from a MySQL database!
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.
Table of Contents
Introduction to course content
1 JSON MySQL Data course introduction
2 JSON MySQL Data course setup
3 Resources for course content
4 JavaScript DOM setup output
5 Setup AJAX Javascript
6 JSON Looping Data
7 Source Code for JavaScript AJAX
Using PHP MySQL
8 JSON Data from PHP get files
9 JSON MySQL setup table and database
10 JSON PHP array data
11 JSON PHP arrays json encoding
12 JSON MySQL Data connection
13 JSON MySQL Data output to JavaScript object
14 Source Code for PHP
Making it Interactive with AJAX and MySQL
15 CSS HTML setup form
16 Get form data
17 AJAX sending form data to PHP
18 JavaScript send POST to mySQL
19 Source Code
Tweaks updates and different coding to create the same AJAX calls
20 Tweak update code for AJAX Post to MySQL
21 Clean submit data in PHP
22 PHP MySQL Data insert for php 5.5 and up
23 Updated add.php file with newer PHP code
24 Redo in JQUERY
25 JQUERY AJAX to PHP server
26 JQUERY AJAX to get MYSQL data
27 JQUERY version of AJAX submit and retrieve
28 JQUERY source CODE
29 JQUERY naming update
Bonus resources details
30 How to setup Localhost on your computer
31 AJAX form validation source code
Resolve the captcha to access the links!