- b2evolution CMS Support Forums
- b2evolution Support
- General Support
- Using POST to filter DB results on custom page
1 dubird May 01, 2013 22:47
I solve one issue and another pops up. ^_^;
Version: 4.1.6
I'm trying to use a drop-down box to filter results on a custom page. I can populate the dropdown box correctly, the initial page loads with all the results it's supposed to, and the pagination works. But somehow, it's not passing the filter when it reloads the page. It gives me a search page with it saying I need to broaden my search.
http://free.dubird.net/?title=wallpapers&more=1&c=1&tb=1&pb=1
Here's what I have for the dropdown box code:
echo ("<form method=POST class=filter action=".$thisroot.">");
$result2 = mysql_query($query2) or die(mysql_error());
$dropdown = "<select name=\"filter\">";
while($row = mysql_fetch_assoc($result2)) {
$dropdown .= "\r\n<option value='{$row['series']}'>{$row['series']}</option>";
}
$dropdown .= "\r\n</select>";
echo $dropdown;
echo ("<input type=\"submit\" value=\"Filter\">");
The variable $thisroot is "http://".$_SERVER["HTTP_HOST"].$_SERVER["REQUEST_URI"]."";, which I had to do to make all the other parts work on the subdomain. I'm not sure if I just have the wrong syntax or it's something with b2evo. This does work outside b2evo: http://free.dubird.net/wallstest.php , so I'm not sure what I need to be doing to correct it.
Bump. I still can't figure this one out. ><