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"];
$start = $_GET["start"];
if(!isset($_GET['submitted'])) {
?> } else {
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 = "title LIKE '%$searchkeyword%' OR description LIKE '%$searchkeyword%'";
foreach ($searchkeyword_ as $search) {
$cat .= " OR title LIKE '%search%' OR description LIKE '%$search%'";
}
$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 " ";
}
?> |
}
?>
|
|