dynamic graph in php

**parkerproject** · Dec 27, 2008 13:56

I want to create a dynamic graph for the date and total columns on the webpage
http://www.weblunar.com/forex2/track_record.php
this data in the table is pulled from the database.

here is the graph code(graph.php)

PHP Code:


<?php

# PHPlot Example: Bar chart, 3 data sets, shaded

require_once 'phplot.php';



$data = array(

  array('Jan', 40), array('Feb', 30), array('Mar', 20),

  array('Apr', 10), array('May',  3), array('Jun',  7),

  array('Jul', 10), array('Aug', 15), array('Sep', 20),

  array('Oct', 18), array('Nov', 16), array('Dec', 14),

);



$plot = new PHPlot(600, 300);

$plot->SetImageBorderType('plain');



$plot->SetPlotType('bars');

$plot->SetDataType('text-data');

$plot->SetDataValues($data);



# Main plot title:

$plot->SetTitle('Track record');



# Make a legend for the 3 data sets plotted:

//$plot->SetLegend(array('Engineering', 'Manufacturing', 'Administration'));



# Turn off X tick labels and ticks because they don't apply here:

$plot->SetXTickLabelPos('none');

$plot->SetXTickPos('none');



$plot->DrawGraph();



?>



and the code the table page[PHP]

<?php

require("inc/conn.php");

$page = 7;

//get this page's content from the database

$sql = "SELECT * FROM tblpages WHERE pageID = " .$page;

if ($result = mysql_query($sql)) {

    $row = mysql_fetch_array($result);

    $pageHeading = $row['pageHeading'];

    $pageContent = $row['pageContent'];

}



    //build and issue query

$sql = "SELECT * FROM trackrecord ORDER BY date";

$result = @mysql_query($sql) or die(mysql_error());

$num=mysql_numrows($result);

mysql_close();







require_once('header.php'); ?>

<style type="text/css">

<!--

@import url("css/table.css");

-->

</style>





<div id="content_alert">

      <div class="post1">

            <h1><?php echo $pageHeading; ?></h1>

            <table id="mytable" cellspacing="0" summary="">

<caption>Track record </caption>

<tr>

  <th scope="col" abbr="date">date</th>

  <th scope="col" abbr="currency pair">currency pair</th>

  <th scope="col" abbr="recommended lot size">entry price</th>

  <th scope="col" abbr="suggested entry">profit 1</th>

  <th scope="col" abbr="suggested stop">profit 2</th>

  <th scope="col" abbr="time of call">profit 3</th>

  <th scope="col" abbr="valid till">daily net</th>

  <th scope="col" abbr="target p1">total to date</th>

  

  </tr>

  

 <?

$i=0;

while ($i < $num) {



$field1 =mysql_result($result,$i,"date");

$field2 =mysql_result($result,$i,"pair");

$field3 =mysql_result($result,$i,"entry_price");

$field4 =mysql_result($result,$i,"profit_1");

$field5=mysql_result($result,$i,"profit_2");

$field6 =mysql_result($result,$i,"profit_3");

$field7 =mysql_result($result,$i,"daily_net");

$field8 =mysql_result($result,$i,"total_to_date");

?>





<tr>

  <td><? echo $field1; ?></td>

  <td><? echo $field2; ?></td>

  <td><? echo $field3; ?></td>

  <td><? echo $field4; ?></td>

  <td><? echo $field5; ?></td>

  <td><? echo $field6; ?></td>

  <td><? echo $field7; ?></td>

  <td><? echo $field8; ?></td>

  

 </tr>

 

<?

$i++;

}



echo "</table>";  

?>

<div class="">&nbsp;</div>



<div style="float: left; width: 400px;">

        <div><img src="includes/graph.php"></div>

    </div>

            

  </div>

 </div>

 

<?php require_once('footer.php'); ?>

thank you
[/PHP]

**bhanson** · Dec 27, 2008 14:03

Originally Posted by parkerproject

I want to create a dynamic graph for the date and total columns on the webpage
http://www.weblunar.com/forex2/track_record.php
this data in the table is pulled from the database.

here is the graph code(graph.php)

PHP Code:


<?php
# PHPlot Example: Bar chart, 3 data sets, shaded
require_once 'phplot.php';

$data = array(
  array('Jan', 40), array('Feb', 30), array('Mar', 20),
  array('Apr', 10), array('May',  3), array('Jun',  7),
  array('Jul', 10), array('Aug', 15), array('Sep', 20),
  array('Oct', 18), array('Nov', 16), array('Dec', 14),
);

$plot = new PHPlot(600, 300);
$plot->SetImageBorderType('plain');

$plot->SetPlotType('bars');
$plot->SetDataType('text-data');
$plot->SetDataValues($data);

# Main plot title:
$plot->SetTitle('Track record');

# Make a legend for the 3 data sets plotted:
//$plot->SetLegend(array('Engineering', 'Manufacturing', 'Administration'));

# Turn off X tick labels and ticks because they don't apply here:
$plot->SetXTickLabelPos('none');
$plot->SetXTickPos('none');

$plot->DrawGraph();

?>

and the code the table page[PHP]
<?php
require("inc/conn.php");
$page = 7;
//get this page's content from the database
$sql = "SELECT * FROM tblpages WHERE pageID = " .$page;
if ($result = mysql_query($sql)) {
    $row = mysql_fetch_array($result);
    $pageHeading = $row['pageHeading'];
    $pageContent = $row['pageContent'];
}

    //build and issue query
$sql = "SELECT * FROM trackrecord ORDER BY date";
$result = @mysql_query($sql) or die(mysql_error());
$num=mysql_numrows($result);
mysql_close();



require_once('header.php'); ?>
<style type="text/css">
<!--
@import url("css/table.css");
-->
</style>


<div id="content_alert">
      <div class="post1">
            <h1><?php echo $pageHeading; ?></h1>
            <table id="mytable" cellspacing="0" summary="">
<caption>Track record </caption>
<tr>
  <th scope="col" abbr="date">date</th>
  <th scope="col" abbr="currency pair">currency pair</th>
  <th scope="col" abbr="recommended lot size">entry price</th>
  <th scope="col" abbr="suggested entry">profit 1</th>
  <th scope="col" abbr="suggested stop">profit 2</th>
  <th scope="col" abbr="time of call">profit 3</th>
  <th scope="col" abbr="valid till">daily net</th>
  <th scope="col" abbr="target p1">total to date</th>
  
  </tr>
  
 <?
$i=0;
while ($i < $num) {

$field1 =mysql_result($result,$i,"date");
$field2 =mysql_result($result,$i,"pair");
$field3 =mysql_result($result,$i,"entry_price");
$field4 =mysql_result($result,$i,"profit_1");
$field5=mysql_result($result,$i,"profit_2");
$field6 =mysql_result($result,$i,"profit_3");
$field7 =mysql_result($result,$i,"daily_net");
$field8 =mysql_result($result,$i,"total_to_date");
?>


<tr>
  <td><? echo $field1; ?></td>
  <td><? echo $field2; ?></td>
  <td><? echo $field3; ?></td>
  <td><? echo $field4; ?></td>
  <td><? echo $field5; ?></td>
  <td><? echo $field6; ?></td>
  <td><? echo $field7; ?></td>
  <td><? echo $field8; ?></td>
  
 </tr>
 
<?
$i++;
}

echo "</table>";  
?>
<div class="">&nbsp;</div>

<div style="float: left; width: 400px;">
        <div><img src="includes/graph.php"></div>
    </div>
            
  </div>
 </div>
 
<?php require_once('footer.php'); ?>

thank you
[/PHP]

What's your question?

**parkerproject** · Dec 27, 2008 14:28

how can i make the x-axis and y-axis dynamic?

**bhanson** · Dec 27, 2008 14:43

Originally Posted by parkerproject

how can i make the x-axis and y-axis dynamic?

You're going to have to be more specific than that, what do you mean by dynamic?

The more detailed of a question you ask, the better answer you will get in return.

**parkerproject** · Dec 27, 2008 14:55

i want to put the information into arrays then output it on the both x and y axis.
i mean the information on the date column and also total to date column
you can view the table here
http://www.weblunar.com/forex2/track_record.php

**Mark Baker** · Dec 27, 2008 15:01

Why not take the easy approach, and use a library such as jpgraph for your graphing

**bhanson** · Dec 27, 2008 15:01

Originally Posted by parkerproject

i want to put the information into arrays then output it on the both x and y axis.
i mean the information on the date column and also total to date column
you can view the table here
http://www.weblunar.com/forex2/track_record.php

Isn't that what this is doing?

PHP Code:


$data = array(

  array('Jan', 40), array('Feb', 30), array('Mar', 20),

  array('Apr', 10), array('May',  3), array('Jun',  7),

  array('Jul', 10), array('Aug', 15), array('Sep', 20),

  array('Oct', 18), array('Nov', 16), array('Dec', 14),

);

I'm probably misunderstanding your question.

**parkerproject** · Dec 27, 2008 15:07

yes you are right,all i want now is do a loop within the array,don't know if it is possible

**Jake Arkinstall** · Dec 27, 2008 15:16

PHP Code:


$data = array();

while($row = $someloop){

    $data[$row['column']] = $row['data'];

}

**bhanson** · Dec 27, 2008 15:16

Originally Posted by parkerproject

yes you are right,all i want now is do a loop within the array,don't know if it is possible

Oh, I understand now, it would have been helpful if you had been really specific on what you were trying to do.

The answer is pretty simple:

PHP Code:


...
$data = array();

while ($i < $num) {
...
$field7 =mysql_result($result,$i,"daily_net");
$field8 =mysql_result($result,$i,"total_to_date");

$data[] = array($field1, $field8);

?>
...

And then comment out $data in your other file.

**parkerproject** · Dec 27, 2008 17:25

thanks a lot brad

**parkerproject** · Dec 27, 2008 17:40

i have tried the code,but is not retrieving and displaying the graph

PHP Code:


<?php

# PHPlot Example: Bar chart, 3 data sets, shaded

require_once 'phplot.php';

require_once('../inc/conn.php'); 





    //build and issue query

$sql = "SELECT * FROM trackrecord ORDER BY date";

$result = @mysql_query($sql) or die(mysql_error());

$num=mysql_numrows($result);

mysql_close();





$data = array();

$i=0;

while ($i < $num) {

$field1 =mysql_result($result,$i,"date");

$field8 =mysql_result($result,$i,"total_to_date");



$data[] = array($field1, $field8);

}



/*$data = array(

  array('Jan', 40), array('Feb', 30), array('Mar', 20),

  array('Apr', 10), array('May',  3), array('Jun',  7),

  array('Jul', 10), array('Aug', 15), array('Sep', 20),

  array('Oct', 18), array('Nov', 16), array('Dec', 14),

);*/

**parkerproject** · Dec 27, 2008 18:12

i adjusted it to

PHP Code:


$data = array();

$i=0;

while ($i < $num) {

$field1 =mysql_result($result,$i,"date");

$field8 =mysql_result($result,$i,"total_to_date");

$i++;



$data[] = array($field1, $field8);

}

and it worked

**Jake Arkinstall** · Dec 28, 2008 08:34

You need to be more efficient with your querying.

PHP Code:


$sql = "SELECT date, total_to_date FROM trackrecord ORDER BY date"; 

$result = mysql_query($sql) or die(mysql_error()); 

$data = array(); 

while($row = mysql_fetch_assoc($result)) {

    $data[] = $row;

}

**mason.sklut** · Dec 28, 2008 11:56

For time's sake, take a look at Google's Graph API.

http://code.google.com/apis/chart/

It will save you time, and make your app more efficient!

- Mason

User Tag List

Thread: dynamic graph in php

Thread Tools

Display

dynamic graph in php

Bookmarks

Bookmarks

Posting Permissions