Database front end (Pre Sales Enquiry)

  • Resolved slimat

    (@slimat)


    12 months ago

    Hi,

    I am looking for a solution for my database.

    I have about 2.5m lines of data stored in a SQL database. This data is deleted hourly and repopulated directly into the SQL database from a PHP script. It contains supplier part-numbers, descriptions, costs etc. In total I have about 10 users who need to read-only access this data. As well as the main database there are a couple of other tables which are private and only used by myself.

    At the moment I have a bespoke PHP frontend which resembles an Excel spreadsheet and is a bit dated by todays standards.

    I was wondering whether Formidable Forms would be a suitable candidate to rebuild this solution in a WordPress site?

    Any thoughts would be gratefully received.

    Thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Njones35

    (@njones35)

    Hi @slimat

    Formidable used its own custom database tables and does not have access to the WordPress database in general, so while it may be possible you would need modify how/where data is populated into your database, and this would likely be a complex task.

    I would recommend small scale testing with sample data on a staging site to see if you can make it work the way you want.

    Please let me know if you have any other questions.

    Best,
    Nathanael.

    Thread Starter slimat

    (@slimat)

    Hi @njones35

    Thanks for the feedback… it sounds as though it will be beyond my capabilities then… I, wrongly, thought Formidable would access tables from the back end SQL database. I will set up a dummy site and have a play when I get some time… thanks for your help.

    Formidable can access any table in the WordPress database. It requires custom code to use the global $wpdb object.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database front end (Pre Sales Enquiry)’ is closed to new replies.