WordPress.org

Support

Support » Plugins and Hacks » ABASE » Hidden/Appearing Query Rows

Hidden/Appearing Query Rows

  • jstevenot

    @jstevenot

    I was wondering if there was a way to take the table and hide it until someone did a query/search?

    I have a data set that is quite large and it would be easier if the information just “appeared” on the screen after the user put in their searchable information.

    Thanks.

    http://wordpress.org/plugins/abase/

Viewing 7 replies - 1 through 7 (of 7 total)
  • You could output the results on an extra page by adding an url parameter in form=”…”

    [abase form="1,search,/results" table="employees" columns="first_name,last_name$Search Employees" elements="first_name,last_name"]

    then on the /results page

    [abase table="employees" columns="first_name,last_name" ack="green"]

    BUT the whole data set would still be viewable to the clever user when he goes directly to /results.

    Any ideas for a better solution?

    Kind of solved this by adding limit=”1″ on the results page.

    I found a solution.
    In mySQL I created 3 columns: ID, product and URL

    ID Product Url
    1 let it empty let it empty
    2 Product-1 URL-1
    3 Product-2 URL-2
    4 Product-3 URL-3
    5 Product-4 URL-4

    If you would write limit=”1″, then it would be the list preview empty.

    [abase table=”TABLE” columns=”url” alink=”url,../../product/,url,’_blank'” notitle=”1″ limit=”1″]

    Hello,

    Newbie to Abase, some sql experience. I have a similar question. I would like the search box to appear on page opening, but the table preview is taking too long. I have 70,000+ rows in this table. Here is my current ABASE query:

    [abase form=”1,search” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]

    [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]

    I have 1 million+ in another table, so I would really like some assistance.

    Try something like:

    [abase form=”1,search, http://XXXXX/testing-2” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]

    On another page testing-2, place

    [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]

    Richard Harding

    Hello Richard,

    That is perfect. Thanks. What I have done is place: [abase form=”1,search, http://XXXXX/testing-2” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”] on the testing

    and on testing-2, I have place both shortcodes [abase form=”1,search, http://XXXXX/testing-2” table=”AIRLOG” columns=”OPERATOR,REG$Search AIRLOG” elements=”OPERATOR,REG”]

    and [abase table=”AIRLOG” columns=”OPERATOR,REG,FULLTYPE,MSN,AIR,DATE,NOTES,EVENT,FLIGHT,MAKE” ack=”green”]

    This way the search form is always available. No going back and forth.

    Thanks again,

    Stephen

    Wonderful – and it is a great idea to place the search form on the second page. It makes it easier to use.

    Richard

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Hidden/Appearing Query Rows’ is closed to new replies.
Skip to toolbar