Newbie to tables and queries

  • Resolved wanderingonion

    (@wanderingonion)


    7 years, 5 months ago

    Hi All,

    I have worked with several wordpress sites but am a newbie when it comes to mySQL and tables. I have an old MySQL database that someone created 10 years ago with a rock collection. I want to bring the database to a new wordpress site and then recreate a query form that can search the database. I have not idea how to even begin.

    Are there plugins that can help me with this? I’ve seen posts about jQuery and WP already having mySQL, but I don’t code too much and am not sure how to begin. Any suggestions. Thanks so much!

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, TablePress will not be able to help with the direct transfer of your table, as it does not support mySQL tables directly.

    Depending on the size of your database table, it could still be an option for use, however. The best way to transfer the data should then be to export the mySQL table to a CSV file, e.g. with a tool like phpMyAdmin on the server, and then import that into TablePress. This will allow you to get a table like https://tablepress.org/demo/

    Regards,
    Tobias

    Thread Starter wanderingonion

    (@wanderingonion)

    Thanks Tobias,

    The table is old and I may have to go ahead and create a new table anyway so your response is very helpful. Once I have the table created, how would you suggest creating a query form that could reference the table? Does TablePress do that? Thank you again!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    what does “query form” mean here?

    At the moment, TablePress only offers that “Search” field that you can see on the Demo page, in addition to some more search-related features that can be added by a TablePress Extension from https://tablepress.org/extensions/
    So, depending on how complex your query needs are, TablePress might not be the best choice. Instead, you could maybe think about keeping the mySQL table and just find ways to run your (possibly existing) queries against that table from within WordPress, probably with custom PHP code though.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Newbie to tables and queries’ is closed to new replies.