Infinite Scroll Project AJAX MySQL API PHP jQuery

Explore how to create a web application that sends requests to the server for additional data as users scroll the page
Rating: 4.4 out of 5 (192 ratings)
24,572 students
Infinite Scroll Project AJAX MySQL API PHP jQuery
Rating: 4.4 out of 5 (192 ratings)
24,572 students
connecting to an API
setting up a PHP database API
using AJAX to pull JSON data from the backend
getting MySQL data into a web application

Requirements

  • PHP working knowledge
  • MySQL working knowledge
  • jQuery AJAX working knowledge
Description

Infinite scrolling is a web-design technique that loads content continuously as the user scrolls down the page, eliminating the need for pagination.  This technique popular is used on many websites and this course will show you how to build one yourself from scratch.

Best of all this course provides a great learning experience on how to develop an API that can return database content into the front end.  Learn how to combine technologies and the steps needed to plan out the building of applications. Explore how you can use AJAX to send requests to a server API returning content in a JSON format to be added to your web page content.

Prerequisites to this course include working knowledge of jQuery, JavaScript and PHP.  We cover the aspects of the languages needed to create the API endpoint and to query the endpoint for data.

One of the best ways to learn programming is by projects and this project is perfect since it combines the use of multiple technologies within one application so that students get a real world experience. 

  • Learn how to setup the structure of your web application
  • Find out about creating a PHP database connection
  • Create a simple PHP application to populate the database with lorem ipsum text
  • Explore how an API works outputting content from the MySQL database into JSON format
  • Use PHP code to build a customized JSON output
  • Explore how easy it is to make AJAX requests with jQuery
  • Use JavaScript to detect scroll and more
  • Assemble your HTML page dynamically
  • Examine how web applications are built

Source Code is included to get you started quickly.

Taught by an instructor with over 18 years of web development experience, ready to help answer any questions you may have.

Join now and start building your own applications today.


Who this course is for:
  • application developers
  • web developers
Course content
2 sections • 20 lectures • 1h 33m total length
  • Infinite Scroll Introduction
    07:15
  • Scroll project Resources
    05:25
  • Setup basic application page
    03:33
  • Setup Database connection PHP
    06:17
  • Source Code conn.php
    00:04
  • How to populate database with lorem ipsum text PHP
    10:38
  • Source Code Build.php
    00:05
  • Output API contents PHP
    06:48
  • App development overview PHP
    03:33
  • Create AJAX call to api jQuery and PHP
    07:52
  • load api data output it to HTML jQuery
    05:43
  • debugging and adding offset values PHP
    07:43
  • jQuery scroll detection
    02:46
  • Load more entries tweak source code jQuery
    06:01
  • PHP code Overview
    08:13
  • PHP code examples
    00:22
  • jQuery Code review
    10:00
  • index.html jQuery source code
    00:24
  • Resources
    00:02
  • Bonus Lecture
    01:13

Instructor
Instructor, GDE, Application Developer
Laurence Svekis
  • 4.2 Instructor Rating
  • 37,376 Reviews
  • 645,737 Students
  • 357 Courses

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today
Google Developers Expert - GSuite

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"