How to fetch wordpress posts through query() and output them in json?

Question

This code is working fine and pulling the blog posts but the only problem is that i want the data to be in a json array so that i can create an api with that and show posts outside...

<?php
require('/home/dealicopter/public_html/wp-load.php');
function wpdocs_custom_excerpt_length( $length ) {
    return 20;
}
add_filter( 'excerpt_length', 'wpdocs_custom_excerpt_length', 999 );
$args = array(
    'posts_per_page' => 10,
    'cat' => 7,
);
query_posts($args); if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php 
    $permalink = the_permalink();
    $title = the_title();
    $age = array("id"=>$permalink, "title"=>$title); 
    ?>
    <?php echo json_encode($age); ?>
<?php endwhile; else: echo "[]"; endif; ?>

<?php wp_reset_query(); ?>

Jasper B · Accepted Answer · 2021-05-24 10:32:49Z

2

Wordpress comes with an build-in API that returns JSON. you can hook in this as follows

https://example.com/wp-json/wp/v2/posts/?filter%5Bposts_per_page%5D=-1

API Documentation

if you want to make custom code I recommend using wp_send_json() create a new template file in you theme / child theme with the following code then create a new page and select the tempalte file in the page attribute

<?php
/*
Template Name: My Template Name
*/

add_filter( 'excerpt_length', 'wpdocs_custom_excerpt_length', 999 );
$args = array(
    'posts_per_page' => 10,
    'cat' => 7,
);

$output = array();
query_posts($args);

if (have_posts()) :
  while (have_posts()) : the_post();
    $permalink = get_the_permalink();
    $title = get_the_title();
    $output[] = array("id"=>$permalink, "title"=>$title); 
  endwhile;
endif;
wp_send_json($output);

edited May 24, 2021 at 10:32

answered May 17, 2021 at 14:25

Jasper B

8815 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zohaib Iqbal · Accepted Answer · 2021-05-17 14:43:46Z

Add this code to the function.php theme file

<?php
function get_post()
{
    $args_query = array(
        'post_type' => array('post'),
        'post_status' => array('publish'),
        'nopaging' => true,
        'order' => 'DESC',
    );

    $query = new WP_Query($args_query);
    $data = null;
    if ($query->have_posts()) {
        while ($query->have_posts()) {
            $query->the_post();
            $data[] = array('title' => get_the_title(), 'content' => get_the_content(), 'link' => get_the_permalink());
        }
    }
    wp_reset_postdata();

    if ($data != null) {
        echo json_encode(array('success' => true, 'data' => $data));
    } else {
        echo json_encode(array('success' => false, 'msg' => 'post not found'));
    }


    wp_die();
}
add_action('wp_ajax_get_post', 'get_post');
add_action('wp_ajax_nopriv_get_post', 'get_post');
?>

Javascript file code:

<script>
    (function($) {
        $('button').click(function(e) {
            e.preventDefault();
            $.ajax({
                type: "post",
                url: "https://********.com/wp-admin/admin-ajax.php",
                data: {
                    'action': 'get_post'
                },
                dataType: "json",
                success: function(response) {
                    console.log(response)
                }
            });
        });
    })(jQuery)
</script>

Collectives™ on Stack Overflow

How to fetch wordpress posts through query() and output them in json?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related