Database Search Block+

[Nuclear General]

File Name: Database Search Block+

File Submitter: Nuclear General

File Submitted: 10 May 2011

File Category: Content Management

Place a working search box for any IPContent Database on any page or into any IPB template.
Demo using default media demo database here:
http://www.marchertech.com/media.html
board index non ipc page sidebar demo:
http://www.marchertech.com/board
Enjoy
3.2 Database Search Template Now included!
Documentation updated to reflect this.
Demo:
http://www.marchertech.com/test.php
3.2 file is Clearly Labeled db_search32.zip
I have decided the template bit should be a part of the new "filterbar" on top rather than a separate, duplicative bar.

here to download this file

[Marcher Technologies]

http://www.marchertech.com/test.php
second database demo, proving that even as no categories exist in this database, and the block is a categories feed of the database it performs admirably.

[Jinkler]

I've added this and am performing a test, but it doesn't work for me.

http://www.talkford.com/index.php?app=ccs&module=pages&section=pages&folder=&id=66

Search for "truro" which is the location of one of the ford dealerships, and it won't return any results.

The database I'm searching is this one:

http://www.talkford.com/index.php?app=ccs&module=pages&section=pages&folder=&id=20

What should this block be searching? Can it search fields? (thats what the Truro is)

[Marcher Technologies]

I've added this and am performing a test, but it doesn't work for me.

Search for "truro" which is the location of one of the ford dealerships, and it won't return any results.

The database I'm searching is this one:

What should this block be searching? Can it search fields? (thats what the Truro is)

thats odd, supposed to be searching the database specified in the code... ill look into why this isnt returning a result.
Did you follow the readme?, specifying the database in feed source, categories as content?
EDIT: Did some Testing, will update the download shortly with fix for non db page use with updated readme

[Marcher Technologies]

File updated, additional demo link http://www.marchertech.com/board/ 2 of them searching 2 separate databases functionally outside ipc
not absolutely certain how this would run with IPB external parse block js tags, but the revamp in methodology might work... again, not sure how that translates.
i'll go test on my neverused for squat WP install

[Jinkler]

Cheers, I'll update my page shortly once I've had lunch and report back :)

[Jinkler]

Did you upload the correct file? The timestamp on the xml file is still yesterdays, and the readme is still the same.

[Marcher Technologies]

of all th things to forget.. file replaced :whistle:

[Jinkler]

Mate, it works fine on IP pages. This is the dogs bollox, I can setup a little search page for all my custom databases :D :D :D

Thanks a lot for this Marcher :thumbsup:



I'll test it out on some non-ip.content pages with the iframe and JS, see if it works that way (will be very handy for me if it does ;) )

[Jinkler]

It works using the Embed method, but not the iframe method (i'm just placing the code directly onto a blank html page).

http://www.talkford.com/test.html

[Marcher Technologies]

0-0 it works via an external js tag, mind you only one type(object method) but 0-0 I'm kinda shocked, kewl:D

[UK Fiesta Network]

Is there any way this can search in the same manner as the main search function, ie boolean operators, keywords and so on? Also, is it possible to edit the template to be able to specify a particular field to search from a dropdown list of available fields?

Having installed this block, if I search for one word, eg springs, it will bring up all records with that word in any of the fields. However if I search for springs shocks it will only find records with that exact phrase rather than the two keywords individually, as if I had wrapped it in quotation marks.

Ideally, I would like members to be able to search in the manner they are accustomed to, and the ability to search a specific field, eg the record title.

Any help would be appreciated.

[Marcher Technologies]

Is there any way this can search in the same manner as the main search function, ie boolean operators, keywords and so on? Also, is it possible to edit the template to be able to specify a particular field to search from a dropdown list of available fields?

Having installed this block, if I search for one word, eg springs, it will bring up all records with that word in any of the fields. However if I search for springs shocks it will only find records with that exact phrase rather than the two keywords individually, as if I had wrapped it in quotation marks.

Ideally, I would like members to be able to search in the manner they are accustomed to, and the ability to search a specific field, eg the record title.

Any help would be appreciated.

try spring+shocks
I'm going to have to develop an advanced search block to do this at this time... but am loath to do so with 3.2 changes to how this works on the horizon already, seeing how this has changed the search methods completely.
To wit, i'm more focused on the 3.2 update for THIS block, which may include such capabilities.

[UK Fiesta Network]

Nope, that didn't work. So multiple word searching is pretty much dead in the water.

At the very least, is there anything I can add to the template to specify a field within the database to search, rather than within all fields? Doesn't have to be selectable, just so I can specify that this search box searches the title rather than bring up every record with the particular word in the entire body text.

[Marcher Technologies]

i think.. i think i've figured a methodology to select a field, and multiple word searching... updating file/readme shortly.
Can at least do this for you right here as its not a difficult thing... multiple word searching is being... evil.
In the Block, at the Block Filters stage on these:
Custom Filter X
Filter based on custom field. Leave blank to ignore.
Select the field(s) you want searchable placing
?
as the filter.
or Not... Wow, Agreeing this shouldnt be This Supremely difficult... throwing refunds/removing price on this as thats just unfair.

[UK Fiesta Network]

Tell me about it! :laugh:

I was setting the database up as a "neater" and more presentable alternative to having our tutorials as a list of topics in the forum. I'm now having second thoughts about that, as it seems that just leaving each one as a separate topic would be a whole lot less faffing about!

[Marcher Technologies]

typo in updated 3.2 Readme, will patch shortly:
Step 5(optional, but included for 3.2 as IPS axed it):
Visit your ACP > My Apps > IP.Content > Database Templates and browse / upload the supplied template-export.xml

Step 6: Apply it to any database you wish or copy the code within the ipsFilterBar div tag into your custom template.

[Bill Edwards]

I love this block - many, many thanks!

However I have a slight problem.......

If I am on the first page of a listing and search (for example) carters, I get:

"Your search for the term carters returned 9 results" and the nine entries are listed.

If I am on the last page of the listing and do the same search I get

"Your search for the term carters returned 9 results" BUT instead of the nine entries I get "No records found"

Any idea what I am doing wrong??

Thanks again

Bill

[Bill Edwards]

I love this block - many, many thanks!

However I have a slight problem.......

If I am on the first page of a listing and search (for example) carters, I get:

"Your search for the term carters returned 9 results" and the nine entries are listed.

If I am on the last page of the listing and do the same search I get

"Your search for the term carters returned 9 results" BUT instead of the nine entries I get "No records found"

Any idea what I am doing wrong??

Thanks again

Bill

I haven't changed anything, but there is still an issue with searching, although slightly different from above.

The search ONLY works if you are on page one, if you are on any other page you get an error.

Any help please??

Cheers

Bill

[Marcher Technologies]

looking into it.

[Bill Edwards]

looking into it.

Hi

Did you ever have a chance to look into this at all?

Cheers

Bill

[Marcher Technologies]

Hi

Did you ever have a chance to look into this at all?

Cheers

Bill

Yes, and what i found is not truly helpful... basically the search thinks... somehow, you are on page 2 of the results screen.
if there is no page 2 of results, ipb itself throws a page not found.
the only fix i can think of really is a hidden form element forcing it to page 1.

<input type="hidden" value="0" name="st" />

Should resolve the issue I think.... testing this now.

[Marcher Technologies]

Yes, and what i found is not truly helpful... basically the search thinks... somehow, you are on page 2 of the results screen.

if there is no page 2 of results, ipb itself throws a page not found.

the only fix i can think of really is a hidden form element forcing it to page 1.

<input type="hidden" value="0" name="st" />

Should resolve the issue I think.... testing this now.

which worked beautifully... also updated the templates to reflect 2.3.2 IPC standards.... db_search33.zip file has these changes.

[Alex Touchstone]

Does this work with 3.4.6?