[MOD] Advanced Search - for phpLD 3.2.0

**Boby** · 08-09-2007

Hello to everyone!

This is something we are going to implement in the coming version of phpLD 3.3.0 (please don't ask when it's going to be released).

It's an advanced search page, where you can select more preferences for searching through your directory.

NOTE:
If you don't get any results for a known search term, deactivate boolean search from your admin panel since it could be possible it's not enabled on your server. But you would get much better search results if it's working

Current Version: 1.0

Installation Instructions:
(are also available in the package as install.txt)

Step-1
Replace "/include/tables.php" with the file provided by this package.
If you have other changes made to that file, copy and paste the following PHP code into it:

Code:

Content visible to registered users only.

Step-2
You can either run the installer again and it will automatically create
the search table in your database according to the new "/include/tables.php" file,
or you can run the following SQL query via phpMyAdmin or phpLD's admin panel.

Code:

Content visible to registered users only.

Step-3
Replace "search.php" located in the root folder of your phpLD installation with the new file provided in this package.

Step-4
Add the file "/templates/Default/search.tpl" to your template folder.
If needed, make custom template changes to fit your theme.

Step-5
Access the advanced search page via the following URL:

Code:

Content visible to registered users only.

You can add a link on your page by adding the following HTML code:

Code:

Content visible to registered users only.

That's all

Enjoy!

Code:

Content visible to registered users only.

msolution · 08-09-2007

Thanx Boby

Will surely try this out

Regards,
M.

**bruleo** · 08-09-2007

For information....

Just installing this and for some reason when I tried the SQL in the Admin panel, I got this error:-
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE IF NOT EXISTS `PLD_SEARCH` ( `SEARCHID` int(11) NOT NULL auto' at line 1

However, it worked fine in phpMyAdmin.

Bruce.

**Boby** · 08-09-2007

guess you have to remove the ";" for AdoDB

**bruleo** · 08-09-2007

No problems at all. Got it installed and working in less than 5 minutes!!

Came as perfect timing as I was just installing PHPLD into my site at awayaway.com and was messing around with the search box and template designs just a short while ago. Should all be live in a day or two.

Bruce.

MyWebSearches · 08-10-2007

Is there a demo? Or Can some one post your directory using advanced search?

Thanks!

**bruleo** · 08-10-2007

Ok.... Here is where I have it installed....

http://www.awayaway.com/search.php?type=advanced

Be aware that this version of the site is not yet live and many of the functions and links do not currently work. DO NOT submit any links as they will be removed.

Site should be fully operational in a day or two.

Bruce.

David · 08-10-2007

Nice, thanks for posting a demo.

pragent · 08-10-2007

Thank you Boby .... this MOD is perfect

David · 08-10-2007

I just installed it too.
Here is my demo:
http://www.directhoo.com/search.php?type=advanced

moonswamp · 08-10-2007

great ,thx very much

daisukey · 08-10-2007

Hi guys im stuck at step2 where i put the query in myphpadmin.

It says 'You have to choose at least one column to display'

**Boby** · 08-10-2007

Code:

Content visible to registered users only.

Open the database where you have phpLD installed and somewhere on top you'll have a button "SQL". Post the query in that textarea and run it.
If you're not confortable with that, just copy the new /include/tables.php file and run the installer again. It will do that SQL query for you

daisukey · 08-10-2007

Awesome bobby. cheers. its working now.

Demo:
http://www.creativefx.org/search.php?type=advanced

PL_90 · 08-10-2007

Wow... Boby.. Thanks.. super!

regg · 08-10-2007

GREAT Mod. Thank you Boby... For this Mod i have searched long…

Please addet this to phpLD 3.3/3.4

David · 08-10-2007

Code:

Content visible to registered users only.

Yes, we will do this.

Simon · 08-10-2007

Thanks for releasing this, just what I need.

regg · 08-10-2007

Code:

Content visible to registered users only.

Cool

I have got a Question:

i have got 3 DB Fields:

Like this:
TYP = no.jpg
TYP1 = ppc.jpg
TYP2 = click.jpg

no.jpg shwos a place holder
click.jpg shwos a *Pay-Per-Click picture
ppl shwos a *Pay-Per-Lead pictue
ppc.jpg shows a *Pay-Per-Sale picture

The content of the Datebase are only no.jpg,click.jpg and so on...

Can i add this to the "Find results with"???

Thanks,
regg

smub · 08-10-2007

this is an awesome mod .....

One thing i didn't get in the search.tpl file

why is the reset button have a transparent background ??? because at first when i uploaded it it showed me a transparent button ... with nothing on it ... Even though i fixed it just a thought you should have

Here is my demo

{link no longer in service}

hehe yes it is seo-friendly.

08-09-2007	#2
msolution Supporter Join Date: Jun 2007 Posts: 140	Thanx Boby Will surely try this out Regards, M. __________________ Congratulations to the Winner Linkernel.com . of the Dir.vc: Web Directory Competition

08-09-2007	#3
bruleo Supporter Moderator Join Date: May 2007 Location: Lithuania - 90% / United Kingdom - 10% Posts: 2,923	For information.... Just installing this and for some reason when I tried the SQL in the Admin panel, I got this error:- #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE IF NOT EXISTS `PLD_SEARCH` ( `SEARCHID` int(11) NOT NULL auto' at line 1 However, it worked fine in phpMyAdmin. Bruce. __________________ *:: WVIS Directory :: GateUK :: u-Hits Directory :: sportindexer ::* "Anything is possible, except anything impossible" = = = MY PHPLD MODS = = =

08-09-2007	#4
Boby Supporter Moderator Join Date: Dec 2005 Location: Cluj-Napoca/Sighisoara (Romania) Posts: 4,524	guess you have to remove the ";" for AdoDB __________________ *Please do not* contact me for support on phpLD!! I can hardly find time to give support for my own mods, for anything else I won't.** My phpLD Mods I am not a phpLD staff member, so please do not ask me to grant permissions, sales stuff, for access to the private supporter forums or phpLD download area. Before you report your problems, make sure it happens with the default package and not your highly modified code. Don't forget to use the search feature and do not bump threads to soon (allow at least 24h).

08-09-2007	#5
bruleo Supporter Moderator Join Date: May 2007 Location: Lithuania - 90% / United Kingdom - 10% Posts: 2,923	No problems at all. Got it installed and working in less than 5 minutes!! Came as perfect timing as I was just installing PHPLD into my site at awayaway.com and was messing around with the search box and template designs just a short while ago. Should all be live in a day or two. Bruce. __________________ *:: WVIS Directory :: GateUK :: u-Hits Directory :: sportindexer ::* "Anything is possible, except anything impossible" = = = MY PHPLD MODS = = =

08-10-2007	#6
MyWebSearches Supporter Join Date: Sep 2006 Posts: 568	Is there a demo? Or Can some one post your directory using advanced search? Thanks! __________________ Reverse Directory = Directory of Directories (FREE) My web searches (FREE)\| Directorio Latino\|

08-10-2007	#8
David Administrator *phpLD Administrator* Supporter Join Date: Jan 2005 Posts: 12,325	Nice, thanks for posting a demo. __________________ Helpful Links: templates supporters forum █ New phpLD User? Start here █ Quality Guidelines for Directories █ Recommended Host

08-10-2007	#9
pragent Supporter Moderator Join Date: Feb 2006 Location: Germany - Berlin Posts: 2,414	Thank you Boby .... this MOD is perfect __________________ Deutscher Support seit 2005 (Deutschland,Österreich,Schweiz) UDL Intermedia Group www.UDL-Intermedia.com Meine phpLD4 Projekte: www.Anbieterverzeichnis.info www.RSS-Bookmark-Service.com www.Schlaglochmelder.de

08-10-2007	#11
moonswamp Join Date: Mar 2007 Posts: 54	great ,thx very much __________________ {sig link was not working when checked}

08-10-2007	#12
daisukey Join Date: Jun 2007 Posts: 54	Hi guys im stuck at step2 where i put the query in myphpadmin. It says 'You have to choose at least one column to display'

08-10-2007	#13
Boby Supporter Moderator Join Date: Dec 2005 Location: Cluj-Napoca/Sighisoara (Romania) Posts: 4,524	Code: Content visible to registered users only. Open the database where you have phpLD installed and somewhere on top you'll have a button "SQL". Post the query in that textarea and run it. If you're not confortable with that, just copy the new /include/tables.php file and run the installer again. It will do that SQL query for you __________________ *Please do not* contact me for support on phpLD!! I can hardly find time to give support for my own mods, for anything else I won't.** My phpLD Mods I am not a phpLD staff member, so please do not ask me to grant permissions, sales stuff, for access to the private supporter forums or phpLD download area. Before you report your problems, make sure it happens with the default package and not your highly modified code. Don't forget to use the search feature and do not bump threads to soon (allow at least 24h).

08-10-2007	#15
PL_90 Join Date: Jan 2007 Location: Germany / Poland Posts: 954	Wow... Boby.. Thanks.. super!

08-10-2007	#16
regg Supporter Moderator Join Date: Apr 2006 Posts: 1,723	GREAT Mod. Thank you Boby... For this Mod i have searched long… Please addet this to phpLD 3.3/3.4 __________________ Jetzt Neu: Immer aktuelle Gutscheine: http://www.gutscheinbase.de --- phpLD Services German ---

08-10-2007	#18
Simon Join Date: Jun 2006 Location: UK Posts: 107	Thanks for releasing this, just what I need. __________________ OIOpublisher Ad Manager

08-10-2007	#20
smub Join Date: Jul 2006 Location: Somewhere in phpLD ville Posts: 393	this is an awesome mod ..... One thing i didn't get in the search.tpl file why is the reset button have a transparent background ??? because at first when i uploaded it it showed me a transparent button ... with nothing on it ... Even though i fixed it just a thought you should have Here is my demo {link no longer in service} hehe yes it is seo-friendly. Last edited by David; 05-31-2009 at 02:38 PM.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)