MYSQL + GD = aneurysm

sois

I am having problems using mySQL and GD at the same time. Is there another way to do what I am trying to do? Here is my code:

// record and name at the top
$q1 = "select SUM(WIN),SUM(LOSS) from games where PLAYER='$player' group by PLAYER";
$r1 =  mysql_query($q1);
$a = mysql_fetch_array($r1);
$namerec = "$name ($a[0] - $a[1])";



// create, send headers, output & destroy
$im = imageCreateFromPNG("sig.png") ;
header('Content-type: image/png');
$namecolor = imageColorAllocate($im, 0, 255, 100);
imageString($im,5,15,5,$namerec,$namecolor);
imageString($im, 3, 120, 31,$rank, $namecolor);
imageString($im, 3, 120, 46,$ppg, $namecolor);
imageString($im, 3, 120, 61,$ypg, $namecolor);
imageString($im, 3, 120, 76,$status, $namecolor);
imagePNG($im);
imageDestroy($im);

The $name variable comes accross from the website and here is the link:
http://www.sois.com/tpc/sigs/sig.php?name=dooloos

It appears to work except I get an error message in the error log that says:
[03-Aug-2005 13:13:49] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sois/public_html/tpc/sigs/sig.php on line 12
[03-Aug-2005 13:13:49] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/sois/public_html/tpc/sigs/sig.php:12) in /home/sois/public_html/tpc/sigs/sig.php on line 24

Also, i can't save it as a file name... but that is another problem 🙁

Thanks guys! If anyone knows, you can post here or AOL IM me at "Tecmo CFP"

Thanks!

kburger

Change this line

$r1 = mysql_query($q1);

to this to see your query error

$r1 = mysql_query($q1) or die("Query failed: " . mysql_error());

sois

Nothing happens on the screen when I change that line, but there is an error message in the error log:

[03-Aug-2005 13:13:49] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sois/public_html/tpc/sigs/sig.php on line 12
[03-Aug-2005 13:13:49] PHP Warning: Cannot modify header information - headers already sent by (output started at /home/sois/public_html/tpc/sigs/sig.php:12) in /home/sois/public_html/tpc/sigs/sig.php on line 24

kburger

Then we must not be seeing the whole thing. Show us the entire script, or at least the part where you connect to the database. Also, use that die statement in the connection.

sois

<?PHP

@mysql_connect ('localhost','sois_query','PASSWORD')
	or die ("cant connect to mysql server");
@mysql_select_db ('sois_tpc')
	or die ("could not select database");

// record and name at the top
$q1 = "select SUM(WIN),SUM(LOSS) from games where PLAYER='$name' group by PLAYER";
$r1 = mysql_query($q1) or die("Query failed: " . mysql_error());
$a = mysql_fetch_array($r1);
$namerec = "$name ($a[0] - $a[1])";



// create, send headers, output & destroy
$im = imageCreateFromPNG("sig.png") ;
header('Content-type: image/png');
$namecolor = imageColorAllocate($im, 0, 255, 100);
imageString($im,5,15,5,$namerec,$namecolor);
imageString($im, 3, 120, 31,$rank, $namecolor);
imageString($im, 3, 120, 46,$ppg, $namecolor);
imageString($im, 3, 120, 61,$ypg, $namecolor);
imageString($im, 3, 120, 76,$status, $namecolor);
imagePNG($im);
imageDestroy($im);


?>

That is the whole thing 🙂 Thanks for your help

kburger

$name is never defined. Don't you need $name = $_GET['name']; before your query? Or is it there, just not posted above?

sois

$name comes through on the link

http://www.sois.com/tpc/sigs/sig.php?name=dooloos

if you click on it, you can see how the image has the name , but nothing else.

kburger

Only if register_globals is ON. I can't view it because of incorrect headers.

To temporarily simplify things, I'd comment out the GD stuff and put in some debugging echo statements to see what's going on. Echo your query, $name, etc.

drew010

you should also use [man]mysql_num_rows[/man] to make sure the query actually returns any results, otherwise you will get those errors if a person enters an existing name.

and from your first post, to save a gd image to a file, you pass a second argument to imagepng which denotes the filename. when you do this, the image data is written to file and not sent to the output stream, so if you wish to display the image as well as save it you will need to echo [man]file_get_contents[/man] passing the image file name.

sois

Ok everyone, I'm just going to start with the basics. For some reason this does not work:

 
<?PHP

header('Content-type: image/png');
@mysql_connect ('localhost','sois_query','PW')
	or die ("cant connect to mysql server");
@mysql_select_db ('sois_tpc')
	or die ("could not select database");


$namerec = $name; 

// create, send headers, output & destroy
$im = imageCreateFromPNG("sig.png") ;
$namecolor = imageColorAllocate($im, 0, 255, 100);
imageString($im, 5, 15,  5,  $namerec, $namecolor);
imageString($im, 3, 120, 31, $rank,    $namecolor);
imageString($im, 3, 120, 46, $ppg,     $namecolor);
imageString($im, 3, 120, 61, $ypg,     $namecolor);
imageString($im, 3, 120, 76, $status,  $namecolor);
imagePNG($im, "$name.png");
imageDestroy($im);



?>

It gives error message:

The image “http://www.sois.com/tpc/sigs/sig.php?name=test” cannot be displayed, because it contains errors.

It does create the file in the directory. For example, if the link is:

http://www.sois.com/tpc/sigs/sig.php?name=test

It makes the file test.png in the directory.

Lets see if starting at the beginning will make everything easier to understand.

drew010

i put this little part before but it may not have been noticed.

drew010 wrote:
to save a gd image to a file, you pass a second argument to imagepng which denotes the filename. when you do this, the image data is written to file and not sent to the output stream, so if you wish to display the image as well as save it you will need to echo [man]file_get_contents[/man] passing the image file name.

echo file_get_contents("$name.png");
will make it output the image it just saved.