Title: Automatically dynamic pages from external SQL product database
Last modified: March 23, 2022

---

# Automatically dynamic pages from external SQL product database

 *  [victorschellens](https://wordpress.org/support/users/victorschellens/)
 * (@victorschellens)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/automatically-dynamic-pages-from-external-sql-product-database/)
 * Hello
 * Is it possible within WordPress to automatically create dynamic pages based on
   a local product database? This database is on a local server here in our company
   and is SQL. We want to renew our outdated website but keep the existing work 
   structure and database.
 * Some more context and explanation:
 * We currently have a website that acts more like an online catalogue for our products(
   vebim.com). Since we only work with quotation requests and no real online sales,
   it is not a fully-fledged webshop, so we prefer to call it an online catalogue.
   Now, our website is still written in ASP.NET and is rather outdated, and we ourselves
   want to start focusing on content: blogs, tips and tricks, testimonials, videos,
   buying guides, etc. We are therefore looking for a CMS that can meet our requirements.
   Because, the product pages are automatically generated via our local SQL server.
   Our entire inventory is entered on this via Access. Every night, the website 
   is synchronised with our server and our products are automatically placed on 
   our website via MySQL.
 * But please note that our quotation system also works via this server. When visitors
   request a quote for one or more machines (our products) on the website, a list
   is automatically sent to our Access interface, where all information is filled
   in automatically in predefined fields, the product info is retrieved from the
   server and our employees only have to assign a price and additional costs and
   click send. As a result, a graphically pleasing e-mail is automatically drawn
   up and sent with PDFs of the machines in question attached. The process is thus
   fairly well automated and ensures a very fast processing of quotations. So we
   don’t want to move away from this quickly. We therefore realise that it is no
   child’s play to integrate this into a CMS or to integrate a CMS into our existing
   system/website. However, renewal and modernisation is necessary! Therefore, my
   question, is this possible in WordPress? What is the best answer to this? I am
   looking forward to your suggestions!
 * Thanks in advance!
 * _[ [Signature deleted](https://wordpress.org/support/guidelines/#do-not-spam)]_
    -  This topic was modified 4 years, 3 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: wMoved to Fixing WordPress, this is not a Requests and Feedback topic
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fautomatically-dynamic-pages-from-external-sql-product-database%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/automatically-dynamic-pages-from-external-sql-product-database/#post-15488473)
 * If the WP server is able to connect to the DB server and the DB is mySQL compatible,
   then data can be queried and displayed on a WP page. WP connects to its own DB
   using the $wpdb global object of class `wpdb`. You can use this class to instantiate
   a different object that connects elsewhere. Class methods can then be used to
   query this other DB.
 * This would most likely all need to be custom coded, but it is certainly feasible
   within the WP environment. For the record, we could query non-mySQL DBs as well,
   it’s just that it would involve native PHP functions since `wpdb` class is mySQL
   specific.

Viewing 1 replies (of 1 total)

The topic ‘Automatically dynamic pages from external SQL product database’ is closed
to new replies.

## Tags

 * [automation](https://wordpress.org/support/topic-tag/automation/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/automatically-dynamic-pages-from-external-sql-product-database/#post-15488473)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics