insertion of data on website to SQL databases

  • misbahkhwaja

    (@misbahkhwaja)


    5 years, 1 month ago

    Hi, I’m new to WordPress. I’m working on a project in which I’ve to insert and maintain data into SQL databases through my web portal. Is there any method or plugin available for this purpose? It’s more like Data Entry type web portal and I’ve to store customers details in a database table (MySQL or MSSQL). please someone explain me.

Viewing 3 replies - 1 through 3 (of 3 total)
  • stirrell42

    (@stirrell42)

    5 years, 1 month ago

    There are quite a few ways you could go about this. Most of the solutions will likely be commercial products. Something like Gravity Forms would allow you to create forms and store entries. I’d also recommend looking into Advanced Custom Fields and Custom Post Type UI. These two plugins would allow you to create post types for the different types of information you need to store with the custom fields needed for that information.

    I hope this gives you a couple avenues to explore.

    RossMitchell

    (@rossmitchell)

    5 years, 1 month ago

    I have done this many times on different projects.
    Other approaches are:
    – Add custom page templates to your theme, in these you can write your own PHP code, populate forms and put templates behind submit buttons to update databases. OR use AJAX to stream updates to database tables.
    – Write a plugin that registers shortcodes. The shortcodes do what was described above.
    OR combinations of the two.
    I found this plugin helpful in developing my ideas:
    https://wordpress.org/plugins/wp-csv-to-database/

    • This reply was modified 5 years, 1 month ago by RossMitchell.
    Moderator bcworkz

    (@bcworkz)

    5 years, 1 month ago

    Consider how the information will be used when deciding how to save it. Form plugins typically save data in existing meta data tables. If these become quite large and you need to make frequent complex queries of the data, the meta table schema will not work very efficiently and it may make more sense to keep the data in a custom table. It’ll take a lot more development work, so don’t go there unless there’s a need. For a lot of sites the meta data table schema will work fine.

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

The topic ‘insertion of data on website to SQL databases’ is closed to new replies.