Database Question

  • Hello everyone,

    I have a question.

    I currently have WAMP installed on a system in my home office as I am trying to get a feel for it.

    I downloaded the X Theme and installed it for test as well.

    My question is simple:

    I want to have a page “Currently Borrowed”. When this is clicked on i want it to pull up a report from some backend database that will have data such as Name, Customer #, Date Borrowed , Item borrowed.

    My question is how do i make a database without messing up wordpress that no one can see except for me (the admin) so that i can work towards being able to extract all this data?

    Thanks,

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

  • Hello,

    You could use a plugin like SQL Shortcode to display the data using a shortcode.

    As far as adding a table, the simplest would be to create a table in the default database. Adding a table won’t break your WordPress installation. If you want, you can create a separate database altogether and query it.

    To restrict access to the page you could use a plugin like Restrict Content.

    Hope that helps.

    Cheers,

    Rob

    • This reply was modified 8 years, 2 months ago by robhob.
    • This reply was modified 8 years, 2 months ago by robhob. Reason: typos
    Thread Starter bmacedo

    (@bmacedo)

    So just go in via the PHP page and add a database or table anywhere I want?

    My follow up question is what if I already have a database on another server can I pull data from that?

    Yes, you can use phpMyAdmin to a database and or tables as necessary (dependant on your hosting package). If you aren’t familiar with the workings of databases, I’d recommend you make a backup before you start tinkering.

    According to the write up on the SQL Shortcode plugin page, you can link to other databases, you just have to provide all of the following shortcode attributes: user, pass, host, db. You might need to configure the database to allow remote access though.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Question’ is closed to new replies.