Connection to a SQL database

  • Resolved c176613

    (@c176613)


    4 years, 7 months ago

    Hello Tobias,

    Your plugin is exactly what I need but…
    I have an SQL database of my club members and I would like to display them in a table format like your plugin do. But it would be easier if I could query the database directly without having to export the informations to a CSV file each time I make changes in the database.

    Thank you for your answer.
    Best regards
    Pascal

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 7 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    I see what you mean, but unfortunately, I’ll have to disappoint you here. TablePress does not have a feature to connect a SQL database table directly, and I don’t have plans to add one. Sorry for not having better news here.

    Regards,
    Tobias

    Thread Starter c176613

    (@c176613)

    4 years, 7 months ago

    Thank you for your answer Tobias. I understand, no problem.

    I’m looking for such a plugin on Internet but didn’t find one doing exactly what yours is doing. So maybe should you plan to add such one 🙂

    Best regards
    Pascal

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 7 months ago

    Hi,

    I’m also not aware of a plugin, but given that most people who use SQL queries need a lot of customization, that’s not really a surprise, I think 🙂

    Best wishes,
    Tobias

    peterhuckle

    (@peterhuckle)

    4 years, 6 months ago

    Hi Tobias

    I have the same need – I have a plugin that lets you vote for pictures in a gallery and I would love to be able to simply list, filter and sort the votes. As the votes come in all the time, it isn’t possible to copy the mysql table.

    I’m currently giving the admin for the website access to phpMyAdmin but it’s really much too complicated for them to use on a day to day basis.

    Best wishes

    Peter

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 6 months ago

    Hi Peter,

    thanks for your feedback on this!
    If your need is “just” the filtering, sorting, etc., and not so much the data entry, I would recommend to use custom PHP code to query the SQL data, generate an HTML table from the data, and then use the external DataTables JavaScript library from https://datatables.net/ to add the features to that table. That’s also what TablePress uses.

    Regards,
    Tobias

    peterhuckle

    (@peterhuckle)

    4 years, 6 months ago

    Thanks Tobias – yes it’s a really simple thing that I want to do, but just didn’t want to reinvent the wheel – many thanks for the suggestion – I’ll give it a go.

    Best wishes

    Peter

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    4 years, 6 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

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

The topic ‘Connection to a SQL database’ is closed to new replies.