Alex
11-09-2005, 10:40 AM
This came up as frequent request, so here is an example how to show latest articles outside the script's root. Let's say you installed phpWordPress in http://www.example.com/news directory, and you want to pull latest articles on your home page http://www.example.com
Place this code snippet anywhere in index file where you want the articles to appear:
<?php
include_once("<PATH_TO_SCRIPT>/include/conf.php");
include_once("<PATH_TO_SCRIPT>/include/db_conn.php");
function short_text($text)
{
$text=strip_tags($text);
$words=explode(' ',$text);
$word_number=50;
for ($i = 0; $i < $word_number; $i++) {
$short_text .= $words[$i]. " "; }
if ($i<sizeof($words)) $short_text .="...";
return $short_text;
}
function HTML_show_friendly_url($id)
{
if ($showFriendlyURL<>"no") {
$query="Select * from tblArticles where id=$id";
$result=mysql_query($query) or die("bad query friendly aricles");
$row=mysql_fetch_array($result);
if ($row['SEfriendly']<>"")
$idf=$row['SEfriendly'];
else
$idf=$row['id'];
if (!$rule=friendly_path($row['category_id']))
$rule="news/";
$frURL=$rule.$idf.".html";
} else {
$frURL="index.php?".$rule."=".$id;
}
return $frURL;
}
function friendly_path($cat_id)
{
$cat_list=array();
$end=0;
while (!$end)
{
$query="SELECT * from tblCategories where id=$cat_id";
$result=mysql_query($query) or die ("Bad query Article_Breadcrumb");
if ($row=mysql_fetch_array($result))
{
$name=$row['category_name'];
$category=array('id'=>$cat_id,'name'=>$name);
array_push($cat_list, $category);
$cat_id=$row['parent_cat'];
if ($cat_id==0) $end=1;
}
}
$friendly_path="";
$cat_list=array_reverse($cat_list);
foreach($cat_list as $ct)
{
if ($ct['name']==htmlentities($ct['name']))
$friendly_path.=urldecode($ct['name'])."/";
else return false;
}
return $friendly_path;
}
$query="SELECT * FROM tblArticles WHERE status=1 ORDER BY created DESC LIMIT 5";
$result=mysql_query($query) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<a href="'.$url.HTML_show_friendly_url($row['id']).'" >'.$row['title'].'</a>\r\n';
echo "<br />\r\n";
echo short_text($row['body']);
}
?>
Note: choose correct path to "include" folders, and customize display via CSS the way you want.
This displays 5 latest articles, using Friendly_URL support. If you want to modify munber of articles, just amend the query (SQL SELECT statement), and instead of LIMIT 5, put desired number.
Place this code snippet anywhere in index file where you want the articles to appear:
<?php
include_once("<PATH_TO_SCRIPT>/include/conf.php");
include_once("<PATH_TO_SCRIPT>/include/db_conn.php");
function short_text($text)
{
$text=strip_tags($text);
$words=explode(' ',$text);
$word_number=50;
for ($i = 0; $i < $word_number; $i++) {
$short_text .= $words[$i]. " "; }
if ($i<sizeof($words)) $short_text .="...";
return $short_text;
}
function HTML_show_friendly_url($id)
{
if ($showFriendlyURL<>"no") {
$query="Select * from tblArticles where id=$id";
$result=mysql_query($query) or die("bad query friendly aricles");
$row=mysql_fetch_array($result);
if ($row['SEfriendly']<>"")
$idf=$row['SEfriendly'];
else
$idf=$row['id'];
if (!$rule=friendly_path($row['category_id']))
$rule="news/";
$frURL=$rule.$idf.".html";
} else {
$frURL="index.php?".$rule."=".$id;
}
return $frURL;
}
function friendly_path($cat_id)
{
$cat_list=array();
$end=0;
while (!$end)
{
$query="SELECT * from tblCategories where id=$cat_id";
$result=mysql_query($query) or die ("Bad query Article_Breadcrumb");
if ($row=mysql_fetch_array($result))
{
$name=$row['category_name'];
$category=array('id'=>$cat_id,'name'=>$name);
array_push($cat_list, $category);
$cat_id=$row['parent_cat'];
if ($cat_id==0) $end=1;
}
}
$friendly_path="";
$cat_list=array_reverse($cat_list);
foreach($cat_list as $ct)
{
if ($ct['name']==htmlentities($ct['name']))
$friendly_path.=urldecode($ct['name'])."/";
else return false;
}
return $friendly_path;
}
$query="SELECT * FROM tblArticles WHERE status=1 ORDER BY created DESC LIMIT 5";
$result=mysql_query($query) or die(mysql_error());
while ($row=mysql_fetch_array($result))
{
echo '<a href="'.$url.HTML_show_friendly_url($row['id']).'" >'.$row['title'].'</a>\r\n';
echo "<br />\r\n";
echo short_text($row['body']);
}
?>
Note: choose correct path to "include" folders, and customize display via CSS the way you want.
This displays 5 latest articles, using Friendly_URL support. If you want to modify munber of articles, just amend the query (SQL SELECT statement), and instead of LIMIT 5, put desired number.