WordPress.org

Ready to get started?Download WordPress

Forums

ABASE
Hidden/Appearing Query Rows (8 posts)

  1. jstevenot
    Member
    Posted 9 months ago #

    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/

  2. rollbrettfahrer77
    Member
    Posted 8 months ago #

    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?

  3. rollbrettfahrer77
    Member
    Posted 8 months ago #

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

  4. BioteconDiagnostics
    Member
    Posted 7 months ago #

    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"]

  5. jetwashphotos
    Member
    Posted 7 months ago #

    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.

  6. rzharding
    Member
    Posted 7 months ago #

    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

  7. jetwashphotos
    Member
    Posted 7 months ago #

    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

  8. rzharding
    Member
    Posted 7 months ago #

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

    Richard

Reply

You must log in to post.

About this Plugin

About this Topic