Displaying data from multiple databases on a webpage

I am attempting to create an information screen so that people can have a quick glance at it and be able to read the information from it with ease, this entails displaying certain pieces of data from different database tables in one database. Possibly 4 or 5 different tables. these will be then be displayed in a table on the web page for people to see.

What would you recommend is the best way? i could just use a select statement for every piece but if I am taking 3 bits of data from one table and 4 bits from another, surely there is an easier way to gather this data and display it?

Answers


If the data is truly in entirely separate SQL databases, then you will have to connect to each one, run your query, and disconnect. You can compile all the data using PHP and display it to the user.

If you meant the data is in separate database tables (not separate databases) then you can probably compile one query to pull it all -- if the data is related to each other -- or run the 4 or 5 queries needed to pull that data.

You will need to be more specific and share code if you want further help.


Need Your Help

Rails 4: jquery-turbolinks causing "Uncaught TypeError: Cannot read property 'length' of undefined"

javascript ruby-on-rails ruby-on-rails-4 turbolinks

My Javascript is only loading after refreshing the page in Rails. After looking into it, the recommend solution seems to be to use turbolinks. However, when I include the jquery-turbolinks gem, JQu...

Get filename from a file uploaded mule esb 3.6

java file-upload mule-studio

I'm trying to develop a rest layer using mule 3.6, where I receive a file upload throug a POST method.