dongta5621
2014-06-30 14:41 阅读 76

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

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 :)

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dsfphczao23473056 dsfphczao23473056 2014-06-30 14:46

    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));
        },
    });
    
    点赞 评论 复制链接分享

相关推荐