Using database table fields on page

  • I am new to WordPress and was wondering if someone could point me in the right direction. I want to add a table to the wordpress database and use the values from 1 row (15 – 20 fields) on a page. I will have probably have 400-500 rows of data in the table that will update monthly through an import. I think I understand how to query the database but I don’t know the best way to actually get the values on a page.

    I see mention of plugins, shortcodes, custom fields, and page templates. The pages aren’t going to be exactly the same for all 400 – 500 items from the table in the database. On one page I might use 10 fields and another I might use 15. I would like to query the record one time and then use the fields in the body of the page.

    What is the best method? I link to a tutorial or book would be great. I can research and learn, but I just need to know where to start.

    Thanks!

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    This is something that would all be contained in a plugin. On activation, use $wpdb methods to create the table. You would also create one or more page templates to display the data. To import the data, I would use the Administration Menus system to add a settings page that contains the file selection form. The form would post to a php page that would step through the file and insert the data in the table.

    You’ll find adequate information just by searching the Codex, but documentation will range from very good to extremely sparse. In some instances, even non-existent. When you feel baffled by something, a general internet search can turn up some excellent resources, YMMV. And there’s always this sub-forum, which is pretty variable also. Considering everyone involved is volunteering their time, it’s all pretty amazing actually.

Viewing 1 replies (of 1 total)
  • The topic ‘Using database table fields on page’ is closed to new replies.