[Plugin: custom tables] Search database without seeing table, only results

Hi Aprie

Yes you can do that with multiple ways. The easiest one: With a PHP Plugin as example you could do the the table with the IF Shorttag like:
[if field="<?=$_GET['s']?>" check="!=" var=""][wcttable id="..."][/if]

That makes nothing else then if a searchtag is enered ( not equal nothing) then if shows the table and it content.

Regards

Where does this go? This is for your plugin right?

[if field="<?=$_GET['s']?>" check="==" var=""][wctable id="4"][/if]

this is what I’m using… it seems to hide only the text, the table is still there and when clicking on a row the data still reveals itself.

More importantly,

field=”<?=$_GET[‘s’]?>” this string grabs the query/search/keyword

check=”==” What is this string doing?

var=”” Not sure here either.

Actually once logged out from admin, the rows are not viewable. ??

ok, although the above script hides the table(text) at first, when searching it doesn’t show the results(text) but it is finding them. When I search for something outside my “zip” field it displays the normal “no entries found”

below is what I am using.

[if field="zip" check="==" var="" else=""][wctable id="4"][/if]

should there be another IF Shorttag to display the table based on the search?

thanks

hm..

[if field="<?=$_GET['s']?>" check="!=" var="" else=""][wctable id="4"][/if]

That should be the correct code!
Try it.

The field check var will do that:

$_GET[‘s’] != “” means -> if Search unequal nothing, then show the table. == means, when nothing searched, then show. So change it to !=.

When I use that code this displays after the search, before the table.
?>" check="!=" var="" else=""][wctable id="4"]
and this displays with nothing searched:
?>" check="!=" var="" else=""][wctable id="4"]?>" check="!=" var="" else=""][wctable id="4"]

Here are my variables/ My table setup is the following:

Search for Neighborhoods in your area!
[wctsearch felder="zip"]

<< I only want to search the “zip” field in the DB.

In the next box your code
[if field="<?=$_GET['s']?>" check="!=" var="" else=""][wctable id="4"][/if]

Maybe give me your testing variables including what you put on the wordpress page? using the demo DB

That the upper code work proberly, you need to have a PHP Plugin installed!
Install PHP Exec as example.

[wctsearch felder="zip"] is correct.

That plug-in hasn’t been working with 3.2.1

I’ve been using “Allow PHP in posts and pages”
with all the above, still doesn’t work.

I dont know this plugin.

Otherwise I will need to look onto the page and how to solve it.
Send me a Support request from the plugin with all details and I will have a look.

Regards

Stefan, I sent the request a day or so ago.

I’ve gone ahead and moved your plugin to our new active test site.
https://www.neighborpro.com/?page_id=59

Still hoping the table can be hidden though ??

I will need then to have a look in detail what you need.

Send me a support request from the plugin and attach a login to the WP installation for me to have a look.

If I cannot solve it in your installation, I could add a code into the plugin or the next version to make it easier for the next ones.

Not received any mail from you. Perhaps your wordpress server configuration is wrong for mails.

Send me one manual to stefan wuk ch.

Sent the email, reply if you received it.

thanks

Adding the Code below to a page or Article working like charm with the PHP-Exec Plugin:

[wctsearch]<?php
if ($_GET['wcts'] != '') {
echo do_shortcode("[wctable id=\"1\"]");
}
?>

First adds the search and 2nd if the search is set displays the table.

If you have premium function, the wordpress standardsearch will also work, if you add this code:

[wctsearch]<?php
if ($_GET['wcts'] != '' OR $_GET['s'] != '') {
echo do_shortcode("[wctable id=\"1\"]");
}
?>

and then the [wctsearch] Tag is optional which you dont need to add if you dont want.

Regards

Stefan