Title: Database Question
Last modified: September 12, 2016

---

# Database Question

 *  [bmacedo](https://wordpress.org/support/users/bmacedo/)
 * (@bmacedo)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-question-17/)
 * 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)

 *  [robhob](https://wordpress.org/support/users/robhob/)
 * (@robhob)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-question-17/#post-8175017)
 * Hello,
 * You could use a plugin like [SQL Shortcode](https://wordpress.org/plugins/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](https://wordpress.org/plugins/restrict-content/).
 * Hope that helps.
 * Cheers,
 * Rob
    -  This reply was modified 9 years, 8 months ago by [robhob](https://wordpress.org/support/users/robhob/).
    -  This reply was modified 9 years, 8 months ago by [robhob](https://wordpress.org/support/users/robhob/).
      Reason: typos
 *  Thread Starter [bmacedo](https://wordpress.org/support/users/bmacedo/)
 * (@bmacedo)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-question-17/#post-8178866)
 * 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?
 *  [robhob](https://wordpress.org/support/users/robhob/)
 * (@robhob)
 * [9 years, 8 months ago](https://wordpress.org/support/topic/database-question-17/#post-8179485)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [robhob](https://wordpress.org/support/users/robhob/)
 * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/database-question-17/#post-8179485)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics