
$id = $_GET['id'] ;
$dbuser="xjview";
$dbpassword="452375";
$database="xjview";
$hostname='localhost';
$con = mysql_connect($hostname,$dbuser,$dbpassword);
if(!$con)
{
return -3;
}
$db_selected = mysql_select_db($database, $con);
if(!$db_selected)
{
mysql_close();
return -2;
}
$fields = ' * ';
$table = 'feed';
$query = "SELECT ".$fields." FROM ".$table." WHERE id=$id ORDER BY priority DESC, date DESC, id DESC";
$result=mysql_query($query);
if(!$result)
{
mysql_close();
return -1;
}
$i = 0;
$id = mysql_result($result, $i, "id");
$title = mysql_result($result, $i, "title");
$content = replace_plain_text_link(mysql_result($result, $i, "content"));
$link = mysql_result($result, $i, "link");
$view = mysql_result($result, $i, "view");
$date = mysql_result($result, $i, "date");
$content = preg_replace('/\n/', ' ', $content);
print "$title\n";
print "\n";
print "$content \n";
print "Created: $date \n";
print " \n";
print "xjView Feeds \n";
$view ++;
$query = "UPDATE $table SET view=$view WHERE id=$id" ;
$result=mysql_query($query);
if(!$result)
{
mysql_close();
return -1;
}
?>
|