创建一个简单的AJAX / jQuery / PHP SELECT * / JSON

Question

Basically I want to know how I can pass an array from PHP to JSON and be able to use it in my js file, where the jQuery is, and with jQuery I'm using the $.ajax({}).

I have so far:

$db = new PDO('mysql:host=localhost;dbname=names', 'username', 'password');
$stmt = $db->query('SELECT * FROM names ORDER BY name DESC');
$results = $stmt->fetchAll();

$namesArray = array();
foreach ($results as $row) {
    array_push($namesArray, '<li>' . $row['name'] . '</li>');
}

echo json_encode($namesArray);

As for the jQuery / AJAX, I'm not really sure how I should go about it. The only thing I want to do in PHP is make it select all the data from the database, (which has one col, names), and store them in an array via the foreach, and I pushed them to a separate array.

How would I go about the jQuery / AJAX? I've searched everywhere and the only thing I can find is how to make search functions with AJAX, although I don't want to search for one name, I want every name in the database to show up. Thanks in advance.

Update:

in my index.html file I have linked the .js file, and also in there I have a unordered list with the class: "names".

So, for my jQuery file, or .js file, I have

$(document).ready(function() {
    $.ajax({
        type: "POST",
        dataType: "json",
        url: "post.php",
        data: { },
        cache: false,
        success: function() {

        }
    });
});

but I'm not sure on what goes in the data variable, and also the success function I'm confused on too.

If I have forgotten any vital information on figuring this out please let me know :)

Answer 1

May be something like this with jQuery AJAX:

$.ajax({
    type : 'POST',
    url : 'path/to/your/file.php',
    success : function(data){
        console.log(JSON.parse(data));
    },
});