Building a form with MySQL fields.

  • I see there has been some discussion about populating a form with fields pulled from MySQL tables. I understand Report Builder is in the works but I wonder if anyone has used Form Maker? The premium version has the option to create a form and do just that.

    I’m not looking to display table rows and columns in the application I’m working on. I’d like to display one record at a time, on a page, with the ability to add, edit and delete. Doable, or is there a better option?

    • This topic was modified 3 years, 8 months ago by artmuns.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Art,

    That would be the Report Builder. But it is not yet available. Sorry!

    As an alternative you might create your own page with the Code Manager. You could add a PHP Shortcode and connect to your database using WP Data Access classes to show your data.

    To connect to a database, you can use class WPDADB like this:
    $wpdadb = WPDADB::get_db_connection( $schema_name );
    $rows = $wpdadb->get_results( $query, ‘ARRAY_A’ );

    Where $schema_name contains a local schema name or a remote database connection name and $query contains your select statement. You can use $rows to build your output.

    Does this help?
    Peter

    Thread Starter artmuns

    (@artmuns)

    Thanks Peter, I’m not much of a code writer but will give it a try.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Building a form with MySQL fields.’ is closed to new replies.