You are here : Home - Resources - RSS Feed Directory
RSS Feed Directory
$DB_host = "localhost";
$DB_username = "web92-webdevtips";
$DB_pass = "jsty7axy";
$DB_name = "web92-webdevtips";
$db = mysql_connect($DB_host, $DB_username, $DB_pass) or die("Could not connect.");
mysql_select_db($DB_name,$db) or die("Unable to select requested database");?>
echo "
RSS Feed Directory ";
//show categories from provider
if(isset($cat)){
$result = mysql_query("SELECT rss_provider, rss_cat FROM rss WHERE rss_provider ='$provider' ORDER BY rss_cat") or (mysql_error());
//$row = mysql_fetch_row($result);
//if($row[1] != "CSM"){
//put values into array
while ($row = mysql_fetch_row($result)){
$myarray[] = $row[1];
if($row[1]=="No Cat"){$sub="No Cat";}
}
//remove duplicate entries
if(!isset($sub)){
$myarray = array_unique($myarray);
//renumber key values
$i=0;
foreach ($myarray as $a) {
$mynewarray[$i] = $a;
$i++;
}
//display the new array
echo " -
$provider
";
echo "
";
for ($i=0; $i < count($mynewarray); $i++){
$result_count = mysql_query("SELECT rss_subcat FROM rss WHERE rss_cat = '$mynewarray[$i]'") or (mysql_error());
$result_count = MYSQL_NUMROWS($result_count);
echo "$mynewarray[$i] | ( $result_count ) |
";
}//end for
echo "
";
}
}//end $cat
if(isset($sub)){
if ($sub == "No Cat"){
echo " - $provider
";
}
else
{
echo " -
$provider - $sub
";
}
$result = mysql_query("SELECT * FROM rss WHERE rss_cat ='$sub' AND rss_provider = '$provider' ORDER BY rss_subcat") or (mysql_error());
//put values into array
while ($row = mysql_fetch_row($result)){
$mycatarray[] = $row[3];
$myurlarray[] = $row[4];
}
echo "
\n";
for ($i=0; $i < count($mycatarray); $i++){
$myurl = $myurlarray[$i];
$myurl = preg_replace("/\//","/",$myurl);
$myurla = urlencode($myurlarray[$i]);
echo "\n\n- $mycatarray[$i]
\n- $myurl
preview feed
\n";
}
echo "
\n\n";
echo "
get this directory as xml (do not link directly to this feed) ";
}
//if no category show providers
if(!$QUERY_STRING){
echo "
Providers";
$result = mysql_query("SELECT rss_provider FROM rss") or (mysql_error());
//$row = mysql_fetch_row($result);
$number = mysql_numrows($result);
//put values into array
while ($row = mysql_fetch_row($result)){
$myarray[] = $row[0];
}
//remove duplicate entries
$mytmparray = array_unique($myarray);
//renumber key values
$i=0;
foreach ($mytmparray as $a) {
$mynewarray[$i] = $a;
$i++;
}
sort($mynewarray);
//display the new array
echo "
";
for ($i=0; $i < count($mynewarray); $i++){
$result_count = mysql_query("SELECT rss_cat, rss_subcat FROM rss WHERE rss_provider = '$mynewarray[$i]'") or (mysql_error());
$result_counter = MYSQL_NUMROWS($result_count);
while ($rowa = mysql_fetch_row($result_count)){
$myarraya[] = $rowa[0];
}
$catcount = array_unique($myarraya);
//$catcount = count($catcount);
$catcount = count($catcount) ;
unset($myarraya) ;
echo "$mynewarray[$i] | ( $result_counter Feeds ) ( $catcount Categories ) |
";
}
echo "
";
$number = MYSQL_NUMROWS($result);
echo "
( $number Feeds )
";
}
?>