doujiu3095
doujiu3095
2012-09-07 16:25
浏览 63
已采纳

如何让一个数据库查询使用pchart库创建两个图表?

I am quite new to pcharts and understand the mechanics. I nicely made a page where I show a single graph in my template by using the <img src='graph1.php'> logic.

I now have a pretty heavy query that provides me with the right data to create 4 charts. I only want to execute this query once (to minimize database load) and then have the four charts generated and loaded into my webpage. BTW. the query performance can not be improved, so that's no option.

I was thinking of query.php that generates 5 arrays (one for the common x-axis and 4 for each different graphs y-axis value).

But then I have no clue how I can pass these arrays on to the graph1.php, graph2.php, graph3.php and graph4.php files so the charts can be generated.

What is a smart way to do this? I'd rather not write (temporary) files to the server.

Thanks,

Geoffrey

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dongyan2267
    dongyan2267 2012-09-07 16:31
    已采纳

    Write the query result into the session and access it from the corresponding script. (Just make a check wether the data exists in the session and if not, execute the query just once)

    点赞 评论
  • dongyunwei8596
    dongyunwei8596 2012-09-07 16:31

    Strong suggestion: create a temporary table:

    The table will only persist for as long as the session.

    点赞 评论

相关推荐