Title: SQL Table with clickable rows
Last modified: March 15, 2020

---

# SQL Table with clickable rows

 *  [jonuk80](https://wordpress.org/support/users/jonuk80/)
 * (@jonuk80)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/)
 * 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](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Developing with WordPress
      topic

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [Carike](https://wordpress.org/support/users/carike/)
 * (@carike)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/#post-12546127)
 * 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](https://wordpress.org/support/users/jonuk80/)
 * (@jonuk80)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/#post-12546168)
 * 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](https://wordpress.org/support/users/carike/)
 * (@carike)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/#post-12546534)
 * 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](https://wordpress.org/support/users/jonuk80/)
 * (@jonuk80)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/#post-12546560)
 * 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](https://wordpress.org/support/users/jonuk80/).

Viewing 4 replies - 1 through 4 (of 4 total)

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [jonuk80](https://wordpress.org/support/users/jonuk80/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/sql-table-with-clickable-rows/#post-12546560)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics