CODEWITHSUNDEEP
phpmysqldisqus
weigruf
weigruf

Reputation: 36

Getting the DISQUS Comments number from dynamic pages and populate MySQL

DISQUS commenting system is nice. API is confusing me a bit, so if anyone can please guide me to the right directions.

What I want to do is to get the total number of comments from dynamic pages/posts and insert that number to a MySQL table so I can filter the posts of those pages according to the total comments number and display each post's comment number in the forontapage, sidebars etc. Of course, I would like to update those rows later with a function I'll create when new comments pop up. But what I am asking is just the way I can get them.

Below my disqus_indentifier:

var disqus_identifier = <?php echo $post_id ?>;

Thanks!

Upvotes: 1

Views: 5745

Answers (1)

Tyler Hayes
Tyler Hayes

Reputation: 1366

As you discovered, the Disqus comment count script is definitely the best solution for what you're trying to do. It doesn't require any API integration or database work. Simply paste the code on your site and it will automatically find the counts for all comment count links on the page and show the relevant Disqus comment count for each.

For anyone looking to do more granular work along these lines via our API, the best endpoint would probably be threads/details which returns the details for a thread (including the number of comments). As far as inserting that information into your database I'd recommend looking over basic SQL INSERT documentation.

We've also put together some sample API recipes which can help you jumpstart your API integration, including a threads/details PHP script.

Upvotes: 2

Related Questions