SQL Table with clickable rows

  • jonuk80

    (@jonuk80)


    6 years, 1 month ago

    Hi everyone. I’m having a bit of trouble finding a plugin that works for what I need.

    I’ve set up a client login site, which shows them their projects in a table once logged in. However, I would like the option for a row to be clicked and to take the user to a page which contains more details about the project they just clicked. All of the information is sat in a DB and the tables/information is queried via SQL.

    Is this possible, or is there a suitable plugin? I have looked but I’m struggling to find anything. Or, is there a clever bit of code/JS I can use?

    Many thanks.

    • This topic was modified 6 years, 1 month ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic
Viewing 4 replies - 1 through 4 (of 4 total)
  • Carike

    (@carike)

    6 years, 1 month ago

    Anything is possible 🙂

    I do not think that you are likely to find a plugin that does exactly what you have in mind in the free repository though.
    Plugins that have access to SQL is considered a very high risk in terms of security and there aren’t many around.
    I think you would need to write some custom code / extend an existing plugin.
    Please take all the necessary precautions with regards to validation, sanitation and escaping if you go that route.
    Please don’t use JavaScript to do the validation / sanitation.

    Thread Starter jonuk80

    (@jonuk80)

    6 years, 1 month ago

    Thanks carike. 🙂 Okay – I won’t use JS for validation/santiation.

    My best find so far is wpDataTables, which I’ve purchased. But it doesn’t quite do what I need. However I wouldn’t know where to begin custom coding it.

    The only alternative is I try to write my own php, but that is also far beyond the realms of my little brain!

    Thing is, I know it’s possible…I just don’t know how!

    Carike

    (@carike)

    6 years, 1 month ago

    A good place to start is to contact wpDataTable’s via their official support channel.
    It is possible that they have a hook you may be able to use.

    While the forum volunteers here are happy to point people in the right direction, custom development is beyond the help we provide, unfortunately.

    That having been said, I am wondering why you don’t just add a URL field (column) to the table with a link to each project status page.

    Thread Starter jonuk80

    (@jonuk80)

    6 years, 1 month ago

    I will investigate with wpDataTable, and that’s okay – I fully understand!!

    The reason I haven’t done that (although maybe I’m making a blindingly stupid mistake here), is that I don’t want to have to make an individual page for every single project.

    I was just hoping to have one page that could fetch the data for every new project where necessary. i.e. so there’s a master page, then data is grabbed via SQL to fill that page with information.

    Please tell me I’ve missed something really obvious carike 🙂

    • This reply was modified 6 years, 1 month ago by jonuk80.
Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘SQL Table with clickable rows’ is closed to new replies.