Including a class throws the GD!

[sarahk]

I've downloaded a class called phpChartPlus from phpClasses and have read the article at phpBuilder.com and have successfully created a chart! using hard coded data.

However it wouldn't work when I used mySQL to generate the data. Couldn't work out why so decided to comment out all the code and release it line by line. Got the hardcoded bit working, then uncommented:

include('../v2/dbsql.php');

Well - this broke it!
The file does nothing other than define the class. No objects or variables created etc - so why is it that my code no longer works!???

Any ideas, anyone?

[Sxooter]

I think you're breaking some rule about includes not being able to get out of their little boxes, which the ../ at the beginning of you path is likely causing.

I.e. if you php include path is

/usr/local/lib/php:./

then you need to have your includes in either /usr/local/lib/php OR the local directory, OR a subdirectory of one of those.

But I'm just guessing.

[sarahk]

Aaah, too good to be true. (thanks, tho')

Copied dbsql down to the directory - simpler than mucking about with paths - worry about that later 🙂 - but no improvement.

Any other ideas?

[Sxooter]

Show us the exact include statement, the file and a pwd to show what directory it's in. Can't think of much else.

[sarahk]

gosh, have been tackling this manually and it's not much fun (given the time I have available)

attached is my copy of dbsql. I have the passwords stored in it normally, I've taken these out 🙂

but my code really is what I had before:

<?php
//WORKS IF i COMMENT OUT THIS LINE
include('dbsql.php');

//replace the array with manual data, no change in visible result
$xdata1 = array("2003-03",
	"2003-02",
	"2003-01",
	"2002-12",
	"2002-11",
	"2002-10",
	"2002-09",
	"2002-08",
	"2002-07",
	"2002-06",
	"2002-05",
	"2002-04");

$chart_data = array( array(2, 65), 
	array(4, 156), 
	array(17, 149), 
	array(27, 245),
	array(35, 267),
	array(81, 245),
	array(170, 272),
	array(146, 309),
	array(0, 0),
	array(0, 0),
	array(0, 0),
	array(0, 0)
	);
$legend = array("ddr", "pcpmsales");
$agentColors = array("red", "green");

include ("./classes/phpchartplus.php");
$im=new phpchartplus("png","bar",500,350,30,20);

$im->set_chart_data(6,$chart_data);
$im->set_x_labels_data(" ");
$im->set_x_labels_data($xdata1, true);
$im->set_y_labels_data(0,350,"round");
$im->set_chart_properties("lightgrey","black","black","white","",0);
$im->set_bar_color($agentColors);
$im->set_font_properties(5,6);
$im->chart_title("Downloads per Agent per Month");
$im->set_data_status($legend);
$im->create_chart();
?>

[sarahk]

and here's the graph class

[Sxooter]

I think it may be there are globals or something conflicting between your two includes here. Not sure though.

[sarahk]

thanks Sxooter for your help, I'll look into this further, maybe even write my own query code rather than use the class (shock horror!).