About This Course
Create a dynamic input form that can add data and retrieve data from a MySQL database! Learn to create this project from scratch.
The 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 an HTML form that 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:
- 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.
Our Promise to You
By the end of this course, you will be able to learn how to create a dynamic input form that can add and retrieve data from a MySQL database.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and develop your skills in JSON AJAX data transfer!
Course Curriculum
Section 1 - Introduction To Course Content | |||
JSON MySQL Data Course Introduction | 00:00:00 | ||
JSON MySQL Data Course Setup | 00:00:00 | ||
Resources For Course Content | 00:00:00 | ||
JavaScript DOM Setup Output | 00:00:00 | ||
Setup AJAX Javascript | 00:00:00 | ||
JSON Looping Data | 00:00:00 | ||
Source Code For JavaScript AJAX | 00:00:00 | ||
Section 2 - Using PHP MySQL | |||
JSON Data From PHP Get Files | 00:00:00 | ||
JSON MySQL Setup Table And Database | 00:00:00 | ||
JSON PHP Array Data | 00:00:00 | ||
JSON PHP Arrays JSON Encoding | 00:00:00 | ||
JSON MySQL Data Connection | 00:00:00 | ||
JSON MySQL Data Output To JavaScript Object | 00:00:00 | ||
Source Code For PHP | 00:00:00 | ||
Section 3 - Making It Interactive With AJAX And MySQL | |||
CSS HTML Setup Form | 00:00:00 | ||
Get Form Data | 00:00:00 | ||
AJAX Sending Form Data To PHP | 00:00:00 | ||
JavaScript Send POST To mySQL | 00:00:00 | ||
Source Code | 00:00:00 | ||
Section 4 - Tweaks Updates And Different Coding To Create The Same AJAX Calls | |||
Tweak Update Code For AJAX Post To MySQL | 00:00:00 | ||
Clean Submit Data In PHP | 00:00:00 | ||
PHP MySQL Data Insert For PHP 5.5 And Up | 00:00:00 | ||
Updated Add.php File With Newer PHP Code | 00:00:00 | ||
Redo In JQUERY | 00:00:00 | ||
JQUERY AJAX To PHP server | 00:00:00 | ||
JQUERY AJAX To Get MYSQL Data | 00:00:00 | ||
JQUERY Version Of AJAX Submit And Retrieve | 00:00:00 | ||
JQUERY Source CODE | 00:00:00 | ||
JQUERY Naming Update | 00:00:00 | ||
Section 5 - Bonus Resources Details | |||
How To Setup Localhost On Your Computer | 00:00:00 |