This topic is locked

Database & Chart legend

7/26/2007 12:45:45 AM
PHPRunner General questions
F
fjmatt author

Hi Everybody,

PHPRunner Version: 4.0.0.265 & 4.1.0.283
Question 1:

I would like to be able to connect to multiple databases to retrieve information. E.g. I have made Knowledge base and want to retrieve the usernames and passwords from a different database(pre-existing database) is this possible ?
Question 2:

I have created a number of charts and would like to have my own legend. At the moment it gets the names from the database, but these names are useful to me but not so much for the average user. Is there any possibility of this?

If more information is needed please let me know.
Thanks Matt

J
Jane 8/1/2007

Matt,
please see my answers below:

  1. unfortunately you can't connect to more than one database in the PHPRunner. As workaround you can edit generated file and replace following line with your connection string:
    $conn=db_connect();


2. you can use only database field names as labels on the charts. I recommend you to create new field in the database with full labels for the chart and then use this field in the Label field dropdown box on the Chart parameters tab.