close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 8/04/2012 3:38 pm by msbannister373603 | Last modified 8/08/2012 4:15 pm by Jason Byrnes | 971 views | 11 replies |

msbannister373603

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?

Sign in to reply to this post

msbannister373603

Any Ideas?

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

msbannister373603

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.

Sign in to reply to this post

msbannister373603

Code attached

Sign in to reply to this post

msbannister373603

Code

This is the correct file for the results page

Attached Files
volposts_results.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

msbannister373603

Search Page

Here is the search page

Attached Files
search.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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:

php:
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:

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


should be:

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




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

Sign in to reply to this post

msbannister373603

Not Working

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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...