Need Direction – database update.

  • I have a SQL database that contains tables for members and another for leagues. I want to link the two together by asking the user to select a member and a league. Each member can be in one league.

    The member table has a field for the league ID.

    I’m not sure how to go about putting this into wordpress. I can populate dropdowns for both members and leagues, but I’m perplexed what to do when the user selects from the two dropdowns. I’d prefer to stay within wordpress for styling reasons.

    Do I put form on the page and then go to a static (non-wordpress) to process the form? If so how do I style it and then get back to my site.

    I could really use some direction.

Viewing 1 replies (of 1 total)

  • I would create an empty Page and a template to display and process the Page. Here is some sample code that shows the processing necessary: https://wordpress.mcdspot.com/2012/09/21/simple-form-to-select-a-category-and-sort-order/

    Here are the basic steps in the process:

    1. Set up any default values needed.
    2. Display the page header and start the content area.
    3. Get any data from a previous display of the form.
    4. Set up any other data needed for the form.
    5. Display the current Page and save the permalink.
    6. Set up the query parameters and issue the query.
    7. Show the form.
    8. Handle the pagination.
    9. Show the current selection of records.
    10. Finish the page and show the footer.
Viewing 1 replies (of 1 total)
  • The topic ‘Need Direction – database update.’ is closed to new replies.

Tags