How do I query the table for individual datum?

  • Resolved ltsignups

    (@ltsignups)


    9 years, 3 months ago

    Hi, I wanted to ask how I can query the table for a specific piece of datum? Let’s say for example I have one column that I use as the key and I know what the key is already, but I need to find something from that same row in a different column.

    I don’t imagine this would be done in any shortcode sort of fashion, I’m good with PHP. I just don’t know the structure and such that I should be using.

    https://www.ads-software.com/plugins/data-storage/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author ghazale

    (@ghazale)

    Hi @ltsignups

    Thank you for getting in touch!
    If your in intention is to search something in your data, I recommend you use Custom Searchable Data Entry system plugin which will do it for you in no time. That plugin is also developed by me and if you had any questions regarding that plugin you are always welcome to come back to me and ask your questions and concerns.

    If your intention is to find that data in your database by yourself, then you should know the structure that I’ve used to code it. You can look at the main PHP file (ghazale-data-storage-main.php), or look at your related database tables to get more information about the table structure that I’m using.
    Let me explain a bit to give you a brief insight about it: I don’t limit the tables to have fixed number of columns; and instead, I’ve defined their type and then I used their ID’s and foreign keys to communicate with the tables, then I’ve coded the backend- admin page- side of the plugin in such a way that it can understand where the column starts and where it ends (when there’s actually no physical columns in a way that we know). Now this is the reason that you can virtually have unlimited number of tables with unlimited number of columns in a very efficient way, memory-wise and query-wise.

    If there’s still anything that I can help you with, feel free to contact me anytime:)

    Cheers,
    Ghazale

    Thread Starter ltsignups

    (@ltsignups)

    Hi Ghazale,

    Now that I’ve opened up your file, I appreciate how (relatively) light your plugin is. I think I understand what I need now. Thanks.

    LT

    Hi Ghazale,

    I’m enjoying your plugin. It was exactly what I was looking for.

    When I click on the button, “Download Table in CSV format” where does this data go? I’m not finding it in my downloads folder. If I use your Custom Searchable Data Entry system” plugin, will it know where the data is stored since I’m not seeming to find it online anywhere.

    Thanks,
    Tim

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘How do I query the table for individual datum?’ is closed to new replies.