411 for Listners
411 for Podcasters
411 for News Media
For Everyone
|
|
Enter a keyword or choose a category to browse podcasts.
include("dbfunctions.php");
$searchkeyword = $_GET["search_field"];
$numlinks_perpage = $_GET["numlinks_perpage"];
$category = $_GET["category"];
$start = $_GET["start"];
if(!isset($_GET['submitted'])) {
?> } else {
if($category=="") {
echo "You must choose a category";
exit;
}
if(!isset($_GET["start"])) $start = 0;
?>
$link = OpenConnection();
if ($link == FALSE) {
echo "Unable to connect to dbase.";
return;
}
$searchkeyword_ = trim($searchkeyword);
$searchkeyword_ = explode(" ", $searchkeyword);
$cat = "genre='$category' AND (";
foreach ($searchkeyword_ as $search) {
$cat .= " title LIKE '%$search%' OR description LIKE '%$search%'";
}
$cat .=")";
$query = "SELECT count(*) as count FROM podcasts WHERE $cat";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$numrows = $row['count'];
$numlinks_perpage = 500;
$query = "SELECT * FROM podcasts WHERE $cat ORDER BY title ASC LIMIT $start , $numlinks_perpage";
$result = mysql_query($query) or die("Unable to read database : $query");
$num = mysql_num_rows($result);
$total2 = $num - "1";
$i=$start+1;
while ($line = mysql_fetch_array($result))
{
$podcastid = $line["podcastid"];
$title = $line["title"];
$homepage = $line["homepage"];
$rss = $line["rss"];
$mp3url = $line["mp3url"];
$language = $line["language"];
$genre = $line["genre"];
$subgenre = $line["subgenre"];
$description = $line["description"];
//
$query1 = "SELECT count(reviewid) as count FROM Reviews WHERE podcastid='$podcastid'";
$result1 = mysql_query($query1) or die("Unable to read database : $query1");
$row = mysql_fetch_array($result1);
$revnum = $row['count'];
?>
No.
|
echo $i; ?>
|
Title
|
echo $title; ?>
|
Home Page
|
if($homepage<>"") { ?>
Home Page
} else { ?>
No homepage
} ?>
|
RSS
|
if($rss<>"") {
echo $rss;
} else { ?>
No RSS Feed
} ?>
|
MP3 URL
|
if($mp3url<>"") { ?>
MP3 URL Page
} else { ?>
No RSS Feed
} ?>
|
Language
|
echo $language; ?>
|
Genre
|
echo $genre; ?>
|
Sub Genre
|
echo $subgenre; ?>
|
Description
|
echo $description; ?>
|
Reviews:
|
if($revnum<>"0") { ?>
This site has echo $revnum; ?> reviews.
Click here to see those reviews or click here to review this site yourself
} else { ?>
This site has no reviews. Be the first to review it by clicking here.
} ?>
|
if($num>1) {
?>
|
}
$i++;
}
if ($i == "1")
{
echo " \n";
echo " No results | \n";
echo " \n";
}
?>
if($start > 0) {
echo "Previous";
}
if($numrows > ($start + $numlinks_perpage)) {
echo " ";
}
?>
|
}
?>
|
|