Hi!
I'm new to Mysql, and am trying to filter mp3's by dropdown menus, but can't seem to figure it out. Just wondering if there is a good tutorial I could follow? Couldn't find one searching the site or Google.
http://www.baysidesuperior.org/resources2
Thanks!
<form name="resourceFilter" id="resourceFilter">
<select name="date" id="date-sort" class="sorter" onChange="document.location = this.value">
<option>Date</option>
<option value='9-2012'>September 2012</option>
<option value='8-2012'>August 2012</option>
<option value='7-2012'>July 2012</option>
<option value='6-2012'>June 2012</option>
<option value='5-2012'>May 2012</option>
<option value='4-2012'>April 2012</option>
<option value='3-2012'>March 2012</option>
<option value='2-2012'>February 2012</option>
<option value='1-2012'>January 2012</option>
<option value='12-2011'>December 2011</option>
<option value='11-2011'>November 2011</option>
<option value='10-2011'>October 2011</option>
<option value='9-2011'>September 2011</option>
<option value='8-2011'>August 2011</option>
<option value='7-2011'>July 2011</option>
<option value='6-2011'>June 2011</option>
<option value='5-2011'>May 2011</option>
<option value='4-2011'>April 2011</option>
<option value='3-2011'>March 2011</option>
<option value='2-2011'>February 2011</option>
<option value='1-2011'>January 2011</option>
<option value='12-2010'>December 2010</option>
<option value='11-2010'>November 2010</option>
<option value='10-2010'>October 2010</option>
<option value='9-2010'>September 2010</option>
<option value='8-2010'>August 2010</option>
<option value='7-2010'>July 2010</option>
<option value='6-2010'>June 2010</option>
<option value='5-2010'>May 2010</option>
<option value='4-2010'>April 2010</option>
<option value='3-2010'>March 2010</option>
<option value='2-2010'>February 2010</option>
<option value='1-2010'>January 2010</option>
<option value='12-2009'>December 2009</option>
<option value='11-2009'>November 2009</option>
<option value='10-2009'>October 2009</option>
<option value='9-2009'>September 2009</option>
<option value='8-2009'>August 2009</option>
<option value='7-2009'>July 2009</option>
<option value='6-2009'>June 2009</option>
<option value='5-2009'>May 2009</option>
<option value='4-2009'>April 2009</option>
<option value='3-2009'>March 2009</option>
<option value='2-2009'>February 2009</option>
<option value='1-2009'>January 2009</option>
<option value='12-2008'>December 2008</option>
<option value='11-2008'>November 2008</option>
</select>
<select name="speaker" id="date-sort" class="sorter" onChange="document.location = this.value">
<option>Speaker</option>
<option value='mark-pavola'>Mark Pavola</option>
<option value='thomas-bush'>Thomas Bush</option>
</select>
<select name="series" id="date-sort" class="sorter" onChange="document.location = this.value">
<option>Series</option>
<option value='god-honoring-goals'>God Honoring Goals</option>
<option value='disconnect'>Disconnect to Connect</option>
<option value='who-is-this-jesus'>Who Is this Jesus?</option>
<option value='truth-about-relationships'>The Truth About Relationships</option>
<option value='a-gift-for-you'>A Gift for You</option>
<option value='anxiety-worry'>Anxiety, Worry, & Freaking Out</option>
<option value='truth-series'>The Truth Series</option>
</select>
</form>
<?php
include("**database***");
function getGet($getVariable) {
$get_list = "";
foreach ($_GET as $k => $v) {
if ($k != $getVariable) {
$get_list .= $k.'='.$v.'&';
}
}
$get_list = substr($get_list,0,-5);
return $get_list;
}
if($_GET["limit"]) {
$limit = $_GET["limit"];
} else {
$limit = 10;
}
if($_GET["pg"]) {
$pg = $_GET["pg"];
} else {
$pg = 1;
}
if($_GET["inactive"] == 1) {
$inactive = '';
} else {
$inactive = 'WHERE inactive = 0 ';
}
if ($pg == 1) {
$limit_sql = $limit;
} else {
$limit_sql = (($pg-1)*$limit) .', '.$limit;
}
if (strlen($_GET["search"])>0) {
//IF SEARCH RESULTS
$search = $_GET["search"];
$search_sql = "";
$search = explode(" ",$search);
foreach ($search as $k=>$v) {
$search_sql .= "(keywords LIKE '% $v%' OR keywords LIKE '$v%') AND ";
}
$search_sql = substr($search_sql,0,-5);
$sql_1 = "SELECT * FROM mp3s WHERE ($search_sql) ";
} else {
//IF NORMAL RESULTS
$sql_1 = "SELECT * FROM mp3s";
}
//echo $sql_1.'ORDER BY date DESC LIMIT '.$limit_sql;
if ($_GET["search"]) {
?>
<h3>Search Results for '<?=$_GET["search"]?>'</h3><br><br>
<?php
}
?>
<?php
$fetch_mp3s = mysqli_query($link, "$sql_1 ORDER BY date DESC LIMIT $limit_sql");
$i_row = 0;
while($r = mysqli_fetch_array($fetch_mp3s)) {
extract($r);
if ($i_row%2 == 0) {
echo "<tr class=\"even\">";
} else {
echo "<tr>";
}
$date = date('M j\, Y',strtotime($date));
$date2 = date('Mj\_Y',strtotime($date));
echo (" <article class='sermons'>
<header><time>$date</time>
<h3>$title</h3>
<p class='meta'><span class='author'>Speaker</span>: $speaker</p></header>
<div class='media'>
<p class='listen'>
<a href='javascript:$date2()'>Play</a></p>
<div class='download'>
<p>Download:<span class='itunes'>
<a href='http://www.baysidesuperior.org/media/database/files/force-download.php?file=$url'>MP3</a></span>
<span class='transcript'><a href='http://www.baysidesuperior.org/documents/bulletins/$date2.pdf' target='_blank'>Notes</a></span></p></div></div>
</article>
</tr>
");
$i_row++;
}
?>
<br>
<?php
## PAGINATION
$fetch_rows = mysqli_query($link, "$sql_1");
$fetch_num_rows = mysqli_num_rows($fetch_rows);
$num_of_pages = ceil($fetch_num_rows/$limit);
//echo "num of pages - $fetch_num_rows / $limit";
//echo 'Displaying: ';
$from = (($pg-1)*$limit)+1;
$last_page_remainder = $fetch_num_rows%$limit;
if ($pg == $num_of_pages) {
$to = $from + $last_page_remainder -1;
} else {
$to = $from + $limit -1;
}
echo '<div class="pagination">Page: ';
if ($pg>6) {
echo '<<';
}
for ($int = 0; $int < $num_of_pages; $int++) {
if ($pg == ($int+1)) {
$class_type = ' class="current_page"';
} elseif (($int+1)-$pg>5 || $pg-($int+1)>5) {
if ($pg<7 && $int<11) {
$class_type = "";
} else {
$class_type = ' class="no_display"';
}
} else {
$class_type = "";
}
$fj3j = getGet("pg");
echo '<a href="?'.$fj3j.'&pg='.($int+1).'"'.$class_type.'>'.($int+1).'</a> '."\n";
}
if ($pg<($num_of_pages-5)) {
echo '>>';
}
echo '</div>';
?>
