WordPress – Posts As News Clips Elsewhere

<!--?php 
 
# wp_latest_posts.php
# Displays a pre-set number of post-excerpts in a page
# outside of wordpress folder.
# This script must reside in the same folder as of index.php
# (http://www.your-site.com/index.php)

# MySQL connection details (refer to wp-config.php)
$host          = "localhost";
$dbuser        = "WORDPRESS_USER";
$dbpasswd      = "WORDPRESS_PASSWORD";
$database      = "WORDPRESS_DATABASE";
$table_prefix  = 'wp_';
$table_posts   = $table_prefix . 'posts';
 
# Connect to MySQL
$connect = mysql_connect($host, $dbuser, $dbpasswd) or die(mysql_error());
mysql_select_db($database,$connect) or die(mysql_error());
 
# Number of post-excerpts to be displayed on index.php
$num_latest = 5; 
 
# Perform the query
# This selects everything from '$table_posts' table which are 
# PUBLISHED and NOT PAGES, and reverse orders them by POST DATE.
$sql       = "SELECT * FROM $table_posts WHERE post_status LIKE ";
$sql      .= "\"%publish%\" AND post_type != 'page' ";
$sql      .= "ORDER BY post_date DESC LIMIT $num_latest ";
$result    = mysql_query($sql) or
             die('Invalid Query:' . mysql_errno() . mysql_error());
$nresults  = mysql_num_rows($result);
 
# Display results
# The results are displayed as an un-ordered list. Can be modified
# to meet specific requirements with basic knowledge of HTML
print "&lt;/p&gt;
&lt;h3&gt;News Clips&lt;/h3&gt;
&lt;p&gt;\n";
print "&lt;/p&gt;
&lt;ul&gt;\n";
 
while ($post_details = mysql_fetch_array($result)) {
 
  # Store the values in varaibles 
  $post_guid    = $post_details['guid'];
  $post_title   = $post_details['post_title'];
  $post_date    = $post_details['post_date'];
  $post_content = $post_details['post_content'];
 
  # Convert Date in to 'July 1, 2008' format
  # Refer to PHP's date manual for more options
  $post_date   = strtotime($post_date);
  $post_date   = date('F j, Y', $post_date);
 
  # Generate post-excerpt (say the first 150 characters
  # of post-content)
  $post_content = strip_tags($post_content, '&lt;br&gt; &lt;sub&gt; &lt;/sub&gt;');
 
  if (strlen($post_content) &gt; 150 ){
    $post_excerpt = mb_substr($post_content, 0, 147) . '... [More]';
  } else {
    $post_excerpt = $post_content;
  }
 
  # Display the entry details
  # One can decorate these with a basic working knowledge of CSS
  print "&lt;/p&gt;
&lt;li&gt;
&lt;br ?-->

include('wp_latest_posts.php');