Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Star Rating Project AJAX with JSON response from PHP MySQL
Rating: 4.3 out of 5(48 ratings)
1,600 students

Star Rating Project AJAX with JSON response from PHP MySQL

Get dynamic data response using JQuery and AJAX to return PHP server content
Created byLaurence Svekis
Last updated 11/2021
English
English [Auto],

What you'll learn

  • create a project from scratch
  • use AJAX to get MySQL data
  • Use JQUERY to receive JSON data
  • PHP and JQUERY working together
  • create an image rating project

Course content

2 sections • 23 lectures • 1h 39m total length

  • AJAX project course introduction2:39

    Build a photo reading system from scratch using jQuery, ajax, and JSON from PHP and MySQL, load images, handle events, and update the page with server responses.

  • AJAX project setup resource overview5:28

    Set up an ajax driven star rating project with json responses, using jquery, php, and mysql, and configure a local host with apache, phpMyAdmin, and a star ratings database.

  • Setup resources for course1:00
  • AJAX project setup HTML template3:50

    Set up html to load images from the database, display a placeholder and an ajax response area, and render a jquery-driven star rating with a start button for new images.

  • AJAX project setup CSS7:31

    Explore CSS-driven AJAX-ready styling for a star rating widget, using content before selectors, icon fonts, and dynamic hover swaps, with jQuery integration and server communication.

  • source HTML and CSS2:00
  • AJAX project jquery functions4:45

    learn to set up document ready, manage image loading state, and implement a load image function in jquery ajax, triggered by a button to render five stars.

  • AJAX project AJAX to PHP response DB setup7:30

    Master a jQuery ajax workflow to send rating data to a PHP server, receive JSON, and update a MySQL ratings table.

  • Source 1 DB connect PHP response AJAX code1:00
  • AJAX project database output to AJAX5:53

    Build an ajax-driven flow that retrieves a random item from the readings database, encodes the result as json, and outputs it for client-side display while enforcing session vote limits.

  • AJAX project return ID and Image update HTML4:41

    Leverage ajax and jQuery to return the image url and database id, then update the HTML image source and preview with the new data and display the total votes.

  • AJAX project response totals from database5:23

    Learn how to compute total votes and the average rating for an image using AJAX with PHP and MySQL, including zero-value handling, rounding to two decimals, and session-based vote limits.

  • AJAX project PHP Sessions voter control3:43

    Learn to use PHP sessions to manage voting counts in an ajax star rating project. Initialize and decrement a votes left counter, with login or IP tracking to prevent abuse.

  • Server php source files1:00
  • AJAX project JQUERY index value4:37

    Implement an ajax-based voting feature with jQuery by listening for clicks on rating spans, computing a 1-based index, and sending updates to increment votes and the read column.

  • New AJAX call with response updates to HTML6:16

    Build a new ajax call to update a rating widget with a json response, passing image id and vote data, updating html and styles, and preventing multiple votes.

  • AJAX project PHP database response code11:26

    Explore how AJAX calls interact with a PHP backend to update and retrieve rating data, including session tracking, input sanitization, database updates, and JSON responses.

  • AJAX project error checking updates4:51

    Debug ajax errors in a star rating project by testing get requests, fixing undefined index and syntax issues, and ensuring response, votes, and averages; preview jquery hover highlighting next lesson.

  • Source for second AJAX php file add1:00
  • JQUERY highlight of stars3:27

    Learn to implement interactive star rating with jQuery by hover highlighting and filling stars on mouse enter and leaving, toggling classes to create dynamic feedback.

  • AJAX project tweaks7:03

    Learn to implement ajax-driven star rating with PHP and MySQL, updating votes instantly, computing a two-decimal average, and locking out users after a limited vote count using session tracking.

  • Completed Project Source Code3:00

Requirements

  • basic html and css
  • desire to learn

Description

Learn how to make a image rating application from scratch!

Everything is included, source files, resources and top links to get you creating your own projects quickly. Syntax use is explained step by step learning.

Multiple technologies are used in this course together to demonstrate how projects can be built. HTML and CSS to create the base of the application. How to add Jquery and setup AJAX calls. Setup PHP files to respond back to the AJAX call sending JSON data back to the front end.

Full project from start to finish, use the source code to create your own version of this useful application. One of the best ways to learn is to see code in action, see what it does fully explained. MySQL database connection with front-end Jquery.

There are so many great things that can be accomplished when combining front and backend code. Real world projects like this are useful and can also be incorporated and expanded to multiple other purposes.

This course is designed to teach you how to create applications, better learn and understand AJAX and JSON.

  • HTML
  • CSS
  • MySQL
  • JQUERY
  • JavaScript
  • PHP
  • JSON

Most popular tech online is demonstrated in this course.

Who this course is for:

  • anyone who wants to learn how to use multiple languages together
  • anyone who wants to learn to use AJAX in a real project
  • web developers
  • application developers

Report abuse