Results Page returning all results, not filtering based on search criteria

I just upgraded to databridge and new version of Datassist. I have two problems. First, when the search and results page are created, they both contain a link to the files for the validations. However, the validations directory is not being created. To get the pages to load I have to delete the PHP line a the top of the page for the validations.

Second, is that I can't get the results page to display the proper results from the database. When I run the search criteria all results are displayed.

I've tried the following to remedy:

$WADbSearch1_DefaultWhere = "";
if (!session_id()) session_start();
if ((isset($_GET["Search_x"]) && $_GET["Search_x"] != "")) {
$WADbSearch1 = new FilterDef;
$WADbSearch1->initializeQueryBuilder("MYSQL","1");

I tried changing search_x to search1
I've tried using POST instead of GET

Still doesn't work. Suggestions?

I've tried and unbelievably can't get the search and results page to work properly.

what Version of Data Bridge are you using?

Make sure you have version 1.0.6 installed and are using that version to create the search and results pages.

if you continue to have a problem, please post a link where I can see the problem and a copy of the pages so i can see the code.

I am using the most recent version of databridge as I just downloaded a few days ago. Enclosed below is the original code that was provided by the extension. I have tried several things to fix but no luck.

Code attached

This is the correct file for the results page

I dont see an obvious problem in the results page code, could you also send the search page please.

Here is the search page

the search form uses the GET method, but the results page is expecting the form to Use the POST method.


there are 2 possible whats to fix the problem:

1) Change the trigger code on the results page. this is what you had said you already tried. the reason it didn't work when you tried it is because you where using the wrong name for the Search submit button.

the code you say you tried:

if ((isset($_GET["Search_x"]) && $_GET["Search_x"] != "")) {

would work if the submit button where an Image element type, but in your search form, the submit button is a standard submit element type, and the name is "Search"

so the trigger code at line 11:

if ($_SERVER["REQUEST_METHOD"] == "POST") {

should be:

if ((isset($_GET["Search"]) && $_GET["Search"] != "")) {

2) the other option is to Change the method of the search form to post

I tried your suggestions again. However, the search and results page are still not communicating. I tried changing the code in line 11 using if ($_SERVER["REQUEST_METHOD"] == "POST") {

I changed the search page to POST. Did not work. The results page returned all data in database and still did not respond to the filters

Next I used the get method with both the line of code in line 11, reflecting "search" not search_x. I even tried using search_x and renaming the input button on the search page to search_x.

Still not working