PHP Tutorials: jQuery: Get Data from MySQL Database without Refreshing

Codecourse · 270K views · 2012 · 16:50

Open on YouTube

Web developmentPython, Ruby & scripting languagestutorialdated

Why Stack Overflow recommends it

Stack Overflow users link it as a worked example of the jQuery to PHP to MySQL AJAX pattern, both in answers pointing beginners to a free tutorial and in questions where askers followed it and got stuck.

Recommended by 1 people across 1 different months, 2012 to 2017.

What it is

A 2012 screencast by Codecourse (the channel behind PHP Academy tutorials) showing how to pull rows from a MySQL database into a web page using jQuery AJAX and a PHP script, without reloading the page. It walks through the front-end request and the PHP/MySQL back end step by step.

What people said

Recommends leocreatini · 2015-07 · Stack Overflow · on “How to add functionality a bootstrap search bar”

This depends on how you are planning to grab the data. If I have it right, you're looking to just make a POST/GET request to some database for Movies. Looks like php, maybe Wordpress/Drupal, so guessing it'd be a MySQL request. Here's a (free) tutorial from PHP Academy, Alex is a good tutor. PHPAcademy Video: [this video] Cheers.

Cites user0129e021939232 · 2012-11 · Stack Overflow · on “jQuery-Ajax retrieve function with PHP classes and functions”

Hi all I am new to using jQuery and I want to use the AJAX function for the search function my website. However I am having a bit of difficulty learning this as I can only find examples of using non function related PHP. I am currently trying to learn from this youtube example jQuery Youtube Example [this video] . However this seems difficult to implement. A little bit about what I am trying to achieve. I want to type in the postcode into my search bar and have it retrive all the relevant data fields that match using AJAX so that it is displayed in the div directly below the search bar. As I'm not very familiar with jQuery I'm not sure if I am going about this the right way, any input will be war

Cites PanCave · 2017-05 · Stack Overflow · on “Retrieving data from database using js,php,ajax”

I want to retrieve data from a database which is locally installed. But the website is written and controlled with js, so I have to send an ajax request to a php-file, which then connects to the database, sends the query and later the result back to js. I have a couple of files, because i followed this tutorial from 2012: [this video] The structure: |-ajax (Folder) | |-pkmn.php |-db (Folder) | |-connect.php |-js (Folder) | |-global.js |-index.php The files: index.php: <!DOCTYPE html> <html> <head> <meta charset="utf-8"></meta> </head> <body> Type: <input type="text" id="type"></input> Tier: <input type="text" id="tier"></input> <input type="submit" id="submit" value="Suchen"></input> <div id="pkm