Nested MySQL DBs and User Access

Hello All,

I run WordPress for a non profit Community Band. Our music library is in an MS Access DB. I have been wanting to retire the MS Access DB file and put it on line. I found a driver to upload all my tables and data to a MySQL DB on our web server, I’m able to edit the MS Access file then upload as I learn and build the on line version. I have to run a few queries to replace some of the ways Access stores data but other than that its working well.

I chose to not build a plug in because I need to learn SQL from bottom up and not crash the site. I have the hang of queries, I only have one more problem to fix and add pagination then I am ready to start learning how to write the code to edit and add stuff.

I want to use the WP users to restrict access depending on user level. I use a couple plug ins with the WP to accomplish this in my regular WP pages but I can only find the code to use on my library page to check to see if a user is logged on or not. Is this possible? If so can someone please help or give me a link to the codex or a tutorial?

Music Library:
https://jhcband.org/wordpress/jhcb-mdb/musiclibrary.php

Basic Structure of my Library Pages

WordPress Package
define(‘WP_USE_THEMES’, false);
WP blog-header
—Connect to Music Library DB
—–all my stuff
—-Music Library Footer
WP Footer

Any help or direction is greatly appreciated,
Thank You
Julie