Blog

Wordpress - Related Posts Script

At my job, I currently have three Wordpress sites under my watchful eye. On one, I was tasked with creating a related posts feature. Now, there are certainly enough plug-ins that will do just that, but none of them worked how I wanted to or were generally more complex than necessary. So, I whipped up this little script:

Code: php
  2. function relatedPosts($id) {
  3. /* Build a query to get a list of all posts that share similar tags */
  4. $s = microtime(true);
  5. $q = "SELECT count(*) AS total, p.ID, p.post_title, p.post_date FROM wp_posts p INNER JOIN wp_term_relationships t ON p.ID=t.object_id AND t.term_taxonomy_id in (SELECT s.term_taxonomy_id FROM wp_term_relationships s WHERE s.object_id=$id) AND t.object_id != $id AND p.post_status='publish' GROUP BY p.id ORDER BY total DESC, p.post_date DESC LIMIT 5";
  6. /* Format the output */
  7. $out = "";
  8. $result = @mysql_query($q);
  9. if ($result && @mysql_num_rows($result) > 0) {
  10. $out = "<h3 class=\"related\">Related Posts</h3><ul class=\"related\">";
  11. while ($row = mysql_fetch_object($result)) {
  12. $perma = get_permalink($row->ID);
  13. $out .= '<li><a href="'.$perma.'">'.$row->post_title.'</a> - '.date("F j, Y", strtotime($row->post_date)).'</li>';
  14. }
  15. $out .= "</ul>";
  16. }
  18. echo($out);
  19. }
  20. ?>

Just drop that in the wp-content/yourtheme/functions.php file, where yourtheme is the directory of your active theme. Then add the following in your wp-content/yourtheme/single.php where you want the related posts to appear:

Code: php
  2. relatedPosts(get_the_ID());
  3. ?>

You should now have a list of posts with similar tags. Styling is simple: one h3 and one ul, both with the class "related".

Enjoy!

ID3Lib - A tag library for all seasons

image

ID3Lib [ Download ]

As one may have derived from previous posts, I have a project the uses MP3s quite heavily. As such, retrieving tag data from these is quite an important thing. Having recently migrated my personal server to Windows, I needed a non-Linux variant of my previous tag read. I thought that while I was at it I could add an additional feature, namely saving embedded album art. Unfortunately, I was unable to find any clear directions on how to do so using TagLib, so I created my own library. Three different times. In three different languages. A C++ version, a .NET version and, finally, a PHP version.

Read More

Getting a YouTube FLV through PHP

PHP Corner

Recently, while making some additions to the Music Page, I came across the need to get the location of a YouTube FLV. Unfortunately, most of my googling turned up outdated results that no longer work. Fortunately, unlike a certain other site, it's not impossible. Below is a quick explanation of what I got to work. I'll be assuming that you know how to get your hands on the video ID (the "v" parameter in the query string).

Read More

A tiny PHP/Twitter script just for you!

Was rather bored this afternoon and then I though to myself "Why not add Twitter functionality to my music page?" So, after some digging through Twitter APIs and some refreshers on HTTP Authentication, I wrote this tiny, beautiful little script.

Code: php
  3. // Return values
  4. define ("TWITTER_OK", true);
  5. define ("TWITTER_UNAUTHORIZED", -1);
  6. define ("TWITTER_TOO_LONG", -2);
  7. define ("TWITTER_COULD_NOT_CONNECT", -3);
  8. function sendTweet ($status, $userName, $userPass)
  9. {
  10. // Open a socket to Twitter
  11. if (!($socket = fsockopen ("twitter.com", 80)))
  12. return TWITTER_COULD_NOT_CONNECT;
  14. // Create the headers
  15. $headers = "POST /statuses/update.xml HTTP/1.1\r\n";
  16. $headers .= "Host: twitter.com\r\n";
  17. $headers .= "Authorization: Basic ".base64_encode ($userName.":".$userPass)."\r\n";
  18. $headers .= "Content-length: ".strlen ("status=$status")."\r\n\r\n";
  19. $headers .= "status=$status\r\n";
  21. // Send the headers
  22. fwrite ($socket, $headers);
  24. // Get the response
  25. $response = "";
  26. while (!feof ($socket))
  27. $response .= fgets ($socket, 1024);
  29. // Check for HTTP status OK (200)
  30. if (!strpos ($response, "200"))
  31. return TWITTER_UNAUTHORIZED;
  32. return TWITTER_OK;
  34. }
  36. ?>

It is as simple as it looks. Enjoy!