Mô tả

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.




Bạn sẽ học được gì

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

Yêu cầu

  • basic javascript
  • basic HTML CSS and PHP
  • desire to learn
  • computer access

Nội dung khoá học

6 sections

Introduction to course content

8 lectures
JSON MySQL Data course introduction
04:18
JSON MySQL Data course setup
05:49
Resources for course content
00:01
JavaScript DOM setup output
03:07
Setup AJAX Javascript
09:56
JSON Looping Data
07:16
Source Code for JavaScript AJAX
00:08
JSON data file
00:05

Using PHP MySQL

7 lectures
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:08

Making it Interactive with AJAX and MySQL

5 lectures
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:23

Tweaks updates and different coding to create the same AJAX calls

10 lectures
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:03
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:15
JQUERY naming update
02:10

Bonus resources details

2 lectures
How to setup Localhost on your computer
08:50
AJAX form validation source code
00:26

Bonus Section

3 lectures
JSON content to DOM
07:45
JavaScript Stringify LocalStorage
12:37
Source Code JavaScript Stringify LocalStorage
00:21

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.