Generate custom form from an access database

  • ccseeggie

    (@ccseeggie)


    8 years, 3 months ago

    New to wordpress and php. I used classic asp years ago.

    I have an access database from a catering company that has different tables for things like entrees and desserts, etc…

    Again years ago, in classic asp I created a form that was generated from this database. So when someone wanted to create a custom menu for an event they would go through 9 pages of menu items and then the form would be submitted at the end.

    How can I remake that same form using wordpress and php?

Viewing 1 replies (of 1 total)
  • RossMitchell

    (@rossmitchell)

    8 years, 3 months ago

    This is what I would do:
    – in your access database export the table contents in CSV format, also make notes of the table layouts.
    – create a localhost install for development and testing, so much faster this way, look at http://www.ampps.com/ this is a one stop shop for both the core webserver and lots of good tools and addons.
    – in phpmyadmin which is a SQL interactive browser tool create tables that are equivalent to access. Import your CSV data.
    – create a plugin that provides shortcodes that use your custom tables, the rest of WordPress will never know about your tables. Using shortcodes saves you from creating custom page templates in your (child) theme.

    Useful docs are:
    database access: http://codex.ww.wp.xz.cn/Class_Reference/wpdb
    shortcodes: https://codex.ww.wp.xz.cn/Shortcode_API
    example plugin: https://ww.wp.xz.cn/plugins/wp-csv-to-database/
    php checker: https://www.piliapp.com/php-syntax-check/

    I started with the example plugin, it showed me lots of examples of how to do forms / html fields / database actions. Since then I have developed several apps hosted in WordPress.

Viewing 1 replies (of 1 total)

The topic ‘Generate custom form from an access database’ is closed to new replies.