jdorn / php-reports

A PHP framework for displaying reports from any data source, including SQL and MongoDB
http://jdorn.github.com/php-reports
GNU Lesser General Public License v3.0
477 stars 235 forks source link

Connect to multiple Databases #264

Open nehemiekoffi opened 6 years ago

nehemiekoffi commented 6 years ago

Hello team, Your work is very Helpful. I wish to be able to add other conection_string in order to query others database. Is it possible ?

bradstw commented 4 years ago

Yes you can. It is covered here in the documentation. http://jdorn.github.io/php-reports/#EnvironmentsandDatabases Once you have specified your environments, you can use them in your reports with the OPTIONS: header filter

-- Operations per day
-- Operations per day grouped by operation type
-- OPTIONS: {
--      database: "ado"
-- }