bar chart php error problem

david4u

I am trying to plot a bar graph with Jpgraph software but could not get it working well.

Some bit of my code is here below but it is generating this type of error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\HEAVEN\SURVEY_TEST\websurvey\admin\graph.php on line 36
JpGraph Error Empty input data array specified for plot. Must have at least one data point.

This is part of the code here:

/ Create a query string
$sql_query = "SELECT * FROM question_answers_survey";

//$sql = mysql_query("SELECT * FROM question_answers_survey") die(mysql_error());

while($row = mysql_fetch_array($sql_query))
{
$data[] = $row[1];
$leg[] = $row[0];
}

$graph = new Graph(250,150,"auto");
$graph->SetScale("textint");
$graph->img->SetMargin(50,30,50,50);
$graph->AdjBackgroundImage(0.4,0.7,-1); //setting BG type
$graph->SetBackgroundImage("linux_pez.png",BGIMG_FILLFRAME); //adding image
$graph->SetShadow();

$graph->xaxis->SetTickLabels($leg);

$bplot = new BarPlot($data);

So line 36 is :
while($row = mysql_fetch_array($sql_query))

What can I do to correct the error and to have a bar chart graph with different colours sets. I am new to JPgraph.
I will be glad if anyone can help.
Thanks.

Blulagoon

Try the following:

$sql = mysql_query("SELECT * FROM question_answers_survey"); 

while($row = mysql_fetch_array($sql)) 
{ 
$data[] = $row[1]; 
$leg[] = $row[0]; 
}

Blu

n.b. When using something like this, it is always better to be more specific with your query, i.e. SELECT named_col1,named_col2 from mytable than *.

david4u

Thanks, that a better idea. I will correct it.

Thanks.

But one more thing the bar graph is not showing anything yet. What can I do?

Blulagoon

Is this the last line of code ?

$bplot = new BarPlot($data);

If it is, you haven't asked the script to draw the graph yet!

Blu

Blulagoon

To show you what I mean, here is a bar chart I've done which not only takes the db and labels from the db, but the column colours too.

$graph = new Graph(300,350,"auto");

$graph->SetScale("textint",1,9);
$graph->SetMargin(30,20,20,60);
$graph->SetMarginColor('#F8FCE6');
$graph->SetBackgroundGradient('#F8FCE6','#F8FCE6',GRAD_HOR,BGRAD_PLOT);

$graph->xaxis->SetTickLabels($leg);
$graph->xaxis->SetLabelAngle(45);
$graph->xaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->xaxis->SetColor('blue:0.6');
$graph->xaxis->SetColor('blue:0.6');
$graph->yaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->yaxis->SetColor('blue:0.6');
$graph->ygrid->Show(false);

$bplot = new BarPlot($data);
$bplot->SetFillColor($bar_cols); // Fill color
$bplot->SetShadow($bar_colsa);
$bplot->value->Show();
$bplot->value->SetFont(FF_ARIAL,FS_BOLD,8);
$bplot->value->SetColor("blue:0.6","black");
$bplot->value->SetAngle(45);
$bplot->SetWidth(0.88);

$graph->Add($bplot);
$graph->Stroke();

HTH - Blu

david4u

Alright. Let me check my code and also test using some missing part of mine with

yours.

Thank you.

Blulagoon

Remember that SetFillColor and SetShadow have to be changed from mine, as I had an entry for each of these in the database as well as the data and the legend.

$bplot->SetFillColor('red');
$bplot->SetShadow('blue');

should work OK

david4u

This is the code below

<?php

include ("C:/Program Files/xampp/htdocs/HEAVEN/SURVEY_TEST/websurvey/admin/jpgraph-2.1.1/src/jpgraph.php");
include ("C:/Program Files/xampp/htdocs/HEAVEN/SURVEY_TEST/websurvey/admin/jpgraph-2.1.1/src/jpgraph_bar.php");

// Create a query string
$sql_query = "SELECT id_question,answer FROM question_answers_survey";

$res = mysql_query($sql_query) or die(mysql_error());

while($row = mysql_fetch_assoc($res))
{
$data[] = $row[1];
$leg[] = $row[0];
}

$graph = new Graph(300,350,"auto");

$graph->SetScale("textint",1,9);
$graph->SetMargin(30,20,20,60);
$graph->SetMarginColor('#F8FCE6');
$graph->SetBackgroundGradient('#F8FCE6','#F8FCE6',GRAD_HOR,BGRAD_PLOT);

$graph->xaxis->SetTickLabels($leg);
$graph->xaxis->SetLabelAngle(45);
$graph->xaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->xaxis->SetColor('blue:0.6');
$graph->xaxis->SetColor('blue:0.6');
$graph->yaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->yaxis->SetColor('blue:0.6');
$graph->ygrid->Show(false);

$bplot = new BarPlot($data);
$bplot->SetFillColor('red'); // Fill color
$bplot->SetShadow('blue');
$bplot->value->Show();
$bplot->value->SetFont(FF_ARIAL,FS_BOLD,8);
$bplot->value->SetColor("blue:0.6","black");
$bplot->value->SetAngle(45);
$bplot->SetWidth(0.88);

$graph->Add($bplot);
$graph->Stroke();

// Close the connection
mysql_close($mysql_conn) or die("Error whilst closing connection: " . mysql_error());

I have removed the connection bit..

It is showing an empty bar chart......is there is more things that needs to be in place?

Pls do help. And how do you get you code to be in different colors while mine is still in black...

Blulagoon

My code is surrounded by php tags. I'm using spaces between the [ and the php otherwise they wouldn't display. use [ php ] my code [ /php ]

As you are using mysql_fetch_assoc I think you need to change your code to:

$sql_query = "SELECT id_question,answer FROM question_answers_survey"; 

$res = mysql_query($sql_query) or die(mysql_error()); 

while($row = mysql_fetch_assoc($res))
{ 
$data[] = $row['answer']; 
$leg[] = $row['id_question']; 
}

alternatively you could use mysql_fetch_array with the indexes of [0] and [1]

Before you try and run the jpgraph code, it might be a good idea to bug test your arrays as follows:

print_r($data);
echo "<br>";
print_r($leg);

HTH - Blu

n.b. I really like JP Graph and use it a lot.

david4u

It is still generating error in line that says

$leg[] = $row['id_question'];

It says invalid arguement..... what is wrong?

Blulagoon

The code you need for your php code is [/code] to end it and the same without the / to open it.

Best thing I can suggest for now is you try this:

$sql_query = "SELECT id_question,answer FROM question_answers_survey"; 

$res = mysql_query($sql_query) or die(mysql_error()); 

while($row = mysql_fetch_assoc($res)) 
{ 
echo $row['answer']; 
echo "<br>";
echo $row['id_question']; 
echo "<br>";
}

I am assuming id_question is the name of one of the columns in your table question_answers_survey, if it isn't the query won't work. By echoing out the values of the array variables, you can see what the script is trying to do.

Its also a good idea, if you are getting an error, to say what the error is. Neither PHP nor MySQL are Microsoft products, so the error messages are usually quite informative ......

Blu

david4u

The code you suggested below works now. Thanks.


 $sql_query = "SELECT id_question,answer FROM question_answers_survey";

$res = mysql_query($sql_query) or die(mysql_error());

while($row = mysql_fetch_assoc($res))
{
echo $row['answer'];
echo "<br>";
echo $row['id_question'];
echo "<br>";
}

Thanks.

So, how can I test using pie chart or any other graph...what will I need to be changing in the code?

Blulagoon

Are you still getting the invalid argument with:
$leg[] = $row['id_question'];

Is the graph working, if not pls post your complete code so we can try and see what is happening. Does print_r($leg); work.

Blu

david4u

This is the code below:

It seems ok but did not show the bar in percentage and the colours are not the way I was expecting.

I want two diferent colours to each column so that we can differential which is is which. Also how can I change this same code to draw a pie chart or any other chart available with Jpgraph....Do explain to me please....


include ("C:/Program Files/xampp/htdocs/HEAVEN/SURVEY_TEST/websurvey/admin/jpgraph-2.1.1/src/jpgraph.php");
include ("C:/Program Files/xampp/htdocs/HEAVEN/SURVEY_TEST/websurvey/admin/jpgraph-2.1.1/src/jpgraph_bar.php");

// Create a query string 
$sql_query = "SELECT id_question,answer FROM question_answers_survey"; 

$res = mysql_query($sql_query) or die(mysql_error()); 

while($row = mysql_fetch_assoc($res))
{ 
$data[] = $row['id_question'];
$leg[] = $row['answer']; 
} 

//print_r($data);
//echo "<br>";
//print_r($leg);




//$graph = new Graph(250,150,"auto"); 
//$graph->SetScale("textint"); 
//$graph->img->SetMargin(50,30,50,50); 
//$graph->AdjBackgroundImage(0.4,0.7,-1); //setting BG type 
//$graph->SetBackgroundImage("trans.gif",BGIMG_FILLFRAME); //adding image 
//$graph->SetShadow(); 

//$graph->xaxis->SetTickLabels($leg); 

//$bplot = new BarPlot($data); 
//$bplot->SetFillColor("lightgreen"); // Fill color 
//$bplot->value->Show(); 
//$bplot->value->SetFont(FF_ARIAL,FS_BOLD); 
//$bplot->value->SetAngle(45); 
//$bplot->value->SetColor("black","navy"); 

//$graph->Add($bplot); 
//$graph->Stroke();

$graph = new Graph(300,350,"auto");

$graph->SetScale("textint",1,9);
$graph->SetMargin(30,20,20,60);
$graph->SetMarginColor('#F8FCE6');
$graph->SetBackgroundGradient('#F8FCE6','#F8FCE6',GRAD_HOR,BGRAD_PLOT);

$graph->xaxis->SetTickLabels($leg);
$graph->xaxis->SetLabelAngle(45);
$graph->xaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->xaxis->SetColor('blue:0.6');
$graph->xaxis->SetColor('blue:0.6');
$graph->yaxis->SetFont(FF_ARIAL,FS_NORMAL,8);
$graph->yaxis->SetColor('blue:0.6');
$graph->ygrid->Show(false);

$bplot = new BarPlot($data);
$bplot->SetFillColor('red'); // Fill color
$bplot->SetShadow('blue');
$bplot->value->Show();
$bplot->value->SetFont(FF_ARIAL,FS_BOLD,8);
$bplot->value->SetColor("blue:0.6","black");
$bplot->value->SetAngle(45);
$bplot->SetWidth(0.88);

$graph->Add($bplot);
$graph->Stroke();



// Close the connection
mysql_close($mysql_conn) or die("Error whilst closing connection: " . mysql_error());

 ?>

Is the include correct as well?

Blulagoon

Is this the right way round, or should the leg be 'id_question' and the data 'answer'
If you want percentages out, you need to have the $data array populated with percentages. $Leg here contains the label or legend for each bar in the chart, if it were a sales chart the legends might be North, Central, South. $data contains the value for each bar.
```
$data[] = $row['id_question']; 
$leg[] = $row['answer']; 
// Is this the right way round ?
```
```
$graph = new Graph(300,350,"auto"); 
// graph is created 300 pixels by 350 pixels in size
// you can have anything you want here
$graph->SetScale("textint",1,9); 
// graph scale is set to be lowest 1, highest 9.
// SetScale("textint",0,100); might better meet your requirements.
```
The following two lines set the colour of the bar, they should be red with a blue shadow giving a 3d effect.
```
$bplot->SetFillColor('red'); // Fill color 
$bplot->SetShadow('blue'); 
```
Most people would use an array for the colours, to make the columns different colours. SetShadow is optional, delete that line if you like.
```
$colours=array('red','blue');
$bplot->SetFillColor($colours);
// gives columns alternating between red and blue
```
At this point I'm going to point you to the JP Graph help file, as this is really good. It gives example code that works for every chart type available in JP Graph, bar charts, pie and 3D pie for example, and tells you which files you need to include. Working with colours is a great section, they have about 1000 named colours, to make your graphs really great, and themes to make your pie charts really co-ordinated for the colour blind amongst us. Look for the docs folder under your JP Graph directory, and for index.html within that.

HTH - Blu

david4u

Thanks alot. I appreciate your help and i t has paid off.

I quiet understand how it works now and all your suggestions are very helpfull.

The graph is alright now and I can do what I needed on it.

Thanks so much, you have been a good mentor.................

Dav